SQL Server Interview Questions
Questions Answers Views Company eMail

How many nested transaction can possible in sql server?

Bank Of America,

3 7189

hi,i want t0 knom d syntax for a super key with an example

1 3470

Advantages and disadvantages of stored procedures.

HCL,

2 5678




how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

HCL, Wipro,

1105

What is the difference between online clustering and Offline clustering?

IBM,

1277

When do u use clustered index and non-clustered index?

IBM,

3 6094

What is the diffrence between update_one and auto_fix?

IBM,

3 7146

what are the advanced features in sql 2008?

Wipro,

2 4001




Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC

2 5613

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

2 8710

two tables with table name ship(name,year) and battle (name,year),how to find the latest added year in the table ship

1 2124

If suppose in a table ship(name,year),find ship name having first and last name(i.e having space in between) ex: SAINT LOUIS,JET LAKE.

4 2855

select name of emplyoee whose total salary is 130 from following table. id name salary 1 a 100 2 b 20 3 c 50 1 a 30 2 b 70 Post the resulantant Query?

7 3764

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

IBM, TCS,

7 4391

What is @@Identity in sql?

Cap Gemini,

1 4246


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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

990


What is the difference between NOROW and LOCKROW?

1368


Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

878


How you trouble shoot when any job fails

754


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

1029






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

760


If user is owning any SQL Objects, can we drop that user

906


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

366


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

452


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

1007


1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

846


Why do you want to join software field as you have done your BE in Electronics?

1077


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


last function used in MS Access to convert sql what function will use in sql

914


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

676