| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the default value of CHAR type? | Bosch | 8 |
| in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc. | | 7 |
| What is a view? is View updatable? | IBM | 11 |
| How do you fine the performance tunning? | Accenture | 2 |
| What is the difference between a local and a global variable? | | 3 |
| what is physical sort data and logical sort data in index? | | 2 |
| Can you have a nested transaction? | HCL | 3 |
| what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1; | Patni | 9 |
| wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records | | 16 |
| Can store procedure call by user define function in SQL
server? | HCL | 6 |
| i want table name basis on column name. | | 5 |
| can foreign key take role of primary key?
| TCS | 4 |
| Can a stored procedure call another stored procedure. If yes
what level and can it be controlled? | | 2 |
| can you any body tell me simple recovery,full recovery,bulk
logged recovery where can use? | | 1 |
| syntax for deleting the database in T SQL | | 4 |
| What is a stored procedure? | | 3 |
| How to Execute an Operating System Command From Within SQL
Server ? | | 2 |
| Delete duplicate rows from a table without primary key by
using a single query
Table Employee
empname salary
A 200
B 300
A 200
C 400
D 500
D 500
Output should be
A 200
B 300
C 400
D 500
| | 2 |
| can you anybody tell me the how can you restore the master
database. while migraion(one server to onther server)? | | 1 |
| How many types of cursors are there in SQL Server? | 247Customer | 3 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
