What are cursors? Name four type of cursors and when each one would be applied?

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

Home Hot About Collections Index RSS Atom Ask

Tester Developer DBA Windows JAR DLL Files Certificates RegEx Links Q&A Biotech Phones Travel FAQ Forum

Home > .NET

✍: Guest

Opening a cursor on a result set allows processing the result set one row at a time.
The four API server cursor types supported by SQL Server are:
a) Static cursors
b) Dynamic cursors
c) Forward-only cursors
d) Keyset-driven cursors

2014-10-17, 1606👍, 0💬

What is one of the first things you would do to increase performance of a query? For example, a boss tells you that â€œa query t
What is one of the first things you would do to increase performance of a query? For example, a boss tells you that â€œa query that ran yesterday took 30 seconds, but today it takes 6 minutesâ€? Answer1. Use Storedprocedure for any optimized result, because it is an compiled code. Answer2. One of... 2014-10-10, 1775👍, 0💬

Explain differences between server.transfer and server.execute method?
Explain differences between server.transfer and server.execute method? Answer1: server.transfer-> transefers the serverâ€™s control to the requested page given in the parameter. server.Execute-> executes the requested page from the current page itself,with no change in the address bar... 2014-10-22, 1703👍, 0💬

What is referential integrity and how can we achieve it?
What is referential integrity and how can we achieve it? Referential integrity preserves the defined relationships between tables when records are entered or deleted. In SQL Server, referential integrity is based on relationships between foreign keys and primary keys or between foreign keys and uniq... 2014-10-20, 1703👍, 0💬

What is the difference between a Local temporary table and a Global temporary table? How is each one used?
What is the difference between a Local temporary table and a Global temporary table? How is each one used? Answer1: Local templrary table will have a single # (#tablename) appended with the table name.Global templrary table will have Double # (##tablename) appended with the table name. Ex:create tab... 2014-10-15, 1677👍, 0💬

What is indexing?
What is indexing? If we give proper indexes on a table so that any queries written against this table can run efficiently. As your data sets grow over time, SQL Server will continue to rebuild indexes and move data around as efficiently as possible. This property is known as Indexing. 2014-10-22, 1643👍, 0💬

What is the purpose of UPDATE STATISTICS?
What is the purpose of UPDATE STATISTICS? UPDATE STATISTICS- it updates information about the distribution of key values for one or more statistics groups (collections) in the specified table or indexed view. 2014-10-17, 1636👍, 0💬

What are cursors? Name four type of cursors and when each one would be applied?
What are cursors? Name four type of cursors and when each one would be applied? Opening a cursor on a result set allows processing the result set one row at a time. The four API server cursor types supported by SQL Server are: a) Static cursors b) Dynamic cursors c) Forward-only cursors d) Keyset-dr... 2014-10-17, 1607👍, 0💬

What does it mean to have quoted_identifier on? What are the implications of having it off?
What does it mean to have quoted_identifier on? What are the implications of having it off? SET QUOTED_IDENTIFIER ON- Causes SQL Server to follow the SQL-92 rules regarding quotation mark delimiting identifiers and literal strings. Identifiers delimited by double quotation marks can be either Transa... 2014-10-15, 1590👍, 0💬

What is the STUFF function and how does it differ from the REPLACE function?
What is the STUFF function and how does it differ from the REPLACE function? Answer1: stuff-> inserts into it without removing any thing. Replace->replace the given text with the new one. Answer2: STUFF - it deletes a specified length of characters and inserts another set of characters... 2014-10-13, 1538👍, 0💬

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

Home Hot About Collections Index RSS Atom Ask

Tester Developer DBA Windows JAR DLL Files Certificates RegEx Links Q&A Biotech Phones Travel FAQ Forum

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.