SQL Server Interview Questions
Questions Answers Views Company eMail

1 01 101 01010


Find top Nth employee from each department in terms of salary?


13 15198

How to get last system shutdown time in Sql server when restarted system?

1 6129

How maney row would be print after join if A table have 100 rows and B table have 50 rows...


9 5913

How will you collect the date from current date to last older 6 days date in sql server 2005

4 2791

how we can store the value like that 001,003,023 etc in sql server 2005

7 4436

Selet all the data from table where last name is n of employee

2 2698

How to find the latest updated value in a table without sending any parameters to that query

2 3076

how to improve the speed of SQL database server and how to avoid dead lock?


1 4153

What is the disadvantages of index?


3 5101

Hi All, I want to display all duplicate records in the table. My query has to fetch all the records which are duplicate(First Name or Last Name). Also I want the ability to also pull names where there might be a middle initial placed in the end of the first name field, (i.e., "Maria Z. " vs. "Maria") as well. Please guide me to find this. Table: ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 4 Shawn Livermore 5 Prem S 6 Jony Hoffman H 7 Zach Modan I need the query to filter......... ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 6 Jony Hoffman H 7 Zach Modan I hope this example will give you clear idea..... Thanks in Advance Prem

2 2280

select names starts with a,b,c

Scope International,

8 7176

How to convert a table data in XML format in sql server?


how to do partition in sqlserver



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

Crea, HCL,


Post New SQL Server Questions

Un-Answered Questions { SQL Server }

how to take backup bcp out for a column in table in sql server?


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


what is isolation level at dead lock?


What is Lock table in SQL?


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


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?


sql database suspect We have a sql database that is showing as suspect. How can we recover?


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


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible


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.


Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.


how can u get last observation in an unknown dataset ?


how can you attach more than 20 ldf files in sql server


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.