| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| hi, may i know what is the command to get abstract the
current month, current year and current day from a given
date.i want these three in a isolated way..seperatedly is
that any way in sql server 2000 | | 3 |
| What is the datatype returned by count(*) | Asian-CERC | 16 |
| Difference between writing SQL query and stored procedure ? | Cognizent | 8 |
| What types of integrity are enforced by a foreign-key
constraint
| | 1 |
| 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 |
| Explain the new features of SQL server 2000? | | 1 |
| Where do you think the users names and passwords will be
stored in sql server? | | 2 |
| What is a table called, if it does not have neither Cluster
nor Non-cluster Index? | | 1 |
| can any one please send sql quries most used in applications. | | 1 |
| what is normalization?
what is denormalization?
| Satyam | 4 |
| How to Display, Amount of Disk Activity Generated by
Transact-SQL Statements?
| | 1 |
| Which virtual table does a trigger use? | | 3 |
| If there exist a index on the table, and we then make a
view on that table (include the indexed column from base
table) than why do we require indexing on view?Doesnt it
create an overhead? | | 1 |
| how do we find every fifth record in a table | | 6 |
| WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT? | | 3 |
| what is index seek and index scan? | | 2 |
| how to find out the repeated value from table using groupby
function? | | 3 |
| What is the difference between Drop and Truncate | | 7 |
| How to find the last update record in SQL Server? | | 1 |
| what is the purpose of creating view is sql server 2000 | Wipro | 6 |
| |
| For more SQL Server Interview Questions Click Here |