| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is Constraint? How many types of constraints in SQL ? | NIIT | 7 |
| what is difference between having and where clause ? | | 2 |
| what is index seek and index scan? | | 2 |
| Difference between Function and Stored Procedure? | C1-India | 4 |
| Can a stored procedure call another stored procedure. If yes
what level and can it be controlled? | | 2 |
| What is the diff between Static Queries and Dynamic queries
give me some examples | CSC | 1 |
| What's the purpose of Stored Procedure? | Wipro | 4 |
| what is the difference between sql query and google query? | TCS | 6 |
| What is the difference between IN and EXISTS operators in
SQL Server? | Intelligroup | 3 |
| what is the order of execution of where,having,group by in
select stement | Tanla-Solutions | 5 |
| Difference between Cluster and Non-cluster index? | Oracle | 9 |
| what is IDE,DMV in sql server? | Value-Labs | 1 |
| WHAT IS DIFFRENCE BETWEEN TRUNCATE AND DELETE STATEMENT | CTS | 10 |
| What are the advantages of using views. Why do we need
views when we have SPs? | 247Customer | 3 |
| What are user defined datatypes and when you should go for
them? | | 1 |
| could you please reply for these question:
1.About Use Apply?
2.Avoid cursors - When we have a situation that we can not
avoid the use of cursor than what is the alternate solution?
is there anything we can use instead of cursor to perform
the desired task? which optiomize the peroformance too.
3.What is computed columns?
Thanks in advance.
Regards,
Rupesh
| | 3 |
| logshipping is Any difference 2000 and 2005? | | 1 |
| how to retrive only second row from table in sql server
2000? | CTS | 7 |
| Let’s say the table in the database is named as
TBL_Register. The fields in this table include:
1. User_Name,
2. User_Telephone,
3. Register_Date
The field Register_Date stores the current date and time of
the registration.
Write the SQL statement that inserts the data into the
table. | Techno-Solutions | 2 |
| system date format is "yy-mm-dd"
"select getdate()" ----> 2009-01-24 20:03:28.513
if i write "select dateadd(dd,2,getdate())
".it returns "2009-01-26 19:59:38.340"...my question is dat
could it be possible to retrive da date in da format "26
jan 2009 ...."??
| | 8 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
