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 12489

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

IBM,

5 13359

How can u convert the Date to String?

Microsoft, TCS,

6 16855

What is Deadlock?

Satyam,

4 8960

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

5 11385

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

IBM,

7 19554

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

2 7394

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

Wipro,

5 10929

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

6 21567

where the connection string store in the database

HCL, Wipro,

2063

Un-Answered Questions { SQL Server }

Explain transaction server implicit?

981

What is sql server used for?

1039

How do I open a .db file?

1034

What are the default system databases in sql server 2000?

1021

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

1002

Which sql server is best?

990

Which sql server table is used to hold the stored procedure scripts?

1057

Is natural join and equi join same?

965

Is sql server 2016 free?

933

Explain what is dbcc?

1000

Explain the use of keyword with encryption. Create a store procedure with encryption?

954

List some of the rules that apply to creating and using a ‘view’

874

What is the difference in accessing db between sql server vs sql azure?

174

Do you know what are acid properties of transaction?

950

How to enter date and time literals in ms sql server?

1011

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