SQL Server Interview Questions
Questions Answers Views Company eMail

What is full form of XP ?

Microsoft, Reliance, Cap Gemini, Infosys, Oracle,

42 46663

what is procedure in sql?

Millennium, SQL,

2 4178

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

4 3217




How make remote connection in database?

1 2124

How send email from database?.

Merrill Lynch, CarrizalSoft Technologies,

3 5051

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

1094

In join, which clause in not used?

HCL, TCS, NIIT,

4 8886

how many instance use in sql server 2005

HCL, EFI,

4 8196




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

ABC,

1 3647

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 10187

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

1 3161

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

1 4710

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

7 4473

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 5835

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 6130


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

ow to bring suspect mode datbase online from scratch

700


what are the critical issues you have resloved in your company

838


New concepts of sql server 2005 use in your project.

1246


Call by value and call by reference in procedure and function, with NOCOPY.

164


What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

1601






How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

1274


sql database suspect We have a sql database that is showing as suspect. How can we recover?

723


whats the maximum size of view state??

964


How you trouble shoot when any job fails

700


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

4791


what is difference between view and Dip.

1225


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

369


your distribution database is full what will u do

968


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

875


How do use Having,Group by,Group function in SQL?

687