| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the difference between windows authentication and
sql server authentication | HCL | 3 |
| what is the difference between sql query and google query? | TCS | 2 |
| How do you measure the performance of a stored procedure? | Infosys | 1 |
| How do SQL server 2000 and XML linked? | | 1 |
| how to rest identity columns in sql server | Matrix | 2 |
| How to determine the service pack currently installed on
SQL Server? | HCL | 2 |
| What are the pros and cons of creating extended stored
procedures? | | 1 |
| what are three different authentications to connect linked
servers? | CitiGroup | 1 |
| any one can explain
Self mapping
Delegation
Remote Credentials | | 1 |
| What is a transaction and what are ACID properties? | IBM | 2 |
| what is maximum size of temp db? | iSoft | 3 |
| What's the difference between DELETE TABLE and TRUNCATE
TABLE commands? | | 6 |
| What is the difference between OLEDB and ODBC | CFCI | 2 |
| Say if we have a table that contains only a single column ,
say OrderID, which has IDENTITY attribute defined on it. So
how can we insert data in this table.
I am reframing my question, that how can we make the table
to increment the column "OrderID" value several times??? | | 3 |
| wat is the main diff between sql server 2000and sql server 2005 | Jade-Software | 4 |
| which query u can write to sql server doesn't work
inbetween 7.00PM to nextday 9.00AM | Wipro | 4 |
| HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY
IN EMP TABLE | TCS | 14 |
| Which data type can be used only on OUTPUT parameters of the
stored proceduer? | | 2 |
| Difference between sql server 2000 and sql server 2005?
| Satyam | 2 |
| What is the purpose of using COLLATE in a query? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |