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 |
DBA007
Posting Yak Master
145 Posts |
Posted - 2008-12-23 : 05:14:28
|
Hi All,Can any one tell me what is the use and Definition of Coalesce in sqlserver |
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2008-12-23 : 05:27:54
|
coalesce will return the first non null value in the functionand refer books online further data |
|
|
Jai Krishna
Constraint Violating Yak Guru
333 Posts |
Posted - 2008-12-23 : 05:32:48
|
Refer Books On Line For ExDECLARE @var1 INT,@var2 INTSELECT @var1 = 10SELECT COALESCE(@var2,@var1)The Above Query Selects The First Non Null ValueJai Krishna |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-12-24 : 04:23:35
|
quote: Originally posted by DBA007 Hi All,Can any one tell me what is the use and Definition of Coalesce in sqlserver
Did you search it in google?MadhivananFailing to plan is Planning to fail |
|
|
|
|
|