Answer Posted / sumit
The Life Span of the Cursor is till the runtime of the
stored procedure/function in which the cursor is being used
in sql server
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is the difference RDBMS and Graph Database?
What are the differences between substr and charindex in sql server.
Explain alternate key, candidate key and composite key in sql server?
what is a transaction and what are acid properties? : Sql server database administration
What is the difference between count () and rowcount ()?
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 do you understand by triggers and mention the different types of it?
What is normalization of database? What are its benefits?
What are Spatial data types in SQL Server 2008
What is recompile sql server?
Explain how would you store your query in an SSRS report or a Database server?
How many instances per computer are there in sql server 2000?
List types of tables in SQL Azure?
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?
How to automatically create a log when an exception is being received into SQL Server?