Hi Terry,
I am using the set of codes for getting the empcode into
one variable.I am getting tablename, where condition & orderby as an input parameters.
set @sql = 'declare tempcursor cursor for Select empcode from ' + @tablename + ' where '+ @wherecondition + @Orderby
Exec (@sql)
OPEN...
How to get the records between 5 and 10.?
For example,
If "select * from employee" is returing 100 records.
How to get the records from 5 to 10?
Selva Balaji
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.