Category: SQL Server

How to Check if the table exists in SQL Server ?

Published on December 13, 2013 by abundantcode

Filed under SQL Server

Last modified December 13, 2013


rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 4191 times

Equivalent of IF Statement in SQL Server

Published on December 12, 2013 by abundantcode

Filed under SQL Server

Last modified December 12, 2013


rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 3981 times

What is the Difference between varchar and nvarchar in SQL Server?

Published on December 12, 2013 by abundantcode

Filed under SQL Server

Last modified December 12, 2013


rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 3966 times

How to Enable All Constraints back in the Database in SQL Server ?

Published on December 11, 2013 by abundantcode

Filed under SQL Server

Last modified December 11, 2013


rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 3853 times

How to Disable All Constraints in the Database temporarily in SQL Server ?

Published on December 11, 2013 by abundantcode

Filed under SQL Server

Last modified December 11, 2013


rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 3939 times

How to Add a Column with Default Value to Existing Table in SQL Server ?

Published on December 11, 2013 by abundantcode

Filed under SQL Server

Last modified December 11, 2013


rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 4116 times

How to Update From Select Statement in SQL Server ?

Published on December 11, 2013 by abundantcode

Filed under SQL Server

Last modified December 11, 2013


rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 3877 times

How to find if the Column Exists in a table in SQL Server?

Published on June 9, 2013 by abundantcode

Filed under SQL Server

Last modified June 9, 2013


rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 4051 times

What are the different Normalization form in RDBMS ?

Published on March 6, 2013 by abundantcode

Filed under SQL Server

Last modified March 6, 2013


rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 3696 times

What is Normalization ?

Published on March 6, 2013 by abundantcode

Filed under SQL Server

Last modified March 6, 2013


rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 3483 times