| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
|
CLR Integration ?
what is Notification services ?
| Satyam | 1 |
| Questions on identity? | Infosys | 1 |
| What are the steps you will take to improve performance of
a poor performing query? | HCL | 1 |
| How do we get month name in SQL Server 2000, Oracle, MS Access? | | 9 |
| how do we find every fifth record in a table | | 11 |
| What is the difference between constraints and triggers? | Wipro | 6 |
| how to generate XML out of QUERY? | McAfee | 1 |
| What's the difference between a primary key and a unique key? | Wipro | 8 |
| What should we do to copy the tables, schema and views from
one SQL Server to another? | | 3 |
| please tell me the query to get details of the employee
having the second largest salary | 247Customer | 8 |
| What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL? | | 1 |
| What is the datatype returned by count(*) | Asian-CERC | 18 |
| What are the different types of joins and what does each do? | | 2 |
| How to give a user the option of importing Excel and a
delimited text file into a SQL Server Database without
manually using SQL DTS?
| GE | 1 |
| Please tell me some knowledge about Clustering and how to
add clustering? | | 1 |
| Hi Can any one tell me the Good institute to learn SQL esp
for Data Base Testing or SQL from scratch to the
proficiency level in Hyederabad and facult also. Thankyou
well in advance | | 6 |
| Hi Friends,
I have a table in which there are thousands of records and
in city field there is NULL value for all records now i want
to change that null value with distinct values in each
record say delhi, bihar, agra, jaipur etc, what will be the
query for that?????
its not possible to update thousands of records one by one.
is there any alternative ...?
Plz help ... its urgent
Thanx in advance | | 1 |
| how can i store resumes in database? | HCL | 2 |
| How to write query to Delete the records in child table
and corresponding records in parent table | Semantic-Space | 8 |
| What is the system function to get the current user's user
id? | TCS | 3 |
| |
| For more SQL Server Interview Questions Click Here |