Write the Syntax for Cursors.
Answer Posted / ranjith kumar
declare cursor_name cursor for
select * from table_name
open cursor_name
fetch next from cursor_name
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
How can I check that whether automatic statistic update is enabled or not?
What is the Main Difference between ACCESS and SQL SERVER?
How to automatically create a log when an exception is being received into SQL Server?
Can we write ddl in trigger?
How to round a numeric value to a specific precision?
How to list all login names on the ms sql server?
What is difference between order by and group by?
What is the difference between the application object and session object?
How to check if stored procedure is running in sql server?
Why we need to use secondry database file? though, we can do same work using primary database file also.
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
How to create function with parameter in sql server?
What is named calculation? : sql server analysis services, ssas
Can we store videos inside the sql server table?
How to retrieve error messages using odbc_errormsg()?