弹指一挥间

摘要： 定义一个存储过程如下: create proc [dbo].[test1]@id intasselect 1 as id,'abc' as name union allselect @id as id,'zzz' as name 返回两行数据.现在想用SQL语句来调用这个存储过程,并把他返回的表放入变量中.可以如下做: declare @table table(id int,name varc... 阅读全文