| Other SQL Server Interview Questions |
|| Asked @
|Can you explain the types of Joins that we can have with Sql
|Find 2nd Highest salery in emp table
Select* from emp where &n=
select * count from emp where (salery >=emp.salery)
Enter n value 2
These query is correct or not. Tell me any other methods.
|How to store pdf file in sql server?
|What are the limitation of the Online Index Rebuild Operation?
|How get current date in SQL server 2000
|Write a query to delete duplicate records in SQL SERVER
|If there is failure during updation of certain rows, what
will be the state?
|What is the difference between WHERE AND IN?
1. SELECT * FROM EMPLOYEE WHERE EMPID=123
2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123)
WHAT IS THE DIFFERENCE?
|How many types of system privileges are there, Can we add or
- Delete & Truncate
- Table & View
- Constraints & Triggers
|What's the difference between a primary key and a unique
|create index a on employee(dno)
In this,which index was created?
|For more SQL Server Interview Questions Click Here |