| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the difference between 2-Tier architecture and
3-Tier architecture | Oracle | 10 |
| HOW TO RENAME A COLUMN NAME | | 2 |
| 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 |
| how to give input dynamically to a insert statement in
sqlserver | HCL | 2 |
| What is cursor ? And what is difference between Trigger ? | HCL | 1 |
| What does the INSTEAD OF trigger do? | | 3 |
| Plz tell about backup&recovery? | | 2 |
| what are the problems in logshipping? | | 2 |
| how to change column into row in sql | ESS | 2 |
| Please give me the SP for the below scenario. I have two
tables named Table1 and Table2...I need to fetch record by
record from Table1 and insert the record in to table2 where
the value in the sno column of the table1 is even number. | Value-Labs | 4 |
| What types of integrity are enforced by a foreign-key
constraint | | 1 |
| Which virtual table does a trigger use? | TCS | 6 |
| What is the purpose of using COLLATE in a query? | | 1 |
| what is physical sort data and logical sort data in index? | | 2 |
| When do we use the UPDATE_STATISTICS command? | | 3 |
| How to list all tables having unique constraints in any of
the columns in a database. | | 1 |
| how we can count records as a group of days like sum of
records for(four mondays),(four tuesday)........ in a month.
group the column for weekdays.
| | 1 |
| What is the system function to get the current user's user
id? | HCL | 1 |
| What are the all different types of Joins in SQL Server
2000, Anybody can explain each join with definition..Thanks
in advance.... | Siemens | 6 |
| Suppose in a situation if two list boxes are there and if
you select multiple options based on that the options
related to those selected items should display in second
list box.
Again if we select multiple items in second listbox then the
related to those selected items should display .
In this scenario how will you design database,tables? | HP | 1 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
