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 5863 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 5715 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 5585 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 5583 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 5653 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 5809 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 5600 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 5697 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 5315 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 5074 times