1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


SQL Server Interview Questions
Questions Answers Views Company eMail

What is full form of XP ?

Cap Gemini, Infosys, Microsoft, Oracle, Reliance,

42 61949

what is procedure in sql?

Millennium, SQL,

2 5952

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

 4 5672

How make remote connection in database?

 1 3130

How send email from database?.

CarrizalSoft Technologies, Merrill Lynch,

3 6651

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

 1765

In join, which clause in not used?

HCL, NIIT, TCS,

4 11199

how many instance use in sql server 2005

EFI, HCL,

4 10664

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

ABC,

1 4948

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 14614

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

 1 4192

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

 1 5915

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

7 7217

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 8509

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 10455

Un-Answered Questions { SQL Server }

How to delete duplicate rows?

542

How will you make an attribute not process? : sql server analysis services, ssas

575

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

78

What do you understand by hotfixes and patches in sql server?

504

What is a synonym for manipulation?

533




How do you delete duplicate records in sql server?

500

What is a dataset and what are the different types of datasets?

93

Can a function call a stored procedure in sql server?

520

Explain the flow of creating a cube? : sql server analysis services, ssas

613

What is a raid and what are different types of raid configurations?

613

What are views used for?

611

What is a trigger in sql server?

525

Why is replication required on the sql server?

566

What is updatable resultset?

507

How to run queries with sql server management studio express?

560

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