Are "" , 0, NULL one and the same thing in SQL Server?

Posted By: Avi

Date: 1 October 2010 12:20:08 PM

Answer:

No, all the three are treated diffrently. "":- means empty string 0:- represents 0 value NULL:- represent UNdefined Value
Posted By: avibtech	Date: 1 October 2010 12:20:08 PM

Post a better Answer if you have

Name*

E-mail* (Will show your Gravatar icon)

Website

Country

Notify me when new Answers are added

Enter the text as shown in the image

What is UPDATE_STATISTICS command?

This command is used when we are dealing with large amount of data, i.e. when deletion or copying of....

Category: SQL Server

Date: 10/1/2010 11:00:06 AM

No , both are different commands being used in SQL Server. Delete command is used to delete the row....

Category: SQL Server

Date: 10/1/2010 10:55:06 AM

1433 is the TCP/IP port which is required to run SQL Server . Yes, default port can be changed for ....

Category: SQL Server

Date: 10/1/2010 10:54:06 AM

Variable-length data with a maximum of 8,000 characters.

Category: SQL Server

Date: 10/30/2009 7:51:03 AM

SQL Server supports following two type of authentication mechanisms: 1) Windows Authentication (via....

Category: SQL Server

Date: 10/15/2009 4:43:44 AM

View All Questions >>

Signup for our weekly email newsletter