select convert(nvarchar(10),N'最末') as dayday ---------- 最末(所影响的行数为 1 行)多了引号.
declare @sql nvarchar(4000) set @sql='select convert(nvarchar(10),N''最末'') as day' print @sql exec(@sql)select convert(nvarchar(10),N'最末') as day day ---------- 最末
能用我的方法么?不是直接select
declare @sql nvarchar(4000) set @sql=' select convert(nvarchar(10),N'最末') as day' print @sql exec(@sql) 没有用~~~
to dawugui(潇洒老乌龟) ( 有问题啊
你的语句在我的SQL SERVER2005 中显示'最未'
print的结果是 select convert(nvarchar(10),N'最末') as day
print 出来是 select convert(nvarchar(10),N'??') as day
没看懂,惭愧啊! 继续学习ing!
知道了 呵呵 declare @sql nvarchar(4000) set @sql=N' select convert(nvarchar(10),N'最末') as day' print @sql exec(@sql)
----------
最末(所影响的行数为 1 行)多了引号.
set @sql='select convert(nvarchar(10),N''最末'') as day'
print @sql
exec(@sql)select convert(nvarchar(10),N'最末') as day
day
----------
最末
set @sql=' select convert(nvarchar(10),N'最末') as day'
print @sql
exec(@sql)
没有用~~~
有问题啊
select convert(nvarchar(10),N'最末') as day
select convert(nvarchar(10),N'??') as day
继续学习ing!
declare @sql nvarchar(4000)
set @sql=N' select convert(nvarchar(10),N'最末') as day'
print @sql
exec(@sql)