| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Questions on identity? | Infosys | 1 |
| system date format is "yy-mm-dd"
"select getdate()" ----> 2009-01-24 20:03:28.513
if i write "select dateadd(dd,2,getdate())
".it returns "2009-01-26 19:59:38.340"...my question is dat
could it be possible to retrive da date in da format "26
jan 2009 ...."??
| | 8 |
| WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT? | | 6 |
| how to copy sysdatabase file from c: Drive to D: Drive in
SQL Server. | IBM | 4 |
| can any one please send sql quries most used in applications. | | 1 |
| 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? | Wipro | 1 |
| What are the advantages of using stored procedures? Please
don't simply say compilation time will be saved as they are
already complied. Please specify some other advantages. | 247Customer | 3 |
| What is a materialized view? | | 2 |
| What is referential integrity and how is it achieved? | Adea-Solutions | 1 |
| how insert selected column only ? | Robert-Half | 2 |
| How do you measure the performance of a stored procedure? | Infosys | 1 |
| Which is better in performance - CONSTRAINT or TRIGGER over
a column which restricts say an input of particular value
in a column of a table? | Accenture | 3 |
| how to replace double quotes by single quotes in sql server | CAC | 2 |
| hi,
how to match retrieve the unmatched records from 2 tables
in which we dont have any primary key. example : table1 has
1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want
the numbers from 6 to 10 to be displayed and should not
come as null. i need the numbers. please reply as soon as
possible.
| | 2 |
| What are the main control-of-flow T-SQL constructs?
| | 1 |
| How to work on DTS?what is the main requirement? | ivan | 1 |
| What is a cursor in SQL Server 2000 and their types? | | 4 |
| What is blocking and how would you troubleshoot it? | HCL | 2 |
| Explian different types of BACKUPs avaialabe in SQL Server?
Given a particular scenario, how would you go about
choosing a backup plan?
| HCL | 2 |
| can any one answer this query,thank you in advance
Table 1 has 2 columns: EmployeeId, T shirtsize(values can
be 1,2,3)
Table 2 has 2 columns: EmployeeId, Region
Write SQL to Find the region which has the largest number
of people with Tshirt size=3
| Google | 10 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
