http://www.sql-server-performance.com/dv_delete_dupli cates.asp
use ROWCOUNT carefully.
specify 'SET NOCOUNT ON' to reset the count set by rowcount or else it may affect the normal operation...
baju123
Last Activity: Sep 5 '07, 09:57 AM
Joined: Jun 12 '07
Location:
-
You can implement this Using ROWCOUNT in Sql Server...Leave a comment:
-
Thanks Neo for the information...Leave a comment:
-
It is like i want to loop based on time as the critieria. instead of saying i = 500
while(i > 0)
i--;
i will say
while(time has elapsed)
{
// this will be executed every time the timeout has elapsed.
execute code;
}
can i do this loop in sql
what are all the time related operations available ?...Leave a comment:
-
hi Neo and hari .thanks for your replies.
I am using sql 2005. I searched in the link you gave me. i couldn't find a trigger that is needed.
here is the scenario,
I want to call an sql trigger on a NO INSERT condition on a table for a given time(i want a trigger to be executed when no rows has been inserted in a table for 2 seconds). It is just opposite to TRIGGER ON INSERT. I need one which...Leave a comment:
-
No. It is not a web based applicaation. so a NO INSERT Trigger is not possible ?...Leave a comment:
-
Sql Trigger For Timeout
How do i call an sql trigger when an insert has not happened in a table for a time. I want to call a trigger when the timeout had happened.
If such a trigger is not possible is there any other way to implement something close this ? somebody please give me a solution -
thanks ahamad for your replys. But i am not looking for parsing a string. What i have is a string variable. I must directly extract that string and do parsing operations on it. As i told you earlier, i am talking about 1000's of such strings per second. so putting into a file and reading it will not be feasible. If you have a better solution please let me know or is file operation feasible if the rate of the operation is 1000/ sec most of the times...Leave a comment:
-
Parsing A String In C++
Hi,
Would anybody tell me an efficient method to parse a string inside a variable which is line separated ...
Like this
value1: line1 /n
value2: line2 /n
value3: line3 /n
i want to parse line y line first and then each of the values by id. Here i am talking about strings coming in at very high rate maybe be 1000s a second.
so it would be nice for you experts...
No activity results to display
Leave a comment: