This is an age old debate and there are countless examples of this debate on the internet. my advice to you, is that both languages use the .NET framework, so in essence niether are any better than each other. At the end of the day the language choice is that of the developer as to what syntax they prefer. I personally use both on a daily basis, and don't really care which one I use. It is up to the client as to which one they prefer to support and what skills they have in house to support the application. Kind Regards, Gary My Website || My Blog

Review this link:- http://www.codecomments.com/ASP_.NET/message857135.html[^] :) Thanks and regards, Suresh Dayma Everything Is Possible!

Hi guffa thanks for your great help.....Now I am able to do this :cool:. Thanks :) Dinesh Sharma

Thanks ToddHileHoffer I done this and now its working properly... Thanks a lot Dinesh Sharma Dinesh Sharma

You don't have any join to the "updated" record. Try something like:- CREATE TRIGGER CreateTrans ON [dbo].[Table1] FOR UPDATE AS IF (COLUMNS_UPDATED() & 49)=49 BEGIN INSERT INTO [Table2](x.ID) SELECT x.ID FROM Table1 x INNER JOIN INSERTED ON x.Id = INSERTED.Id END GO '--8<------------------------ Ex Datis: Duncan Jones Merrion Computing Ltd

http://www.1planhost.com/support/s_sql2000dbbak.asp[^]

You can see my post[^] right below.

I am using cvsNT and tortoise CVS but i know nothing about it... that how to use it ...I am working on ASP.Net so if it would be on server and i 'll access it through client i'll have to configure IIS also.....how is it possible... pls suggest Thanx Dinesh Sharma

By asking the appropriate forum. You know you're a Land Rover owner when the best route from point A to point B is through the mud. Ed

look up ExecuteScaler object retValue = [SqlCommand].ExecuteScalar() ;

there is no impossible, impossible saies "Im Possible":rose:

That was nicely put :cool: Dan Nobel "The question is not how far. The question is, do you possess the constitution, the depth of faith, to go as far as is needed?" boondock saints