As you know NULL is the absence of data and any datatype can be NULL. But by default a NULL value is considered to be of INT datatype. Let us run the following code select null as t into #t GO exec tempdb..sp_help #t A NULL value is copied to a t...

As you know NULL is the absence of data and any datatype can be NULL. But by default a NULL value is considered to be of INT datatype. Let us run the following code select null as t into #t GO exec tempdb..sp_help #t A NULL value is copied to a t...

...

...

Changing database options to make it read-only, or taking a database offline? If you are using sp_dboption, your code will not work with SQL Server 2012. Use ALTER DATABASE...SET statement instead....

Changing database options to make it read-only, or taking a database offline? If you are using sp_dboption, your code will not work with SQL Server 2012. Use ALTER DATABASE...SET statement instead....

Changing database options to make it read-only, or taking a database offline? If you are using sp_dboption, your code will not work with SQL Server 2012. Use ALTER DATABASE...SET statement instead....

The way I ask this question is "What is the difference between a traditional table and a heap?" - you will be surprised to know how many get it wrong....

If a table has no clustered index defined on it, What it will be called?...

If a table has no clustered index defined on it, What it will be called?...