go ahead... be a heretic | |
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | Need Help?? |
This has nothing to do with perl, but the real reason why you get "incorrect syntax near cast" is that you need to use CAST in a select statement - just using CAST by itself makes no sense.
So something like would produce reasonable output. Of course me I'd have declared @number_of_years as INT, and then used convert() or cast() in the assignments directly... Michael In reply to Re: Datatypes. A Perl T-SQL comparison
by mpeppler
|
|