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...
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...
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.
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.