| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| to explain sql server 2000 architecture & authentication | | 1 |
| What is cursor ? And what is difference between Trigger ? | HCL | 1 |
| logshipping is Any difference 2000 and 2005? | | 1 |
| i have a table student like
sname
-----
ram
ram
ram
raj
raj
raj
i need the output like
sname
-----
ram
raj
ram
raj
ram
raj
| IBM | 7 |
| What are the type of joins? When do we use Outer and Self joins? | | 3 |
| i want to join two queries....and i want to run them as one
after another that is want output of first query then
second , then again output of first query then second and
so on... | | 2 |
| How do you know which index a table is using? | | 4 |
|
CLR Integration ?
what is Notification services ?
| Satyam | 1 |
| When do you use SQL Profiler? | | 2 |
| explain different types of jions with examples briefly? | Zensar | 3 |
| what are default? Is there a column to which a default cant be
bound? | | 1 |
| What is a join and their types? | Challenger-Financial | 2 |
| how to implement locking in sql server | Satyam | 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 |
| what is a stored procedure and trigger? | | 1 |
| How do we rollback the table data in SQL Server | | 3 |
| what is the signification difference of this bit data type
between sql 6.5 and later version sql server? | | 1 |
| 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 work on DTS?what is the main requirement? | ivan | 1 |
| Can we create a clustered index on composite primary key. | | 2 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
