filmov
tv
SSIS||How to run condition based queries in Execute SQL Task?
Показать описание
DECLARE @Flag VARCHAR(1)
SET @Flag=?
IF @Flag='I'
BEGIN
INSERT INTO Course (Course_Name) VALUES('SQL'),('Python')
END
IF @Flag='T'
BEGIN
TRUNCATE TABLE Course
END
SET @Flag=?
IF @Flag='I'
BEGIN
INSERT INTO Course (Course_Name) VALUES('SQL'),('Python')
END
IF @Flag='T'
BEGIN
TRUNCATE TABLE Course
END