Digital Colony!

Test Using EXISTS Before Inserting

Here is a sample stored procedure that prevents duplicate inserts with the same value by first performing a test using SQL Server's EXISTS statement.
IF OBJECT_ID('prcTagNameInsert') IS NOT NULL
    DROP PROCEDURE prcTagNameInsert
GO
CREATE PROCEDURE prcTagNameInsert
    @tagName    VARCHAR(50)
AS

IF NOT EXISTS(SELECT 1 FROM Tag WHERE tagName = @tagName)
    INSERT INTO Tag (tagName) 
    VALUES (@tagname)

Labels:

AddThis Social Bookmark Button

0 Comments:

 

Post a Comment

 

Digital Colony Copyright © 1999-2008 XHTML   508
This site uses Blogger, which is not 100% XHTML compliant.
Try...Catch Disclaimer: For brevity many examples do not include error handling. That is your responsibility.