| Other SQL Server Interview Questions |
|| Asked @
|One table Test with single column. These are the values in
I need a query (without using any variable) with output as -
a b c
d f f
|There is a table1 with records (1,2,3,4,5,6) and table2
with records (4,5,6,7,8,9).write a query so as to get the
result as 1,2,3,4,5,6,7,8,9
|select empid empname from employee
What is the result for the about query?
|write down the sql query?
Table Name : emp1
Table Name : emp2
Solution : emp1 names are updated in emp2, write a query?
|what is the disadvantage of SQL Loder?
|I have to display ten columns values from diffrent ten
how many joins are require?
|hi i am having .mdf file and .ldf file ..how can i get the all
table in my .mdf..plz give solution
|One table how may column and Primary key
|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.
|Explain different isolation levels?
|What is the difference between views and stored procedures?
Can we have input parameters for views?
|What are all new concepts in SQL Server 2008? That is
Exactly Difference between 2005 to 2008
|For more SQL Server Interview Questions Click Here |