declare @i int set @i='a' set @i=cast('a' as int) set @i=convert(int, 'a') print @i --输出结果为：将 varchar 值 'a' 转换为数据类型为 int 的列时发生语法错误。这一点与java不一样declare @ch varchar(90) set @ch=97 print @ch--显示结果..
Declare @Id varchar(20) Declare @Name varchar(20) Declare Cur Cursor For select substring(id,0,7) as id,name from temp1 Open Cur Fetch next From Cur Into @Id,@Name While @@fetch_status=0 Begin Update temp Set [c3]=@Name where [id]..
