SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 2 Solution : emp1 names are updated in emp2, write a query?

8 12813

What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they.

IBM,

5 13586

How can u convert the Date to String?

Microsoft, TCS,

6 17079

What is Deadlock?

Satyam,

4 9172

select top 5 * from emp order by newid() my question is , how this query get executed?

5 11624

how to get the rowid/rownumbes of a table in sqlserver

IBM,

7 19772

how can u select the Distinct values in the table, table having 20 columns , i want all columns

2 7510

How to select Distinct columns from the table, table having 20 columns and i want all coulmns

Wipro,

5 11125

What is The Use Of TIMESTAMP DataType in SQL Server 2005?

6 21782

where the connection string store in the database

HCL, Wipro,

2124

Un-Answered Questions { SQL Server }

What are the purpose of Normalisation?

1102

Which language is supported by sql server?

1069

What is data modification?

1027

What is field in algebra?

1100

Explain the types of indexes.

1304

Explain transaction server isolation?

1088

What is recompile sql server?

1090

What is the difference between commit and rollback?

996

What does the update command do?

1177

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

941

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

1063

What are the components of dbms?

999

How to change the name of a database user?

1016

When we should use @@error?

1039

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

1271

For More Un-Answered { SQL Server } Questions Click Here