| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What types of integrity are enforced by a foreign-key
constraint | | 1 |
|
CLR Integration ?
what is Notification services ?
| Satyam | 1 |
| what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1; | Patni | 9 |
| What is normalization and what are the different forms of
normalizations? | | 1 |
| If there is failure during updation of certain rows, what
will be the state? | | 1 |
| What are the different ways of moving data/databases
between servers and databases in SQL Server? | | 1 |
| How to select Distinct columns from the table, table having
20 columns and i want all coulmns | Wipro | 3 |
| Can I know,how to Execute Funcion and Trigger through
command(Manualy Execution) in MS SQL/SERVER 2005,give me
answer with Example. | | 1 |
| 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 two types of concurrency? | | 2 |
| Is it possible to create a stored procedure that runs a
query and outputs the results to a text file and allows me
to add extra delimeters and static field info. If so How? | | 1 |
| How can I know what query is executing by by a particural
user? (using sp id or any othe way.) | | 2 |
| How can you see what type of locks used? | | 1 |
| Whether the updations made to the views reflect the
original records in the table | NIIT | 5 |
| Write a query to delete duplicate records in SQL SERVER | Infosys | 19 |
| What is Report Server,Report Manager and Report Builder in
SSRS 2005? | | 1 |
| What is difference beteen Migration and Upgrdation? | Satyam | 4 |
| how to find nth highest salary | NexGen | 30 |
| how to select a field with firstletter as capital and
remaining are small letters | | 8 |
| How do we get current date in SQL Server 2000, Oracle, MS
Access? | | 11 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
