SSIS||How to run condition based queries in Execute SQL Task?

preview_player
Показать описание
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
Рекомендации по теме