it cant be done with trigger. trigger runs when the table is changed(update,delete,insert into). i want sql server to check table when...
hi all, is there any way for sqlserver to monitor a table? i want to update some records in a table when the time is up. there is a table with some...
thanx all
1. field's type is datetime, i want to update this field with Now() + 30 minutes from v6. how can i convert my value ( Now() + 30 ) to sql. 2.about...
i have a table which contains a datatime field and there are some data. i wrote a basic select sp. i want to filter the sp with date. when i send...
there is a sql that gives max timestamp of a table. s="SELECT max(T_timeStmp) as Maxts FROM tableA" i get the value of max timestamp.i put it to a...
can u give a small example about trigger, or any link that does triggerexecutuin table with version colum?
i want to write a dll that watches a trigger (with vb6). does it possible? dll must watch the trigger, if the trigger executes dll must send...
i want to add a record to a table via storedprocedure. i did a stroedprocedure in sqlserver. it runs well. how can i use the stored procedures in...
Separate names with a comma.
