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
Tell me what is the significance of null value and why should we avoid permitting null values?
How do I edit a procedure in sql server?
What you can do to delete a table without the delete trigger firing?
Can you please explain the difference between function and stored procedure?
if no size is defined while creating the database, what size will the database have? : Sql server administration
Explain the truncate command?
How secure is sql server database?
What happens if you add a new index to large table?
Explain what role entity and relationship play in an ER diagram.
What are the advantages of policy management?
How to insert data into an existing table?
What is the difference between online clustering and Offline clustering?
How data can be copied from one table to another table?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
How to sort query output in descending order in ms sql server?