Can i rollback "table data types" when we are using in transactions?
|
View Answer
|
47581 View(s) | Expertise Level:
Experienced
| Asked in:
Accenture
|
|
SQL Server Interview Questions
SQL Server PL/SQL Interview Questions
Accenture Interview Questions
Accenture Interview Questions on SQL Server
Accenture SQL Server Interview Questions
What is correlated sub-query?
|
View Answer
|
33287 View(s) | Expertise Level:
Intermediate
| Asked in:
iGATE
|
|
SQL Server Interview Questions
SQL Server PL/SQL Interview Questions
iGATE Interview Questions
iGATE Interview Questions on SQL Server
iGATE SQL Server Interview Questions
In a table there are so many duplicated records, with your name having 4 records, there is no primary key, then how can you delete two records having with your name?
|
View Answer
|
30249 View(s) | Expertise Level:
Experienced
| Asked in:
iGATE
|
|
SQL Server Interview Questions
SQL Server PL/SQL Interview Questions
iGATE Interview Questions
iGATE Interview Questions on SQL Server
iGATE SQL Server Interview Questions
Write a query to get max salary and second max salary in order in one query?
|
View Answer
|
30225 View(s) | Expertise Level:
Intermediate
| Asked in:
ValueLabs
|
|
SQL Server Interview Questions
SQL Server PL/SQL Interview Questions
ValueLabs Interview Questions
ValueLabs Interview Questions on SQL Server
ValueLabs SQL Server Interview Questions
What is difference between STUFF and REPLACE in SQL Server
|
View Answer
|
42186 View(s) | Expertise Level:
Experienced
| Asked in:
TCS (Tata Consultancy Services)
|
|
SQL Server Interview Questions
SQL Server PL/SQL Interview Questions
TCS (Tata Consultancy Services) Interview Questions
TCS (Tata Consultancy Services) Interview Questions on SQL Server
TCS (Tata Consultancy Services) SQL Server Interview Questions
What is difference Between GETDATE and SYSDATETIME
|
View Answer
|
36705 View(s) | Expertise Level:
Experienced
| Asked in:
TCS (Tata Consultancy Services)
|
|
SQL Server Interview Questions
SQL Server PL/SQL Interview Questions
TCS (Tata Consultancy Services) Interview Questions
TCS (Tata Consultancy Services) Interview Questions on SQL Server
TCS (Tata Consultancy Services) SQL Server Interview Questions
How to check multiple LIKE conditions in one single SQL Statement.
|
View Answer
|
20680 View(s) | Expertise Level:
Experienced
| Asked in:
Broadridge
|
|
SQL Server Interview Questions
SQL Server PL/SQL Interview Questions
Broadridge Interview Questions
Broadridge Interview Questions on SQL Server
Broadridge SQL Server Interview Questions
What are different types of cursors available in SQL Server 2005?
|
View Answer
|
21178 View(s) | Expertise Level:
Experienced
| Asked in:
Olivegreen
|
|
SQL Server Interview Questions
SQL Server PL/SQL Interview Questions
Olivegreen Interview Questions
Olivegreen Interview Questions on SQL Server
Olivegreen SQL Server Interview Questions
A table has a single column and has duplicate values. How to delete all the duplicate values?
|
View Answer
|
14848 View(s) | Expertise Level:
Experienced
| Asked in:
Inooga Solutions
|
|
SQL Server Interview Questions
SQL Server PL/SQL Interview Questions
Inooga Solutions Interview Questions
Inooga Solutions Interview Questions on SQL Server
Inooga Solutions SQL Server Interview Questions
When should i go for temporary tables and table data types in SQL Server? Which one is advantage compared to other in terms of performance while writing queries?
|
View Answer
|
19837 View(s) | Expertise Level:
Experienced
| Asked in:
TCS (Tata Consultancy Services)
|
|
SQL Server Interview Questions
SQL Server PL/SQL Interview Questions
TCS (Tata Consultancy Services) Interview Questions
TCS (Tata Consultancy Services) Interview Questions on SQL Server
TCS (Tata Consultancy Services) SQL Server Interview Questions
I had created two update triggers for two columns in a table. When i use update statement on this table on which order or precedence trigger will fires?
|
View Answer
|
19099 View(s) | Expertise Level:
Experienced
| Asked in:
TCS (Tata Consultancy Services)
|
|
SQL Server Interview Questions
SQL Server PL/SQL Interview Questions
TCS (Tata Consultancy Services) Interview Questions
TCS (Tata Consultancy Services) Interview Questions on SQL Server
TCS (Tata Consultancy Services) SQL Server Interview Questions
What are magic tables in SQL Server?
|
View Answer
|
15100 View(s) | Expertise Level:
Experienced
| Asked in:
Mahindra Satyam
|
|
SQL Server Interview Questions
SQL Server PL/SQL Interview Questions
Mahindra Satyam Interview Questions
Mahindra Satyam Interview Questions on SQL Server
Mahindra Satyam SQL Server Interview Questions
What is the difference between function and stored procedure?
|
View Answer
|
16015 View(s) | Expertise Level:
Intermediate
| Asked in:
LiquidHub
|
|
SQL Server Interview Questions
SQL Server PL/SQL Interview Questions
LiquidHub Interview Questions
LiquidHub Interview Questions on SQL Server
LiquidHub SQL Server Interview Questions