| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is SQL server agent? | SAP-Labs | 2 |
| Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed) | | 5 |
| Differences between functions and stored procedures? | 247Customer | 6 |
| how to rename the table | | 3 |
| How do we get current date in SQL Server 2000, Oracle, MS
Access? | | 11 |
| can any one please send sql quries most used in applications. | | 1 |
| Questions regarding Raiseerror? | | 1 |
| Alternative way to DetDate() function? | | 4 |
| 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
| | 2 |
| How to Generate a Series of Random Integers With T-SQL? | | 1 |
| Let’s say the table in the database is named as
TBL_Register. The fields in this table include:
1. User_Name,
2. User_Telephone,
3. Register_Date
The field Register_Date stores the current date and time of
the registration.
Write the SQL statement that inserts the data into the
table. | Techno-Solutions | 2 |
| How do you persist objects, permissions in tempdb | | 1 |
| explain different types of jions with examples briefly? | Zensar | 3 |
| How can you get @@error and @@rowcount at the same time? | | 5 |
| What is the Query of getting last 10 transaction Reports
(like insert, update, Delete Data from Tabele) ? | Wipro | 4 |
| Explain the new features of SQL server 2000? | | 1 |
| What should we do to copy the tables, schema and views from
one SQL Server to another? | | 3 |
| What's the difference between a primary key and a unique
key? | | 4 |
| What are constraints? Explain different types of
constraints? | | 6 |
| How do you implement one-to-one, one-to-many and many-to-
many relationships while designing tables? | TCS | 3 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
