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 12817

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

IBM,

5 13589

How can u convert the Date to String?

Microsoft, TCS,

6 17083

What is Deadlock?

Satyam,

4 9176

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

5 11627

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

IBM,

7 19774

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 11130

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

6 21787

where the connection string store in the database

HCL, Wipro,

2127

Un-Answered Questions { SQL Server }

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

1105

Explain filtered indexes benefits?

1050

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1661

Explain following error properties?

1068

How to delete duplicate rows from table except one?

1050

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1943

What is the default server name for sql server?

1243

What is a join in sql?

1161

Difference between report and query parameter.

1147

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

1050

What is msdb database? : SQL Server Architecture

1205

How to drop existing views from a database in ms sql server?

1154

Difference between DELETE and TRUNCATE?

1102

difference between Clustered index and non clustered index ?

1042

What is the difference between varchar and nvarchar datatypes?

1146

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