| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| how many joins we can write if at all we have n no of
tables | Tanla-Solutions | 3 |
| What are the new features in SQL Server 2005? | Emphasis | 2 |
| What do you mean by COLLATION? | | 4 |
| MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE | IBM | 1 |
| Is it possible to create a stored procedure that runs a
query and outputs the results to a text file and allows me
to add extra delimeters and static field info. If so How? | | 1 |
| What are the main control-of-flow T-SQL constructs?
| | 1 |
| Is it possible to create tables in stored procedures using
a variable for the table name? | | 1 |
| what operator performs pattern matching? | | 1 |
| What is user stored procedure & it purpose? | Wipro | 3 |
| Difference Between varchar and nvarchar datatype? | Satyam | 2 |
| what is IDE,DMV in sql server? | Value-Labs | 1 |
| Explain different isolation levels? | | 3 |
| How many max. conditions can b written under the WHERE
clause?
Like select * from [tabnam] WHERE
(cond1...or..cond2....or...cond3...and.....so on.....???
(upto how much extent))????? | SAP-Labs | 1 |
| How to retrieve duplicate rows in a table?
How to delete the duplicate entries in a table? | Leo-Technologies | 9 |
| how to find out the repeated value from table using groupby
function? | | 3 |
| I Have Employee table having column name as ID,SALARY
how to get second max salary from employee table with id
ex
ID SALARY
1 20000
7 37000
2 5000 | | 10 |
| is there more the two primary key in a single table? | Systematix | 19 |
| How to give a user the option of importing Excel and a
delimited text file into a SQL Server Database without
manually using SQL DTS?
| GE | 1 |
| what command is used to create a table by copying the
structure of another table? | | 4 |
| how insert selected column only ? | Robert-Half | 1 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
