Yes you can make your own !!!
New Toolbar Feature
I was surfing around and i rediscover a free online toolbar for those who want just click on the image bellow or go to http://jconline.ourtoolbar.com/
Yes you can make your own !!!
Yes you can make your own !!!
Create trigger for a table After Inserted
These sp creates automatically a trigger when invoked by job in SQL Server, these is very usefull and handy.
Create procedure [dbo].[sp_creates_trigger]
as
begin
declare @text nvarchar (800 ) -- Declares a variable called texto
set @text='CREATE TRIGGER [subset_trig] ON [dbo].[Subtable] AFTER INSERT AS BEGIN SET NOCOUNT ON; declare @tfield as varchar(8) set @tfiled = (select id_num from inserted)
update subtable set ufield = @tifield where customer<>''Web'' and id_num=@tfield
END'
-- set the trigger in table subtable for an action After Inserted that updates the table
exec sp_executesql @texto -- executes sp_exceutesql with the text command
end
Create procedure [dbo].[sp_creates_trigger]
as
begin
declare @text nvarchar (800 ) -- Declares a variable called texto
set @text='CREATE TRIGGER [subset_trig] ON [dbo].[Subtable] AFTER INSERT AS BEGIN SET NOCOUNT ON; declare @tfield as varchar(8) set @tfiled = (select id_num from inserted)
update subtable set ufield = @tifield where customer<>''Web'' and id_num=@tfield
END'
-- set the trigger in table subtable for an action After Inserted that updates the table
exec sp_executesql @texto -- executes sp_exceutesql with the text command
end
