|
Home > Archive > MS SQL Server > December 2006 > One table have many columns
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
One table have many columns
|
|
| Jason Huang 2006-12-14, 5:25 am |
| 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
| |
| Uri Dimant 2006-12-14, 5:25 am |
| Jason
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
>
>
|
|
|
|
|