SQL Server Interview Questions
Questions Answers Views Company eMail

What is Index Segmentation ?

TCS,

1 4776

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 4851

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.

771




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 4016

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 1790

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

HCL,

2 3891

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 4046

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 2280




What is the difference between local table and global table

Polaris, CarrizalSoft Technologies,

1 5470

What is SQL Profiler and the use of it?

247Customer,

2 2519

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

247Customer,

1 2934

What is the difference between truncate and delete statement?

CTS, CarrizalSoft Technologies,

6 3887

What is the difference between UNION and UNIONALL?

CTS, CarrizalSoft Technologies,

5 8553

WHAT OPERATOR PERFORMS PATTERN MATCHING?

CTS, CarrizalSoft Technologies,

2 3967

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

Oracle, CTS, CarrizalSoft Technologies,

5 7291


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

what are the Prerequisites for Replication?

8453


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.

705


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

938


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

2676


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

816






How retrieve field names from the table in SQL through JAVA code?

702


what is the Ticketing tool used in Wipro technologies at Bangalore...???

5015


1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

1332


Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

712


can any body tell me how to know the password of current user in sql server

919


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1144


where the connection string store in the database

819


What is data modeling and Reterminal integrity?

668


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?

1255


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

857