Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-23 : 12:57:52
|
| life writes "i would like to know what is the function in T-SQL for "POST-INSERT" & "PRE-INSERT" that using in PL/SQL. Coz i need to finish up my assignment........Can you tell me how to use that function? or what r the syntax for both of this function?pls reply ASAP....... Thank You!" |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-04-23 : 18:30:20
|
| Assignment... like homework assignment? Here's a starting point for you... I don't know what POST-INSERT and PRE-INSERT do in PL/SQL, but if they are ways to call code before and after a row is inserted into a table, then you need to read up on triggers in BOL. |
 |
|
|
life
Starting Member
1 Post |
Posted - 2002-04-27 : 11:01:19
|
| thank you for ur information. but can u tell me, where can i found the sample trigger code of that function for my reference? thank you |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-04-27 : 11:08:12
|
| BOL is shorthand for Books Online, and it has several trigger examples. You should also read up on the "inserted" and "deleted" pseudo-tables, these give you before-and-after versions of the affected rows for INSERT/UPDATE/DELETE operations. Also look under "CREATE TRIGGER" in Books Online. |
|
|
|
|
|
|
PL/SQL function VS. T-SQL function