| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Can Having clause be used without Group by clause? | CTS | 4 |
| I have to display ten columns values from diffrent ten
tables.
how many joins are require? | HCL | 8 |
| Name three version of sql server 2000 and also their
differences? | | 1 |
| Hi Can any one tell me the Good institute to learn SQL esp
for Data Base Testing or SQL from scratch to the
proficiency level in Hyederabad and facult also. Thankyou
well in advance | | 6 |
| What do u mean by orphan users, how will u list them in the
DB | IBM | 2 |
| Is it possible to delete duplicate rows in a table without
using a temporary table ? | | 6 |
| Alternative way to DetDate() function? | | 4 |
| What is the difference between windows authentication and
sql server authentication | HCL | 4 |
| How to perfor If the table running time is taking 2hours
and table is having 10 rows in it? | | 1 |
| i want only duplicates rows from coloumn
ex. emp_id(colomn name)1,1,2,3,3,4,5,5.
so i want only duplicates no.
| iFlex | 2 |
| What is RAID and what are different types of RAID
configurations? | Wipro | 5 |
| What is user stored procedure & it purpose? | Wipro | 3 |
| After using delete statement in sql query to delete some
records...to retrieve the deleted records we can get using
rollback command but till that where it stores means
particular location name i need....(after deleting and
rollback ) | iGate | 2 |
| How many max. conditions can b written under the WHERE
clause?
Like select * from [tabnam] WHERE
(cond1...or..cond2....or...cond3...and.....so on.....???
(upto how much extent))????? | SAP-Labs | 2 |
| how do we find every fifth record in a table | | 11 |
| system date format is "yy-mm-dd"
"select getdate()" ----> 2009-01-24 20:03:28.513
if i write "select dateadd(dd,2,getdate())
".it returns "2009-01-26 19:59:38.340"...my question is dat
could it be possible to retrive da date in da format "26
jan 2009 ...."??
| | 8 |
| what is advantages in sql 2005 over sql 2000? | | 4 |
| what is diffence between replicaion and logshipping? | | 1 |
| What is Covering Indexes?
Plz explain with example | | 2 |
| I have a table EMP in which the values will be like this
EmpId Ename Sal DeptId
11 Ram 10000 10
11 Ram 10000 10
22 Raj 20000 20
22 Raj 20000 20
33 Anil 15000 30
33 Anil 15000 30
I want to delete only duplicate Rows. After Delete I want
the output like this
EmpId Ename Sal DeptId
11 Ram 10000 10
22 Raj 20000 20
33 Anil 15000 30
| DELL | 10 |
| |
| For more SQL Server Interview Questions Click Here |