| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| i have 4 tables.. T1, T2, T3, T4..
these tables have the same structure and they store the
information entered in different years..
T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored
2005..
i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and
T4 to T1..
how do i do that? Temp tables cannot be used.. | | 2 |
| What are the different ways of moving data/databases
between servers and databases in SQL Server? | | 1 |
| UPDATE statement can on a single table or on the multiple
table? | iGate | 5 |
| Can we call SP inside a query? | Wipro | 4 |
| Wht is the difference between stored procedure and trigger | TCS | 3 |
| How to find the last update record in SQL Server? | | 3 |
| Difference between writing SQL query and stored procedure ? | Cognizent | 8 |
| Name three version of sql server 2000 and also their
differences? | | 1 |
| what is extended StoreProcedure ?
| Satyam | 3 |
| how to get the automatic backup of the database in the sql
server | | 3 |
| Explain Trigger with an example?
| | 1 |
| any one can explain
Self mapping
Delegation
Remote Credentials | | 1 |
| What is INTVAL( )and where we use
Plz any body help me | | 1 |
| Which command using Query Analyzer will give you the version
of SQL server and operating system? | | 3 |
| How the data stores in a page? | | 1 |
| What is a table called, if it does not have neither Cluster
nor Non-cluster Index? | | 1 |
| how can u select the Distinct values in the table, table
having 20 columns , i want all columns | | 1 |
| when we use function instead of procedure? plz tell me the
situation with ex? | | 1 |
| How can I create a plain-text flat file from SQL Server as
input to another application? | | 2 |
| SYNTAX FOR VIEWS WITH EXAMPLE
HOW TO LINK TWO TABLES | Microsoft | 1 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
