| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| HOW TO RENAME A COLUMN NAME | | 2 |
| What is the difference between OLEDB and ODBC | CFCI | 3 |
| What is the difference between Drop and Truncate | | 10 |
| What are Magic Table? | Evalueserve | 16 |
| Difference between server.transfer and server.execute method? | | 1 |
| What is Deadlock? | Satyam | 3 |
| 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 |
| Can you have a nested transaction? | HCL | 3 |
| About types of indexes in SQL server ? | Cognizent | 1 |
| How do we get current date in SQL Server 2000, Oracle, MS
Access? | | 11 |
| 1.can we set the more than 1 primary keys for a table?
2.please give me the difference between Cluster Index and
non-Clustered Index
3.can we use query like this "Select * from Table1,Table2;" | | 6 |
| There is table like Events...in that name ,startdate
,enddate,location are the column names
write a stored Procedure for this table to get events by
Months "GetEventsByMonths" | | 1 |
| What is a Linked Server? | | 1 |
| What is the difference between constraints and triggers? | Wipro | 6 |
| from the table display the 2nd highest salary?
and also the least 2nd salay?
| | 6 |
| What are cursors? Name four types of cursors and when each
one would be applied? | Adea-Solutions | 1 |
| WHAT OPERATOR PERFORMS PATTERN MATCHING? | CTS | 2 |
| What are the pros and cons of creating extended stored
procedures? | | 1 |
| internal language used in sql server 2000? | | 1 |
| About Indexed Views? with example?
plz reply... | | 2 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
