SQL Server Interview Questions
Questions Answers Views Company eMail

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

4 3467

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

Genpact,

3 4215

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

Scio Healthcare,

3 3126




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

IBM,

2 3778

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 2147

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

Genpact, AON,

8 9366

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

Broadridge,

5 6703

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.

HCL,

1263




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 5477

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

Accenture,

2 4820

what is the difference between table and view

1 1496

plss anybody specify tha constrian management system in dbms

Police Constable,

821

How to genrate automaticlly empid like gt001

4 2531

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

Apple,

3 4058

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

L&T, IBM,

3 3593


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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

857


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

919


what exactly sql injuction.how to overcome.....

1309


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

594


SQL Server Architecture ?

1133






This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?

1236


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

806


Tell about MOM Tool(Microsoft Operator Manager)?

681


Delete duplicate rows without using rowid.

190


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


System variable and temporary variables

978


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

930


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

879


where the connection string store in the database

819


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

312