IF NOT EXISTS(SELECT TOP 1 1 FROM dbo.stbTable01 where siCol01 = 1)
BEGIN
INSERT [dbo].[stbTable01] ([siCol01], [vcCol02], [vcCol03]) VALUES (1, N'Test One', N'TESTONE')
END
IF NOT EXISTS(SELECT TOP 1 1 FROM dbo.stbTable01 where siCol01 = 1)
BEGIN
INSERT [dbo].[stbTable01] ([siCol01], [vcCol02], [vcCol03]) VALUES (1, N'Test One', N'TESTONE')
END
Comments