|
|
|
CREATE PROCEDURE dbo.sp_test
@col1 NVARCHAR(50), @col2 NVARCHAR(50), @col3 NVARCHAR(50), @col4 NVARCHAR(50)
AS
BEGIN
SET NOCOUNT ON
IF EXISTS (SELECT 1 FROM bulkinsert WHERE (col1 = @col1) and (col3 = @col3) and (col4 = @col4) )
RAISERROR('This value already exists.', 11, 1)
ELSE
INSERT bulkinsert(col1,col2,col3,col4) VALUES(@col1,@col2,@col3,@col4)
END
GO
create PROCEDURE dbo.sp_test
@col1 NVARCHAR(50), @col2 NVARCHAR(50), @col3 NVARCHAR(50), @col4 NVARCHAR(50)
AS
BEGIN
SET NOCOUNT ON
IF not EXISTS (SELECT 1 FROM bulkinsert WHERE (col1 = @col1) and (col3 = @col3) and (col4 = @col4) )
INSERT bulkinsert(col1,col2,col3,col4) VALUES(@col1,@col2,@col3,@col4)
END
GO
|
|
|
|
|
|
CREATE UNIQUE NONCLUSTERED INDEX [IX_bulkinsert] ON [dbo].[bulkinsert]
(
[col1] ASC,
[col3] ASC,
[col4] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
|
|
|
|
|
|
