| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is trigger | NIIT | 1 |
| What is INTVAL( )and where we use
Plz any body help me | | 1 |
| What value could be assigned to Varchar Type? | | 3 |
| what is the maximum size of a row in sql server 2000 and 2005 | | 2 |
| in tabase table having a column in it empname field is
there which having 5 duplicate values is there i want
deleted all the duplicates i want showing only one name
only. | | 7 |
| how to generate XML out of QUERY? | McAfee | 1 |
| from the table display the 2nd highest salary?
and also the least 2nd salay?
| | 6 |
| Display a roll having miminum marks in two subjects? | Patni | 7 |
| What is row by row processing ? | | 1 |
| How To Make password Protected SQL Server 2005 Database
i.e when i open SQL Server database then ask for password.
| | 1 |
| what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1; | Patni | 9 |
| About types of indexes in SQL server ? | Cognizent | 1 |
| What is a stored procedure? | | 3 |
| hi, may i know what is the command to get abstract the
current month, current year and current day from a given
date.i want these three in a isolated way..seperatedly is
that any way in sql server 2000 | | 3 |
| can you any body tell me simple recovery,full recovery,bulk
logged recovery where can use? | | 1 |
| What is SQL server agent? | SAP-Labs | 2 |
| What is SQL Profiler what is the use of it? | 247Customer | 2 |
| Using query analyzer, name 3 ways you can get an accurate
count of the number of records in a table? | eFunds | 5 |
| what is the signification difference of this bit data type
between sql 6.5 and later version sql server? | | 1 |
| I am Having tables T1 and T2 both having same data how to
check (or) compare the data in both table are same? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |