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 73273

what is procedure in sql?

Millennium, SQL,

2 7147

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

4 7035

How make remote connection in database?

1 3841

How send email from database?.

CarrizalSoft Technologies, Merrill Lynch,

3 7897

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

2183

In join, which clause in not used?

HCL, NIIT, TCS,

4 12852

how many instance use in sql server 2005

EFI, HCL,

4 12258

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

ABC,

1 5859

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 17798

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

1 4854

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

1 6886

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

7 9128

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 10459

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 12793

Un-Answered Questions { SQL Server }

How to update values in a table with update statements in ms sql server?

1013

can an automatic recovery be initiated by a user? : Sql server administration

954

How do I start sql server 2016?

908

what are user defined datatypes and when you should go for them? : Sql server database administration

1019

Do you know nested transaction?

958

Difference between connected and disconnected database in .net with sql server?

1095

What is mssql?

985

what method you can use to reduce the overhead of Reporting Services data sources?

255

What number aggregate functions are accessible there in sql?

1072

How to add the custom code in Report?

126

Explain primary key?

965

Can you please explain the difference between function and stored procedure?

1007

What is difference between foreign key and unique key?

1011

Why functions are used in sql server?

960

How do you create a data source?

910

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