Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Vinayak Jog
Starting Member
2 Posts |
 Posted - 2012-09-07 : 05:35:11
|
| select column_name, null from table_name;what is the use of null here ?Vinayak Jog |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-09-07 : 05:40:57
|
In the given example the result set will have a second column with no column name and NULL as value in every returned row.The sense - I don't know...
Too old to Rock'n'Roll too young to die. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-08 : 17:23:20
|
quote:
Originally posted by Vinayak Jog
select column_name, null from table_name;what is the use of null here ?Vinayak Jog
its just a place holder here and i hope this is part of table insert. in that case there might be an update step following this to set the column value based on some logic------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Vinayak Jog
Starting Member
2 Posts |
Posted - 2012-09-10 : 05:35:46
|
| Thanks for all the replies, visakh16's reply seems more appropriate. Thank you to all the sqlteam.Vinayak Jog |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-10 : 10:12:06
|
| welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Query meaning