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 Index Segmentation ?

TCS,

1 5471

hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.

4 5717

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

1101

1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"

8 5213

CREATE TABLE [dbo].[HPMS_CompetencyTypes](CompetencyType varchar(50) ) go create trigger hpms_create_Insert on HPMS_CompetencyTypes for insert as if Exists ( select * from [HPMS_CompetencyTypes] where CompetencyType=(select * from [HPMS_CompetencyTypes])) begin Rollback tran Raiserror ('duplicate value',12,6) go insert HPMS_CompetencyTypes (CompetencyType) values ('new') I'm new to trigger can any one tell me where is the issue. Please.

2 2449

which one will take 1st priority in case of insert statement and select statement???

HCL,

2 4467

i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

Aptech,

5 5032

How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.

247Customer,

2 2942

What is the difference between local table and global table

CarrizalSoft Technologies, Polaris,

1 5944

What is SQL Profiler and the use of it?

247Customer,

2 3137

What are SQL Jobs, please mention the use of it and how to create them.

247Customer,

1 3345

What is the difference between truncate and delete statement?

CarrizalSoft Technologies, CTS,

6 5085

What is the difference between UNION and UNIONALL?

CarrizalSoft Technologies, CTS,

5 9784

WHAT OPERATOR PERFORMS PATTERN MATCHING?

CarrizalSoft Technologies, CTS,

2 4874

What is the order in which the SQL query is executed? list them in order.

CarrizalSoft Technologies, CTS, Oracle,

5 8463







Un-Answered Questions { SQL Server }

how we use window authentication connection with sql server.?

207


let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

153


What is default port number for sql server 2000?

194


Write an sql query for deleting duplicate rows?

177


How can a user-defined datatype be created?

168






Can you roll back the ddl statement in a trigger?

159


What is the difference between a unique key and primary key?

160


What do you mean by sql server 2005 express management tools?

188


What is 3nf normalization?

145


Does partitioning improve performance sql server?

119


explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

183


What is ms sql server index?

163


How to create a ddl trigger using "create trigger" statements?

186


What is named calculation? : sql server analysis services, ssas

173


Explain can you implement data mining in ssrs?

34