| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Well sometimes sp_reanmedb may not work you know because if
some one is using the db it will not accept this command so
what do you think you can do in such cases? | | 2 |
| What is row by row processing ? | | 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 |
| What are the differences between stored procedure and
functions in SQL Server 2000? | TCS | 12 |
| how to update a null value field in sql server
eg
a table contains 3 fields id,name,salary
and 3 records
salary of 1 record is null
i want update the nullfield
111 arun 300
112 ddd 200
113 ttt null
i want to update table with add 100 to every record include null
after updation
the recrds should be
111 arun 400
112 ddd 300
113 ttt 100
| HCL | 6 |
| what is difference between nchar and char in Sql server ?
| | 2 |
| can any one answer this query,thank you in advance
Table 1 has 2 columns: EmployeeId, T shirtsize(values can
be 1,2,3)
Table 2 has 2 columns: EmployeeId, Region
Write SQL to Find the region which has the largest number
of people with Tshirt size=3
| Google | 10 |
| there is a table having two columns no and name
and the data is
1 A
2 B
3 C
write a query that will result a horizontal output
A,B,C
| vsworx | 7 |
| event classes in sql server | Accenture | 1 |
| What is the difference between SSAS 2000 and SSAS 2005? | APX | 1 |
| how insert selected column only ? | Robert-Half | 2 |
| How reterive duplicate value in SQL? | | 5 |
| how to find number of columns in a table in sql server 2000
and 2005 also | Virtusa | 10 |
| Explain some DBCC commands? | | 4 |
| How many index keys possible for a table | | 6 |
| What are the steps you will take to improve performance of
a poor performing query? | HCL | 1 |
| What is the Query of getting last 10 transaction Reports
(like insert, update, Delete Data from Tabele) ? | Wipro | 4 |
| What is the appropriate number of test cases that you can
write on a database? | Microsoft | 1 |
| 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 |
| WHAT IS DIFFRENCE BETWEEN TRUNCATE AND DELETE STATEMENT | CTS | 10 |
| |
| For more SQL Server Interview Questions Click Here |