SQL Server Interview Questions
Questions Answers Views Company eMail

What is full form of XP ?

Microsoft, Reliance, Cap Gemini, Infosys, Oracle,

42 44940

what is procedure in sql?

Millennium, SQL,

2 3969

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

4 2783

How make remote connection in database?

1 1994

How send email from database?.

Merrill Lynch, CarrizalSoft Technologies,

3 4893

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


In join, which clause in not used?


4 8630

how many instance use in sql server 2005


4 7981

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


1 3505

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


12 9738

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

1 2991

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

1 4524

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

7 4249

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 5572

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


10 5766

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .


optimization techinques


Comment,Datatypes are unlimited


What is the difference between online clustering and Offline clustering?


How you trouble shoot when any job fails


how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }


tell me the disaster recovery plan


1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do


Working with TLogs


application server is slow what may be the problem


whats the maximum size of view state??


your distribution database is full what will u do


How to trouble shoot if unable to connect SQL Server


You are doing log shipping due to some reasons it is failing. How you will proceed from there


can any body tell me how to know the password of current user in sql server