SQL Server Interview Questions
Questions Answers Views Company eMail

What is Index Segmentation ?

TCS,

1 4885

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 4947

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.

838




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 4177

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 1921

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

HCL,

2 3982

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 4177

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 2357




What is the difference between local table and global table

Polaris, CarrizalSoft Technologies,

1 5541

What is SQL Profiler and the use of it?

247Customer,

2 2583

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

247Customer,

1 3007

What is the difference between truncate and delete statement?

CTS, CarrizalSoft Technologies,

6 4041

What is the difference between UNION and UNIONALL?

CTS, CarrizalSoft Technologies,

5 8777

WHAT OPERATOR PERFORMS PATTERN MATCHING?

CTS, CarrizalSoft Technologies,

2 4108

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

CTS, Oracle, CarrizalSoft Technologies,

5 7448


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

434


role of sql sever 2005 in database rather than any other database

928


after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

1002


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

886


whats the maximum size of view state??

1005






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

970


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

1306


what is isolation level at dead lock?

1069


Explain Capacity planning to create a database? and how to monitor it?

2918


how to take backup bcp out for a column in table in sql server?

909


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

659


What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

950


What is the difference between online clustering and Offline clustering?

1277


What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

1632


tell me the disaster recovery plan

1349