| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Explain the basic concepts of SQL server architecture? | | 2 |
| What are the differences between stored procedure and
functions in SQL Server 2000? | TCS | 12 |
| how to generate XML out of QUERY? | McAfee | 1 |
| 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 statistics, under what circumstances they go out
of date, how do you update them? | HCL | 2 |
| 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 |
| If you are working on a SQL database and if suddenly a
developer changes the code and your queries results start
giving errors,how will you check using a T-SQL query (on
system tables) that what has changed in the database. | Microsoft | 2 |
| What is the use of MOVE keyword in restore command | IBM | 2 |
| write coding for importing sql data into a word excel...
| Oracle | 1 |
| logshipping is Any difference 2000 and 2005? | | 1 |
| Table student containing 2 columns,Join date,Employee name.
Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar-
2008,4-feb-2008.Under Employee name 4 difeerent names
jaison,robin,binoy,rahul
Result set is,
Table containing 4-column name=jan,feb,mar,april,,beneath
these months count is given as 1,2,1,0 means these counts
representing number of emplooyees joined in a month(january
1employee,february 2 employee,march 1 employee,april 0
employee)
Can you give me the required sql query | Wipro | 3 |
| How can your resolve deadlocks? | IBM | 3 |
| what is Archive old data? | | 1 |
| How to delete particular value in the column of a table.Is
it possible or not?if possible give it as in query. | | 4 |
| How do you check the performance of a query and how do you
optimize it? | | 1 |
| What is Report Server,Report Manager and Report Builder in
SSRS 2005? | | 1 |
| What is the difference between views and stored procedures?
Can we have input parameters for views? | | 3 |
| What is WITH CHECK OPTION | Karur-Vysya-Bank-KVB | 2 |
| What is the difference between distinct clause and group by
clause? | Value-Labs | 1 |
| What is the difference between IN and EXISTS operators in
SQL Server? | Intelligroup | 3 |
| |
| For more SQL Server Interview Questions Click Here |