Help: Can anybody tell me what happened to TSEQUAL()

Help: Can anybody tell me what happened to TSEQUAL()

Post by Henr » Tue, 23 Mar 1999 04:00:00



Dear All,

In SQL Server 4.2 or 6.0, I used a function TSEQUAL() to ensure the
timestamp has not been changed during an update.
However, I can not found any documentation in books-on-line in SQL Server
6.5 and 7.0.  Is the function no longer being used and if so what is the
alternative function/method???

e.g



update CustomerAddressPhones set

       LastUpdate = getdate()



   raiserror 12345 'Cannot update Customer Phone record.  It has been
updated by another user.'

Henry

 
 
 

1. Help: Can anybody tell me what happened to TSEQUAL()

Dear All,

In SQL Server 4.2 or 6.0, I used a function TSEQUAL() to ensure the
timestamp has not been changed during an update.
However, I can not found any documentation in books-on-line in SQL Server
6.5 and 7.0.  Is the function no longer being used and if so what is the
alternative function/method???

e.g



update CustomerAddressPhones set

       LastUpdate = getdate()



   raiserror 12345 'Cannot update Customer Phone record.  It has been
updated by another user.'

Henry

2. AddNew Method ???

3. Can anybody tell me what happened to TSEQUAL()

4. OpenIngres Desktop: Experiences ?

5. Undo replication setup

6. Anybody know what happened to the JDBC driver?

7. compare tables, SP, View in two databases

8. How to tell when a checkpoint happens through profiler

9. Anybody tell me what an EBF is

10. Need help with SQL Server timestamp/tsequal() with VB4

11. MDX : Canned Report or OLAP

12. Anyone know of some canned (cheap or free) DB performance testing software