i am anoop and new here and hope it would fun and learning experince on dbforums. also as this is my first post i would require and help regarding good book on mssql .i have some knowledge of oracle .now i want to learn basic of mssql like syntax ... triggers/stored procedures/function etc........
for eg how i would write following code in mssql . is an trigger for inserting values into an another table written in oracle
Code:
create trigger <triggername>
before delete on <tb1>
for each row
begin
insert into <newtablename> values(:old.column1 , :old.column2...)
end</triggername>
please advice thanks
anoop
dBforums
>
introdcution and help
11-12-11, 00:05
Linear Mode
