Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...



SQL Server Interview Questions
Questions Answers Views Company eMail

What is full form of XP ?

Cap Gemini, Infosys, Microsoft, Oracle, Reliance,

42 53413

what is procedure in sql?

Millennium, SQL,

2 5035

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

4 4512

How make remote connection in database?

1 2593

How send email from database?.

CarrizalSoft Technologies, Merrill Lynch,

3 5717

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

1417

In join, which clause in not used?

HCL, NIIT, TCS,

4 9836

how many instance use in sql server 2005

EFI, HCL,

4 9182

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

ABC,

1 4197

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 12255

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

1 3655

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

1 5294

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

7 5606

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 7022

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 8160







Un-Answered Questions { SQL Server }

What are distributed partitioned views?

244


How to include date and time values in sql statements?

215


Explain how to integrate the ssrs reports in application?

185


Show Practically Sql Server Views are updatable?

229


How to change the data type of an existing column with "alter table" statements in ms sql server?

206






How to specify the collation for a character data type in ms sql server?

202


What is a transact-sql statement batch in ms sql server?

202


How to get nth highest salary from employee table.

217


how you can deploy an ssrs report?

58


It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

221


Why Master database is required?

265


what is the primary use of the model database? : Sql server administration

189


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

1315


What is filestream?

207


Can select statements be used on views in ms sql server?

214