| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| you are provided with the single table having say 4 col ie
fname lname age city , now the all records with displying of
only fname and lname is required but in this format say my
name is abhay khanna it will come like this
abhay-khanna
rahul-roy
gaurav-singh
the above format is required | | 2 |
| What is the difference Between Sql-server 2000 & 2005 | Value-Labs | 2 |
| What is a sub-query? When would you use one? | | 3 |
| In performance wise distinct is good or group by is good?
eg:select name from emp group by name;
select distinct name from emp; | Infosys | 4 |
| what is diffence between replicaion and logshipping? | | 1 |
| 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 |
| The Difference between 'Count' and 'Count(*)' | | 12 |
| If there is failure during updation of certain rows, what
will be the state? | | 1 |
| What are Sql Reporting Services and analysis services? Can
u Explain | | 1 |
| What's the difference between DELETE TABLE and TRUNCATE
TABLE commands? | | 9 |
| What is excution Plan in sql server | TCS | 1 |
| how to select a field with firstletter as capital and
remaining are small letters | | 8 |
| please can anyone answer this query
Table 1 has 2 columns: EmployeeId,Age
Table 2 has 2 columns: EmployeeId, Region
Write SQL to Find the region who has the oldest person | | 7 |
| Whether the updations made to the views reflect the
original records in the table | NIIT | 5 |
| how to count datewise data in sqlserver | IndusInd-Bank | 3 |
| 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 to replace double quotes by single quotes in sql server | CAC | 2 |
| WHAT IS DIFFRENCE BETWEEN TRUNCATE AND DELETE STATEMENT | CTS | 10 |
| How To Make password Protected SQL Server 2005 Database
i.e when i open SQL Server database then ask for password.
| | 1 |
| Define candidate key, alternate key, composite key. | | 9 |
| |
| For more SQL Server Interview Questions Click Here |