i m creating a registration form, i hav two tables,one for all user information and another for storing only username and password.i hav written trigger to fetch username and password from user information table to my 2nd table say login table.now comes problem....as i hav applied primary key on username in user information table and passed reference in login table but because of primary key records are arranged in ascendind order so tigger is fetching the last row instead of the current inserted record.


plz help me out with code and explanation with example.....asap

prashant

Why do you need a trigger to fetch username/password? Why can't you just use a simple query? If you're inserting username and password and want to get the identity of that record, you can get it in the insert statement:

SET NOCOUNT ON; INSERT INTO [table] (col1, col2, col3) VALUES (var1, var2, var3);SELECT ThePrimaryKey = @@IDENTITY; SET NOCOUNT OFF;

Oh, no, no, no... using @@IDENTITY, especially when triggers are involved, is a form of "Death by SQL" and will return the incorrect ID if a trigger does an insert (never take the chance). Use Scope_Identity() instead.

--Jeff Moden