| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| how to connect sybase to sql server 2005?. | ABC | 1 |
| What is the difference between having and where clause? | | 4 |
| what is the cursor life span? | Evalueserve | 5 |
| What is a function? Give some example? | | 2 |
| If you are working on a SQL database and if suddenly a
developer changes the code and your queries results start
giving errors,how will you check using a T-SQL query (on
system tables) that what has changed in the database. | Microsoft | 2 |
| what is advantages in sql 2005 over sql 2000? | | 4 |
| how to retrive only second row from table in sql server
2000? | CTS | 7 |
| what is the importence of the trigger in sqlserver2000? | ATI | 1 |
| i have table students with fields classname,studname
select * from students
classname studname
1 xxxxx
1 yyyy
1 zzzz
2 qqqq
2 tttt
3 dsds
3 www
i want the output should be
No of students in class 1 : 3
No of students in class 2 : 2
No of students in class 3 : 2
| HCL | 2 |
| What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE? | Yardi-Software | 4 |
| What is the difference between OLEDB and ODBC | CFCI | 3 |
| what is the difference between group and having
give an example with query and sample output | | 2 |
| I have a table EMP in which the values will be like this
EmpId Ename Sal DeptId
11 Ram 10000 10
11 Ram 10000 10
22 Raj 20000 20
22 Raj 20000 20
33 Anil 15000 30
33 Anil 15000 30
I want to delete only duplicate Rows. After Delete I want
the output like this
EmpId Ename Sal DeptId
11 Ram 10000 10
22 Raj 20000 20
33 Anil 15000 30
| DELL | 10 |
| How to write stored procedure to update the data in 10
tables | | 4 |
| What is database replicaion? What are the different types
of replication you can set up in SQL Server? | HCL | 4 |
| how to delete duplicate rows from table in sql server | HCL | 8 |
| Rate yourself in .NET and SQL ? | Cognizent | 1 |
| create procedure proc1 (@a int)
as
begin
if @a=1
create table #temp(a1 int)
else
create table #temp(a1 int)
end
while executeing the above code it shows error
like '#temp already exist' .why it shows an error? | IBM | 5 |
| How can you see what type of locks used? | | 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 |
| |
| For more SQL Server Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
