| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the difference between temp table and table variable? | Microsoft | 4 |
| What is a join and their types? | Challenger-Financial | 2 |
| could u plz explain about joins and views? | | 2 |
| What is a view? | | 4 |
| What is the difference between login and a user? | TCS | 7 |
| what is maximum size of temp db? | iSoft | 4 |
| Can a stored procedure call itself(recursive). If yes what
level and can it be controlled.? | | 2 |
| Rate yourself in .NET and SQL ? | Cognizent | 1 |
| Can Having clause be used without Group by clause? | CTS | 4 |
| Please give me queries for the following
1. To get the count of duplicate records.
2. A query to delete the duplicate records. | 247Customer | 3 |
| How to Check Whether a Global Temporary Exists in a SQL
Database or not? | | 2 |
| Advantages and Disadvantages of Cursor? | Zenith | 10 |
| What is Peer to peer Replication? | HCL | 1 |
| There is a trigger defined for INSERT operations on a
table, in an OLTP system. The trigger is written to
instantiate a COM object and pass the newly insterted rows
to it for some custom processing. What do you think of this
implementation? Can this be implemented better? | | 1 |
| What are the magic tables in SQL Server 2000? | Infogain | 5 |
| what is advantages in sql 2005 over sql 2000? | | 4 |
| syntax for deleting the database in T SQL | | 4 |
| What command do we use to rename a db? | | 3 |
| sql server has its default date format in da form "yy-mm-dd"
its possible to convert da current date format of sql
server to desired format. Now my question is dat how to get
da previous and comin days date in my desired format?? | | 1 |
| select the 3rd maximum salary from sql server database if 4
(just an example In practically I may not know the exact
situation) of the highest salaries are equal. | | 7 |
| |
| For more SQL Server Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
