SQL Server Interview Questions
Questions Answers Views Company eMail

Can anyone explain difference between Database, Data warehouse and Data mart with some example?````

4 3320

how to get max salary with employee number by using one select query and max function ??


3 3903

What are the difference between data length and length in SQL Server-2008?

Scio Healthcare,

3 2962

Why foreign key column allowing null values even a parent tables reference key column not having null value..


2 3637

Can someone suggest me the best institute to learn SQL Server... I want to gain in depth knowledge on SQL Server Development. I have been to naresh, peers, sql school,mind q systems... Any idea about best faculty....

3 2001

Write a query to get all details of employee who has maximum salary from employee table

Genpact, AON,

8 8993

Ek lifafa 10 noto se bhara hai usme 2 or 5 ke note nahi hai aur usme total 50Rs hai, to batao lifafe me kon se not kitne hia it’s a challenge thank’s


5 6335

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.



Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.

HCL, Cognizant, Value Labs,

1 5240

how many non clustered index in sql server 2008,2010,2012


2 4657

what is the difference between table and view

1 1345

plss anybody specify tha constrian management system in dbms

Police Constable,


How to genrate automaticlly empid like gt001

4 2346

Can I recover a damaged SQL Server 2008 database with the undamaged .mdb and .ldf files?


3 3909

Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?


3 3373

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

How you trouble shoot when any job fails


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.


how to use DTS package in 2000,2005,2008 in sql server


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.


query processing


what is difference between view and Dip.


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?


1 01 101 01010


How to trouble shoot if unable to connect SQL Server


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that


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


Why we need to use secondry database file? though, we can do same work using primary database file also.


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


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


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