如以下这句:@str nvarchar(1000)
set @str='select TopicID from ttt where ID='+@ID+' ORDER BY lastposttime desc'这样就不行,一定改成
ID='+ CONVERT(nvarchar,@ID) +'但ID我之前已经声明为 int 了。
难道每次set @str =时 都要重新转换吗?那样不是太麻烦了?
set @str='select TopicID from ttt where ID='+@ID+' ORDER BY lastposttime desc'这样就不行,一定改成
ID='+ CONVERT(nvarchar,@ID) +'但ID我之前已经声明为 int 了。
难道每次set @str =时 都要重新转换吗?那样不是太麻烦了?
set @str='select TopicID from ttt where ID='+cast(@ID as varchar)+' ORDER BY lastposttime desc' set @str='select TopicID from ttt where ID='+convert(varchar,@ID)+' ORDER BY lastposttime desc' 这两种.
這本來就是說不過去的.
declare @id int, @tmp_id varchar(05)
set @id=10
set @tmp_id=convert(varchar(05),@id)
...