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
What is ddl command?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Working with TLogs
What does man by sql wildcard characters in sql server?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
Relational calculus is what type of language?
what is the system function to get current user's user id? : Sql server database administration
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
What is the purpose of object explorer and its features? : sql server management studio
What is data compression? : sql server database administration
What is subquery in sql?
What is @@error in sql?
What is the use of sql profiler in sql server 2012?
what are the Prerequisites for Replication?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?