| Other SQL Server Interview Questions |
|| Asked @
|How to get max 100 values from sql server
|How m-m relationships are implemented?
select the deptname where salary >=5000
result should be:
please post only executed query in SQL server 2005
Asked By: Md. Niyaz
|How can i give the restrictions for the data entry, if i
wish to enter only I ,II, III, IV in the grade actegory of
|What is SCOPE_IDENTITY() in sql
|Can we execute a stored procedure inside a trigger?
|I am Having tables T1 and T2 both having same data how to
check (or) compare the data in both table are same?
|How are SQL Server databases physically stored under
|In which situation you use Self joins?
|please give me query code of unique fuction
select UNIQUE (name) from emp_info
Incorrect syntax near the keyword 'UNIQUE'.
|what is DTS what are tasks available
|1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES;
2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES;
ouput should be in table format
|For more SQL Server Interview Questions Click Here |