SQL Server Interview Questions
Questions Answers Views Company eMail

write the query for find the top 2 highest salary in sql server

Medi Assist, Cranes, TCS, Jayanti Software, Rmax,

36 47859

how to retrive only second row from table in sql server 2000?

Cognizant, CTS,

15 15680

there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C

vsworx, tdfc,

9 6467

Which data type can be used only on OUTPUT parameters of the stored proceduer?

2 4061

Alternative way to DetDate() function?

5 5234

How to find the second largest salary in the emp database and also How to find 3rd,4th and so on ........ in the emp database plz mail the answer @ mak2786@gmail.com

Oracle, Scend, TechInfini,

35 35273

How to delete an attribute from the emp table

4 5832

If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?

2 2098

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




Infosys, TCS,

18 33980

wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform


1 6275

how to find out the repeated value from table using groupby function?

4 3840

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?



What is mean by "fill factor" ? and what is mean by "Index "in sql?

iGate, Logica CMG,

1 7050

write the query for taking database backup in sql

IBM, ABC, Logica CMG, MA,

10 28651

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

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


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


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?


How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?


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


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?


How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.


1 01 101 01010


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


Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?


how can u get last observation in an unknown dataset ?


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions


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


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


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?