| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are sub-queries? Give example? In which case
sub-queries are not feasible? | Infosys | 3 |
| What are the authentication modes in SQL Server? | | 2 |
| HOW TO RENAME A COLUMN NAME | | 2 |
| how to retrive only second row from table in sql server
2000? | CTS | 7 |
| What is Schema? and why we use schemas? | | 1 |
| what are three different authentications to connect linked
servers? | CitiGroup | 1 |
| What is the difference between IN and EXISTS operators in
SQL Server? | Intelligroup | 3 |
| what is differece between union and union all | | 4 |
| What is the difference between HAVING clause and the WHERE
clause? | | 4 |
| Is it possible to delete duplicate rows in a table without
using a temporary table ? | | 6 |
| What is Deadlock? | Satyam | 3 |
| logshipping is Any difference 2000 and 2005? | | 1 |
| sql server has its default date format in da form "yy-mm-dd"
its possible to convert da current date format of sql
server to desired format. Now my question is dat how to get
da previous and comin days date in my desired format?? | | 1 |
| how to delete duplicate rows from table | CSC | 9 |
| What's the maximum size of a row? | | 4 |
| Say if we have a table that contains only a single column ,
say OrderID, which has IDENTITY attribute defined on it. So
how can we insert data in this table.
I am reframing my question, that how can we make the table
to increment the column "OrderID" value several times??? | | 3 |
| how to write the query to select the rows are in the order
of either 1,3,5,7... or 2,4,6,8,... | ADP | 5 |
| Hi Friends,
I have a table in which there are thousands of records and
in city field there is NULL value for all records now i want
to change that null value with distinct values in each
record say delhi, bihar, agra, jaipur etc, what will be the
query for that?????
its not possible to update thousands of records one by one.
is there any alternative ...?
Plz help ... its urgent
Thanx in advance | | 1 |
| What are the different types of backup avaible in SQL SErver | Emphasis | 5 |
| 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 | 7 |
| |
| For more SQL Server Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
