Can i rollback "table data types" when we are using in transactions?
|
View Answer
|
47881 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
|
33447 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
|
30339 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
|
30388 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
|
42584 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
|
36921 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
|
20787 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
|
21244 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
|
14926 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
|
20014 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
|
19251 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
|
15193 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
|
16126 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