Comments by Heljeeve (Top 1 by date)

Heljeeve 1-Nov-13 4:51am View

Hi, thanks for your help. But i have one more question abt this. Is there any other wrokaround for getting the row count, with out using count(*) because sendermaster table will be having more than 1 crore records, so 2 select statements will be a problem, and this procedure will called frequently.

In SQL SERVER we use @@ROWCOUNT to get check the existenece of records.

Regards

Heljeeve.

Advertise
Privacy
Cookies
Terms of Use
Last Updated 1 Jan 1900

Layout: fixed | fluid