sql 存储过程参数为表,如何调试,选中某个存储过程,右键执行存储过程
USE [hzlhyh]
GO
DECLARE @return_value INT
DECLARE @table AS MyCustomType(用户定义表类型)
INSERT INTO @table SELECT *
FROM test;
EXEC @return_value = [dbo].[sp_AccountNow]
@User = @table
SELECT 'Return Value' = @return_value
GO