Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

before insert trigger

  
   Database Help (Home) -> MSEQ RSS
Next:  Problems with NOEXPAND  
Author Message
shif

External


Since: Dec 14, 2008
Posts: 1



(Msg. 1) Posted: Sun Dec 14, 2008 7:05 am
Post subject: before insert trigger
Archived from groups: microsoft>public>sqlserver>mseq (more info?)
Hi
Could anybody please help with some sample sql statements of Rowlevel trigger
and statement level trigger.Also how can i use before clause in trigger
eg:before update or before insert.
--
Thanks

 >> Stay informed about: before insert trigger 
Back to top
Login to vote
Hugo Kornelis

External


Since: Jan 11, 2008
Posts: 440



(Msg. 2) Posted: Sun Dec 14, 2008 5:25 pm
Post subject: Re: before insert trigger [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Sun, 14 Dec 2008 07:05:01 -0800, shif wrote:

>Hi
>Could anybody please help with some sample sql statements of Rowlevel trigger
>and statement level trigger.Also how can i use before clause in trigger
>eg:before update or before insert.

Hi Shif,

SQL Server doesn't support row-level triggers, nor BEFORE triggers. It
does support (statement-level) AFTER triggers and INSTEAD OF triggers.
You'll find several examples in Books Online.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

 >> Stay informed about: before insert trigger 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Running a Update query based on information from Insert Qu.. - I am trying to setup a script where I run an insert query to insert information into a table. The first part I have down pat as far as the Insert, where I'm having difficulties is that the information is coming from an outside source and the input..

index on a view - Hello, I have a table (TAB) and A View with alias (VIEW) Table cod varchar 3 descr carchar 60 my view cod alias COd1 descr alias DES Now i need a index on view with key COD1 I can't create it. Can..

Creating an alias - I have an alias that can get very long because it maintains a information of where it came from. Is there a way to alias an alias? My first thought was: Declare @T1 varchar(128) Set T1 = 'MyAlias' .... Inner Join Table1 as @T1 This of course does no...

Formatting numeric fields in select-clause - This is propably a very simple question, but I can´t seem to find the answer to it in the documentation. I want to format a numeric field so the result is right justified and zero-filled. ex select 1 will give the result 01 How do I manage this..

Simple Query problem - Sample table as follows Order ID Stock Code Status --------- ------- ------- 203 STK1 3 203 STK2 2 203 STK4 3 204 STK1 3 204 STK5 3 205 ..
   Database Help (Home) -> MSEQ All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]