| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| how many types of store procedre in sqlserver 2000? | ATI | 2 |
| write the query for taking database restore in sql? | | 1 |
| how to find nth highest salary | | 21 |
| How do we get current date in SQL Server 2000, Oracle, MS
Access? | | 10 |
| Advantages and Disadvantages of Cursor? | Zenith | 4 |
| What are constraints? Explain different types of
constraints? | | 4 |
| how to give input dynamically to a insert statement in
sqlserver | HCL | 1 |
| Name three version of sql server 2000 and also their
differences? | | 1 |
| What are Sql Reporting Services and analysis services? Can
u Explain | | 1 |
| What are user defined datatypes and when you should go for
them? | | 1 |
| write down the sql query?
Table Name : emp1
empid empname
1 bala
2 guna
Table Name : emp2
empid empname
1 <Null>
2 <Null>
Solution : emp1 names are updated in emp2, write a query?
| | 3 |
| What is the difference between views and stored procedures?
Can we have input parameters for views? | | 3 |
| what is IDE,DMV in sql server? | Value-Labs | 1 |
| What is a Linked Server? | | 1 |
| As a part of your job, what are the DBCC commands that you
commonly use for database maintenance? | HCL | 1 |
| how insert selected column only ? | Robert-Half | 1 |
| What is the system function to get the current user's user
id? | HCL | 1 |
| What is transaction ? Give me one example. | Melstar | 7 |
| i want to join two queries....and i want to run them as one
after another that is want output of first query then
second , then again output of first query then second and
so on... | | 1 |
| 1.what is stored procedure?Its significance with example?
2.Explain about index with syntax and example?
plz do reply......... | | 1 |
| |
| For more SQL Server Interview Questions Click Here |