This is my Technical area of troubleshooting and learning new Programming skills and many more. Here you will find answers for many new technologies like asp.net 2.0/3.5,4.0 C# access, mysql, Amazon Webservice ,Sql-server, JD Edwards, SAS, Salesforce, APIs, MVC and many more. please visit & discuss.
Wednesday, September 28, 2011
my first TRIGGER ever sql-server
ALTER
TRIGGER testTRIGGER
ON
dbo.QTD_HOURS1
FOR
INSERT
AS
BEGIN
insert
into QTD_HOURS1Trg
select
a.* from QTD_HOURS1 a
left
outer join QTD_HOURS1Trg b on a.[column 0]=b.[column 0] and a.[column 1]=b.[column 1]
No comments:
Post a Comment