Return to Snippet

Revision: 30077
at August 7, 2010 02:11 by RealRover


Initial Code
SET IDENTITY_INSERT dbo.UserGroup ON 

IF NOT EXISTS (SELECT 1 FROM dbo.UserGroup WHERE UserGroupId = 21392)
    INSERT INTO dbo.UserGroup(UserGroupId, UserGroupTypeId, OwnerId, Name, Description, IsVisible)
    VALUES (21392, 1, 1, 'Anonymous Public Users', 'Anonymous Public Users', 0)

SET IDENTITY_INSERT dbo.UserGroup OFF

Initial URL

                                

Initial Description

                                

Initial Title
IF NOT EXISTS ... INSERT

Initial Tags

                                

Initial Language
SQL