| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| is it possible to use a variable in a query with the IN
clause (a,b,c..z), without getting quotes or conversion
errors? | | 2 |
| How do you simulate a deadlock for testing purposes | | 1 |
| How to find out name of all employees who has salary less
than 200 Rs.? | | 7 |
| write down the sql query?
Table Name : emp1
empid empname
1 bala
2 guna
Table Name : emp2
empid empname
1 <Null>
2 <Null>
Solution : emp1 names are updated in emp2, write a query?
| | 7 |
| What is BCP? When do we use it? | | 1 |
| how many joins we can write if at all we have n no of
tables | Tanla-Solutions | 4 |
| What are the pros and cons of creating extended stored
procedures? | | 1 |
| What is the difference between HAVING clause and the WHERE
clause? | | 4 |
| how we can count records as a group of days like sum of
records for(four mondays),(four tuesday)........ in a month.
group the column for weekdays.
| | 1 |
| what is replication?
where do u use Go Keyword?
| Satyam | 1 |
| can you any body tell me which service pack is installed in
the sql server? | | 3 |
| From where can you change the default port? | | 3 |
| What is a view? | | 4 |
| what is meant by deafult in sql server?
| | 2 |
| what is the difference between Delete and Truncate | Geo-Research-Centre | 3 |
| can we call functions from stored procedure in SQL Server
2005 ? How? | | 2 |
| i want only duplicates rows from coloumn
ex. emp_id(colomn name)1,1,2,3,3,4,5,5.
so i want only duplicates no.
| iFlex | 2 |
| WHAT OPERATOR PERFORMS PATTERN MATCHING? | CTS | 2 |
| what is physical sort data and logical sort data in index? | | 2 |
| Write a query to delete duplicate records in SQL SERVER | Infosys | 19 |
| |
| For more SQL Server Interview Questions Click Here |