| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Accidentally i deleted my table. How can i get that table? | | 4 |
| Hi SQL gurus,
i am working for an MNC...
My team is having a problem in sql server. when user slects
date prompts from jan 1st to april 30, it should display
all months data like :
jan aa
feb bb
mar cc
but when it comes to april its taking data like :
jan aa
feb bb
mar cc
apr dd...and so on
means its taking data again from jan to april which we dont
want. we want the data only april month as we are getting
jan, feb and mar...
can any one write the code to relsove the issue please
would be greatful if you can send to shiva_sans@yahoo.co.in
and also please send your email also ...so that we will be
in touch for any kind of queries ...
Thanks a lot in Advance !!!
| | 1 |
| What are the differences between stored procedure and
functions in SQL Server 2000? | TCS | 12 |
| 1. What are the grouping function in SQL ?
2. If base table of a view deleted means, what will happen
while we querying on view ? will give any error ?
3. Difference between DROP, DELETE, TRUNCATE table ?
4. What is constraints and types ?
5. What is max size of nchar & nvarchar ?
6. Define ROLLBACK, COMMIT, SAVE POINT
7. How non-clustered better ? or rank the Clustered,
Non-Clustered and Table scan in performance wise
8. Select 10 rows from a table ?
9. Define DML, DDL, DCL, DTL commands ?
10. What is mean by NULL value ? NULL means "" or 0 or
undefined ?
11. Default constraints ?
12. Can we have more then primary Key in table ?
13. Type of integrity ? Entity, Referential, Domain ?
| Perot-Systems | 8 |
| Please tell me some knowledge about Clustering and how to
add clustering? | | 1 |
| what is the maximum size of a row in sql server 2000 and 2005 | | 2 |
| What is transaction ? Give me one example. | Melstar | 7 |
| How to Run a Query on a Remote SQL Server? | | 2 |
| Explain basic SQL queries with SELECT from where Order By,
Group By-Having? | Wipro | 2 |
| What are cursors? | | 8 |
| Explain sp_configure commands, set commands? | | 3 |
| can you any body tell me the how to decrease the logfile | | 4 |
| What is normalization and what are the different forms of
normalizations? | | 1 |
| What is user stored procedure & it purpose? | Wipro | 3 |
| How do you simulate a deadlock for testing purposes | | 1 |
| how many types of store procedre in sqlserver 2000? | ATI | 2 |
| which one will take 1st priority in case of insert statement
and select statement??? | | 2 |
| what is difference between primary key and Unique | | 8 |
| one table has four field id,name,design,salary. i have to
find maximum salary . | | 6 |
| what is the main difference between after trigger and
instead trigger. | | 1 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
