asp.net - Case statement inside trigger -

asp.net - Case statement inside trigger -

create trigger insert_emp on dbo.emp after insert begin declare @tablename varchar(50) declare @rdatetime varchar(20) declare @month int set @rdatetime = (select bdate inserted) set @month = (select datepart(mm,@rdatetime)) case when @month = 2 set @tablename = 'fep_emp' end print @tablename end

trigger execute after,inserting record in emp table.it pick date inserted.from date month calculated.i want set value of tablename.

case in sql server can used scalar values - cannot used decide code block or statement execute. handle conditional code execution, utilize regular if / else statements.

change trigger like:

create trigger insert_emp on dbo.emp after insert begin declare @tablename varchar(50) declare @rdatetime varchar(20) declare @month int set @rdatetime = (select bdate inserted) set @month = (select datepart(mm,@rdatetime)) if @month = 2 set @tablename = 'fep_emp' print @tablename end

asp.net sql sql-server-2005