| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is a sub-query? When would you use one? | | 2 |
| What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL? | | 1 |
| 1.what is stored procedure?Its significance with example?
2.Explain about index with syntax and example?
plz do reply......... | | 1 |
| what is Data Transformation Services (DTS) ?can u explain
me in detail? | TCS | 4 |
| how to delete duplicate rows from table | CSC | 2 |
| How do we return a record set from a Stored Procedure in SQl
server 2000? | | 2 |
| what is web server?
| Satyam | 3 |
| how can do you the system monitoring? | | 1 |
| How to link up the text file to a Database table? | Allianz | 1 |
| what are file groups? | Evalueserve | 3 |
| In clustered and non clustered indexes which one is faster
while executing a query ? | | 1 |
| how to get 25th row in any table in sqlserver can u tell me
syntax | | 4 |
| What is user stored procedure & it purpose? | Wipro | 3 |
| How to work on DTS?what is the main requirement? | ivan | 1 |
| What is the default value of CHAR type? | Bosch | 6 |
| how to get the rowid/rownumbes of a table in sqlserver | IBM | 1 |
| what are three different authentications to connect linked
servers? | CitiGroup | 1 |
| How to give a user the option of importing Excel and a
delimited text file into a SQL Server Database without
manually using SQL DTS?
| GE | 1 |
| What is database replicaion? What are the different types
of replication you can set up in SQL Server? | | 2 |
| create procedure proc1 (@a int)
as
begin
if @a=1
create table #temp(a1 int)
else
create table #temp(a1 int)
end
while executeing the above code it shows error
like '#temp already exist' .why it shows an error? | IBM | 1 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
