Hi,
Declare @ii varcahr(2)
Select @ii = 2
when I execute the above SQl statement, it returns error in SQL 6.5.
Doesn't seem to be same in SQL7.0
Someone, Pls help
thanks
Printable View
Hi,
Declare @ii varcahr(2)
Select @ii = 2
when I execute the above SQl statement, it returns error in SQL 6.5.
Doesn't seem to be same in SQL7.0
Someone, Pls help
thanks
Hi,
I believe SQL Server 7 implicitely converts a variable with a datatype of 'int' to a datatype of 'varchar'. In SQL Server 6.5 you were required to use explicit conversion via the Convert function. In order for the below sql to execute successfully in 6.5 you would change it to:
Declare @ii varchar(2)
Select @ii = convert(varchar,2)
andrew
------------
MMS at 9/5/99 10:29:10 PM
Hi,
Declare @ii varcahr(2)
Select @ii = 2
when I execute the above SQl statement, it returns error in SQL 6.5.
Doesn't seem to be same in SQL7.0
Someone, Pls help
thanks