| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to handle errors in Stored Procedures. I want to display
a message to the user in the .aspx page that is calling a
stored procedure in it's code behind. please help me. | 247Customer | 1 |
| How will oyu test the stored procedure taking two parameters
namely first name and last name returning full name? | | 3 |
| I have to display ten columns values from diffrent ten
tables.
how many joins are require? | HCL | 8 |
| hi,
i have a table called names and field name
select * from names
name
a
b
c
d
i want to display like this
name
a,b,c,d
how it is possible
Regards
Baiju | | 3 |
| WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER? | | 6 |
| How to find the last update record in SQL Server? | | 3 |
| 9. Write a query to list a new column with the
difference in temp of the cities Delhi and Mumbai, Mumbai
and Jammu and soon. Consider the following table :
City_id City Temp.
1 delhi 40
2 Mumbai 35
3 Jammu 32
4 Pune 18
| | 1 |
| What is the difference between Userdefined function and
stored procedure? Explain and give the example also | | 4 |
| What is RAID and what are different types of RAID
configurations? | Wipro | 5 |
| What are SQL Jobs, please mention the use of it and how to
create them. | 247Customer | 1 |
| Lets say due to N/W or Security issues client is not able to
connect to server or vice versa. How do you troubleshoot? | | 1 |
| How can we write or define DDL statements in Sql server and
DML statements? | | 1 |
| Can we create a clustered index on composite primary key. | | 2 |
| Can Having clause be used without Group by clause? | CTS | 3 |
| how do we find every fifth record in a table | | 11 |
| Explain the basic concepts of SQL server architecture? | | 2 |
| What are the steps you will take to improve performance of
a poor performing query? | HCL | 1 |
| How to perfor If the table running time is taking 2hours
and table is having 10 rows in it? | | 1 |
| what are batch in sql server?
| Satyam | 2 |
| 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 |
| |
| For more SQL Server Interview Questions Click Here |