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 4750 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 4609 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 4506 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 4473 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 4552 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 4708 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 4500 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 4599 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 4230 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 4011 times