Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
One table have many columnsHi, In my SQL Server 2000, I would like to write a stored procedure for a particular table TableZ which has 50 columns, and the stored procedure will check if a column in a row is changed. Now comes the problem, since TableZ has so many columns, and I don't want to write a LONG stored procedure. Is there a simpler way for doing this? Thanks for help. Jason
Post Follow-up to this message
Re: One table have many columnsJason You would like to know whether the row in specific column has changed? Take a look at timestamp daatype as a row version "Jason Huang" < JasonHuang8888@hotma il.com> wrote in message news:u9vcwn1HHHA.3676@TK2MSFTNGP03.phx.gbl... > Hi, > > In my SQL Server 2000, I would like to write a stored procedure for a > particular table TableZ which has 50 columns, and the stored procedure > will check if a column in a row is changed. > Now comes the problem, since TableZ has so many columns, and I don't want > to write a LONG stored procedure. Is there a simpler way for doing this? > Thanks for help. > > > Jason > >
Post Follow-up to this message
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
