| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| we have emp table like Ename,EDOJ,EDOB with Column
structure.but we want to know the employee Age.How? Any
Body Plz | | 6 |
| How to Display, Amount of Disk Activity Generated by
Transact-SQL Statements?
| | 1 |
| syntax for deleting the database in T SQL | | 4 |
| Difference Between varchar and nvarchar datatype? | Satyam | 2 |
| Explain different isolation levels? | | 3 |
| What is the difference between IN and EXISTS operators in
SQL Server? | Intelligroup | 3 |
| What is a cursor in SQL Server 2000 and their types? | | 4 |
| Is it possible to create a stored procedure that runs a
query and outputs the results to a text file and allows me
to add extra delimeters and static field info. If so How? | | 1 |
| How to find out name of all employees who has salary less
than 200 Rs.? | | 7 |
| how can u select the Distinct values in the table, table
having 20 columns , i want all columns | | 1 |
| Please tell me some knowledge about Clustering and how to
add clustering? | | 1 |
| what is the cursor life span? | Evalueserve | 5 |
| Can some one please help with a query which will take only
max value of a column in a join. | | 2 |
| 1.what is stored procedure?Its significance with example?
2.Explain about index with syntax and example?
plz do reply......... | | 1 |
| Name three version of sql server 2000 and also their
differences? | | 1 |
| Write a query to delete duplicate records in SQL SERVER | Infosys | 19 |
| Can we rewrite subqueries into simple select statements or
with joins? Example? | ASD | 1 |
| Can you create UNIQUE and PRIMARY KEY constraints on
computed columns in SQL Server 2000? | Infosys | 1 |
| What is blocking and how would you troubleshoot it? | | 1 |
| i want to create procedure for create table in sql server
2005
for example
create procedure create_table
@table varchar(20)
as
create @table(
id int,
name char(20)
)
but it will get error
what is solution?
| Aptech | 4 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
