Home » Interview Q&A » Archive by categorySQL Interview Questions (Page 2)

What is cursor in SQL Server?

Cursor-SQL-Server-technothirsty
What is cursor in SQL Server? A cursor is a set of rows together with a pointer that identifies a current row. In other word, Cursor is a database object used by applications to manipulate data in a set on a row-by-row basis, its like record set in...
Continue reading

What is OPENXML in SQL Server?

OPENXML-SQL-Server-technothirsty
What is OPENXML in SQL Server? OPENXML can parse the xml data in SQL server very efficiently in SQL Server. OpenXML primarily gives the ability to insert XML data to the relational database, however we can query the data too using OpenXML. We need to specify the path...
Continue reading

Limitation of ISDATE() Function in Sql Server

Limitation-ISDATE-SQL-Server
Limitation of ISDATE() Function in Sql Server Hey folks till now we have discussed Performance improvement of cursor SQL Server, User defined functions in sql, Kill Processes in sql server 2008, View in sql , default constraint in sql , Remove Cross duplicate rows in SQL, Recursive SQL Query , Recursive SQL Query-2, STUFF and CONCAT in SQL, RANK in...
Continue reading

Concat First Middle and Last name in Sql

Concat First Middle and Last name in Sql
Concat First Middle and Last name in Sql Hey folks till now we have discussed Performance improvement of cursor SQL Server, User defined functions in sql, Kill Processes in sql server 2008, View in sql , default constraint in sql , Remove Cross duplicate rows in SQL, Recursive SQL Query , Recursive SQL Query-2, STUFF and CONCAT in SQL, RANK...
Continue reading

Isolation Levels in Sql Server

Isolation Level Sql Server
Below I have describe different types of isolations available in SQL Server. READ COMMITTED This transaction issue lock that other transaction can modify data.when this option set in select query then it will fetch only committed records.if any transaction is opened and incomplete then select query will wait...
Continue reading

Performance improvement of cursor SQL Server

Performance improvement of cursor SQL Server Cursor-Loca-Fast-Forward
Hey folks till now we have discussed User defined functions in sql, Kill Processes in sql server 2008, View in sql , default constraint in sql , Remove Cross duplicate rows in SQL, Recursive SQL Query , Recursive SQL Query-2, STUFF and CONCAT in SQL, RANK in SQL server , Difference between temporary table and table variable in sql server, UNIQUEIDENTIFIER in SQL...
Continue reading

User defined functions in sql

Hey folks till now we have discussed Kill Processes in sql server 2008, View in sql  , default constraint in sql , Remove Cross duplicate rows in SQL, Recursive SQL Query , Recursive SQL Query-2, STUFF and CONCAT in SQL, RANK in SQL server , Difference between temporary table and table variable in sql server, UNIQUEIDENTIFIER in SQL Server, RAW Mode with...
Continue reading

Kill Processes in sql server 2008

Kill Processes in sql server 2008 Hey folks till now we have discussed User defined functions in sql,   View in sql , default constraint in sql , Remove Cross duplicate rows in SQL, Recursive SQL Query , Recursive SQL Query-2, STUFF and CONCAT in SQL, RANK in SQL server , Difference between temporary table and table variable in sql server, UNIQUEIDENTIFIER in...
Continue reading

View in sql

Hey folks till now we have discussed User defined functions in sql, Kill Processes in sql server 2008, default constraint in sql , Remove Cross duplicate rows in SQL, Recursive SQL Query , Recursive SQL Query-2, STUFF and CONCAT in SQL, RANK in SQL server , Difference between temporary table and table variable in sql server, UNIQUEIDENTIFIER in SQL Server, RAW Mode...
Continue reading




DISCLAIMER:
The content is copyrighted to technothirsty.com and may not be reproduced on other websites without permission from the owner.You may contact us using the information below.