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 7116 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 6945 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 6772 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 6769 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 6871 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 7028 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 6819 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 6875 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 6488 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 6221 times