各位,我想写个存储过程,让输出参数告诉前台程序,有多少条记录生效。
请问这个函数是什么?
比如,我写了insert语句,想知道最终多少条记录插入了。
ALTER PROCEDURE [dbo].[Sp_SyncBas_sku]
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO Bas_Sku SELECT a.* from Temp_Sku a left join Bas_Sku b on a.Material = b.Material where b.Material is null
DELETE FROM DBO.Temp_Sku
--如何得到有多少条记录被插入,有多少条记录被删除?
END
GO
请问这个函数是什么?
比如,我写了insert语句,想知道最终多少条记录插入了。
ALTER PROCEDURE [dbo].[Sp_SyncBas_sku]
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO Bas_Sku SELECT a.* from Temp_Sku a left join Bas_Sku b on a.Material = b.Material where b.Material is null
DELETE FROM DBO.Temp_Sku
--如何得到有多少条记录被插入,有多少条记录被删除?
END
GO
select @@ROWCOUNT
请贴代码。谢!
INSERT INTO Bas_Sku SELECT a.* from Temp_Sku a left join Bas_Sku b on a.Material = b.Material where b.Material is null
select @@ROWCOUNT as insert_nums
DELETE FROM DBO.Temp_Sku
select @@ROWCOUNT as delete_nums