常用系统存储过程

1、如果获取sp_executesql 执行sql后的返回值:
declare @sql nvarchar(1024)
set @sql = 'select @a=count(1) from t_phone'
declare @a int
exec sp_executesql @sql,N'@a int output', @a output
print @a