SQL Server Stored Procedures instance

最新推荐文章于 2023-07-28 11:15:00 发布

WuOu

最新推荐文章于 2023-07-28 11:15:00 发布

阅读量660

点赞数

分类专栏： Data 文章标签： sql server parameters performance insert delete date

本文链接：https://blog.csdn.net/WuOu/article/details/2745652

版权

Data 专栏收录该内容

20 篇文章 0 订阅

订阅专栏

-- =============================================
-- Author:        Kelvin
-- Create date: 2008-7-30
-- Description:    Test performance to insert 100,000 records.
-- =============================================
ALTER PROCEDURE [dbo].[DeleteLargeDataFromRolePurviewMappingTable]
    -- Add the parameters for the stored procedure here
    @NumberOfRecord int
AS
BEGIN
DECLARE @count int
SET @count=0
DECLARE @StartTime datetime
SET @StartTime=getdate()
DELETE FROM [RolePurviewMapping] WHERE RoleName=N'TestPerformance'
DECLARE @EndTime datetime
SET @EndTime=getdate()
SELECT 'StartTime'=@StartTime,'EndTime'=@EndTime
END

-- =============================================
-- Author:        Kelvin
-- Create date: 2008-7-30
-- Description:    Test performance to insert 100,000 records.
-- =============================================
CREATE PROCEDURE [dbo].[DeleteLargeDataFromRolePurviewMappingTable]
    -- Add the parameters for the stored procedure here
    @NumberOfRecord int
AS
BEGIN
DECLARE @count int
SET @count=0
DECLARE @StartTime datetime
SET @StartTime=getdate()
DELETE FROM [RolePurviewMapping] WHERE RoleName=N'TestPerformance'
DECLARE @EndTime datetime
SET @EndTime=getdate()
SELECT 'StartTime'=@StartTime,'EndTime'=@EndTime
END