SQL Server Interview Questions
Questions Answers Views Company eMail

What is full form of XP ?

Microsoft, Reliance, Cap Gemini, Infosys, Oracle,

42 46232

what is procedure in sql?

Millennium, SQL,

2 4124

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

4 3098




How make remote connection in database?

1 2080

How send email from database?.

Merrill Lynch, CarrizalSoft Technologies,

3 5006

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

1060

In join, which clause in not used?

HCL, TCS, NIIT,

4 8802

how many instance use in sql server 2005

HCL, EFI,

4 8139




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

ABC,

1 3613

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 10071

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

1 3121

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

1 4652

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

7 4411

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 5749

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 6020


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

645


New concepts of sql server 2005 use in your project.

1225


Does any body please help me what question's have asked for SSRS in the interview?

839


wat wil hapn if we give the both read and deny read permission to user?

920


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

803






what are the Prerequisites for Replication?

8404


what exactly sql injuction.how to overcome.....

1303


In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

864


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

697


how many no of arguments can be passed in procedures and functions

3472


Working with TLogs

675


Scalability, Availability, Integration with internet, etc.)?

1627


I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

662


What is Lock table in SQL?

246


What is best institute to Learn DotNET And SQL in chennai?

953