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

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

What is full form of XP ?

Cap Gemini, Infosys, Microsoft, Oracle, Reliance,

42 74740

what is procedure in sql?

Millennium, SQL,

2 7290

How create table structure only from tableA to TableB if TableA have some data?

4 7181

How make remote connection in database?

1 3913

How send email from database?.

CarrizalSoft Technologies, Merrill Lynch,

3 8048

hi to all teachers,... Friends who write in the query mode Full text Search in Sql Server have experience Who make(Convert) this Stored Procedure as a normal Full text Search, which contains and .. Is used, into Advance of the tips I have thanked all friends perfection. Email : rezaafandi@yahoo.com Create PROCEDURE Sp_student @fname varchar(50), @lname varchar(50), @tel varchar(50), @code varchar(50), @adr varchar(50), @search_operation varchar(50), @totalRowCount bigint output AS begin if @search_operation = 'and' begin SELECT f3,f4,f5,f6,f7 FROM tb_student WHERE( f5 like '%' + @fname + '%' and f4 like '%' + @lname + '%' and f6 like '%' + @tel + '%' and f7 like '%' + @code + '%' and f3 like '%' + @adr +'%' ) select @totalRowCount = @@rowcount end

2228

In join, which clause in not used?

HCL, NIIT, TCS,

4 13049

how many instance use in sql server 2005

EFI, HCL,

4 12449

How we Resize table,temp table, database and log file size in SQL Server 2005

ABC,

1 5946

There is a table1 with records (1,2,3,4,5,6) and table2 with records (4,5,6,7,8,9).write a query so as to get the result as 1,2,3,4,5,6,7,8,9

RBS,

12 18163

Can we create nonclustered index in a table without creating a clustered index

1 4916

How can we call UDF(User Define Function) using C# code in ASP.net ?

1 6950

4 Please write a querry to find repeated numbers in the following table. Table Name: Table1 Field1 10 15 20 15 10

7 9366

I am learning Testing, so i want to learn SQL also because SQL is important for Testing. I want to know which is best Institute in Ameerpet or SR Nagar or any other place in Hyd? Please help me.

7 10671

Hi, I have a table A which has four rows as follows Table A ------- empname salary ------- ------ A 1000 B 2000 C 3000 A 1000 B 2000 D 5000 I need the following output: empname salary ------- ------ A 1000 A 1000 B 2000 B 2000 Thanks in advance

IBM,

10 13123

Un-Answered Questions { SQL Server }

Tell me the difference between clustered and non-clustered index?

994

Explain syntax for viewing, dropping and disabling triggers?

1000

List out some of the requirements to set up a sql server failover cluster?

1083

How to use group functions in the select clause in ms sql server?

1125

What is the optimization being performed in oracle and SQL Server?

1099

What is "scheduled jobs" or "scheduled tasks"?

1032

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

1102

Do you know what is a linked server in sql server?

1072

What are orphan records?

988

How to transfer an existing table from one schema to another schema in ms sql server?

1029

What is executereader?

1005

How to insert and update data into a table with "insert" and "update" statements?

1047

What is the boxing and unboxing concept in .net?

980

What is query and its types?

959

what is dbcc? : Sql server database administration

1087

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