Trigger in SQL Server 2005
-
Hello all, I want to write simle trigger in sql server for auto generate numbers. Can any one help me regarding this. and also want to know the Basic Structure of triggers in sql server 2005.Please help me regarding this. Thanks Rizana
Hi Rizana, The structure of Triggers in MS SQL SERVER 2005 is almost same as it was in MS SQL Server 2003 or 2000. However, for more details please go through the following links: http://blog.pijnenburg.it/?q=node/41[^] http://www.simple-talk.com/sql/sql-server-2005/sql-server-2005-ddl-trigger-workbench/[^] Hope this helps :).
Regards, John Adams ComponentOne LLC
-
Hello all, I want to write simle trigger in sql server for auto generate numbers. Can any one help me regarding this. and also want to know the Basic Structure of triggers in sql server 2005.Please help me regarding this. Thanks Rizana
Firstly, you don't need a trigger to auto generate numbers, have an identity column instead. Secondly for the basic structure of a trigger try reading the help. In fact, in light of your question, I suggest you read up on triggers before attempting to use them as you seem unclear about what they are for.
Bob Ashfield Consultants Ltd
-
Hi Rizana, The structure of Triggers in MS SQL SERVER 2005 is almost same as it was in MS SQL Server 2003 or 2000. However, for more details please go through the following links: http://blog.pijnenburg.it/?q=node/41[^] http://www.simple-talk.com/sql/sql-server-2005/sql-server-2005-ddl-trigger-workbench/[^] Hope this helps :).
Regards, John Adams ComponentOne LLC
-
Firstly, you don't need a trigger to auto generate numbers, have an identity column instead. Secondly for the basic structure of a trigger try reading the help. In fact, in light of your question, I suggest you read up on triggers before attempting to use them as you seem unclear about what they are for.
Bob Ashfield Consultants Ltd
Hello Mr.bob, i want to write trigger only, because i want to generate number with Preceeding alphabets like 'a001' 'b002' for taht only i need triggers usually in my graduation i wrote trigger in oracle 9 i. but i dont know with the sql server. any way thanks for your suggestion. can i get the above with out trigger Please let me Know. Thanks RRiiizzzz