动态查询输出数据
2020-11-09
来源：小奈知识网
动态查询输出字符串 无 declare?@sql1?nvarchar(200),@sql2?nvarchar(200)declare?@count?nvarchar(100);set?@sql1?=?'SELECT?CONVERT(varchar(100),?GETDATE(),?0)'set?@sql2?=?'SELECT?@count?=?CONVERT(varchar(100),?GETDATE(),?0)'exec?sp_executesql??@
动态查询输出字符串 <无> $velocityCount-->declare?@sql1?nvarchar(200),@sql2?nvarchar(200) declare?@count?nvarchar(100); set?@sql1?=?'SELECT?CONVERT(varchar(100),?GETDATE(),?0)' set?@sql2?=?'SELECT?@count?=?CONVERT(varchar(100),?GETDATE(),?0)' exec?sp_executesql??@sql2,N'@count?nvarchar(50)?out',@count?out print?@sql1?+'：'+?@count
显示全文