DotNetShoutout - Default datatype of NULL

Welcome!

DotNetShoutout is a place where you can find the latest Microsoft .NET stories to increase your skills and share your opinions.

Enjoy participating in this community and see which other people in our industry are getting Shoutouts.

7
Shouts

Shout it

Default datatype of NULL

posted by

dhara 563 days, 14 hours, 49 minutes ago

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 temporary...

category: Data | clicked: 5 | | source: beyondrelational.com

| show counter code

tags: SQL Server

Border color:

Shout it Backcolor:

Shout it Forecolor:

Count Backcolor:

Count Forecolor:

Preview

DotNetShoutout