SQL Server Interview Questions
Questions Answers Views Company eMail

What is Index Segmentation ?

TCS,

1 4809

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 4878

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.

793




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 4080

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 1840

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

HCL,

2 3921

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 4092

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 2307




What is the difference between local table and global table

Polaris, CarrizalSoft Technologies,

1 5490

What is SQL Profiler and the use of it?

247Customer,

2 2537

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

247Customer,

1 2957

What is the difference between truncate and delete statement?

CTS, CarrizalSoft Technologies,

6 3934

What is the difference between UNION and UNIONALL?

CTS, CarrizalSoft Technologies,

5 8621

WHAT OPERATOR PERFORMS PATTERN MATCHING?

CTS, CarrizalSoft Technologies,

2 4008

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

Oracle, CTS, CarrizalSoft Technologies,

5 7340


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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?

1275


Issues related in upgrading SQL Server 2000 to 2005 / 2008

792


which backup strategy you are following at ur company

1009


what is checksum in sql server.........???

412


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1167






how to do partition in sqlserver

1323


How we create SQL Server 2005 Reporting Services ? Give me Sample

930


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

724


tell me the disaster recovery plan

1300


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

954


Which is the best place or learning center for MS SQL?????In Bangladesh?????

892


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

898


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

824


How to convert a table data in XML format in sql server?

1417


on line cluster can we make if yes tell me the procedure

854