| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| select empid empname from employee
What is the result for the about query? | | 3 |
| Write a query to delete duplicate records in SQL SERVER | Infosys | 16 |
| What are user defined datatypes and when you should go for
them? | | 1 |
| what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1; | Patni | 6 |
| How do SQL server 2000 and XML linked? | | 1 |
| How can i change the column name. | HCL | 6 |
| please can anyone answer this query
Table 1 has 2 columns: EmployeeId,Age
Table 2 has 2 columns: EmployeeId, Region
Write SQL to Find the region who has the oldest person | | 5 |
| Explain basic SQL queries with SELECT from where Order By,
Group By-Having? | Wipro | 1 |
| What is a Join in SQL Server? | | 1 |
| In performance wise distinct is good or group by is good?
eg:select name from emp group by name;
select distinct name from emp; | Infosys | 2 |
| How to write stored procedure to update the data in 10
tables | | 3 |
| How do I list the available tables in a database I'm
querying? | | 3 |
| Hi..here i would like to know the Backup and Restore models? | HCL | 2 |
| What is the difference between DTS and SSIS? | Allianz | 1 |
| What are defaults? Is there a column to which a default
can't be bound? | | 2 |
| Accidentally i deleted my table. How can i get that table? | | 2 |
| Which data type can be used only on OUTPUT parameters of the
stored proceduer? | | 2 |
| Can we use Truncate command on a table which is referenced
by FOREIGN KEY? | | 1 |
| how to get 25th row in any table in sqlserver can u tell me
syntax | | 4 |
| i want table name basis on column name. | | 2 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map