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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 float

Author  Topic 

kemi2299
Starting Member

41 Posts

Posted - 2008-05-14 : 05:21:59
i need help in changing this to tsql

pcode_ok = sum(pcode_flag), pcode_p = float4(null),

thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-05-14 : 05:23:11
pcode_ok = sum(pcode_flag), pcode_p = cast(null as float),


b.w why are you casting null value to float?
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-05-14 : 05:26:41
Can be useful for disconnected recordsets.
Then the dataadapter knows for sure which dataytype the columns is.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

kemi2299
Starting Member

41 Posts

Posted - 2008-05-14 : 05:56:07
what should float be cast as
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-05-14 : 07:03:42
quote:
Originally posted by kemi2299

what should float be cast as



didnt get what yu're asking. I just asked wht was need for casting a null value. But got the answer from peso.
Go to Top of Page
   

- Advertisement -