| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is a stored procedure? | | 3 |
| How to link up the text file to a Database table? | Allianz | 1 |
| Advantages and Disadvantages of Cursor? | Zenith | 10 |
| What are the types of indexes available with SQL Server? | | 2 |
| what is meant by sql injection with example and one more
question how to catch the errors in sqlserver | | 1 |
| How to find the last update record in SQL Server? | | 3 |
| PC(code, model, speed, ram, hd, cd, price)
Find the hard drive sizes that are equal among two or more
PCs.
| APX | 2 |
| WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE
RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,... | TVS | 2 |
| What is the diff between Static Queries and Dynamic queries
give me some examples | CSC | 1 |
| What's the maximum size of a row? | | 4 |
| I have to display ten columns values from diffrent ten
tables.
how many joins are require? | HCL | 8 |
| what is advantages in sql 2005 over sql 2000? | | 4 |
| What are the different ways of moving data/databases
between servers and databases in SQL Server? | | 1 |
| Which data type can be used only on OUTPUT parameters of the
stored proceduer? | | 2 |
| what is syntex second or third highest salary.
thanks & Regards
Dhirendra sinha | | 4 |
| I need a query that retrieves info from an Oracle table and
a query that retrieves info from a SQL Server table. The
info has to be joined together according to Record ID
numbers. I have very limited access to the Oracle database
but full control of the SQL Server database.How do I join
two different queries from two different databases?
| | 1 |
| Can you give an example of Stored Procedure? | | 2 |
| Let us say the SQL Server crashed and you are rebuilding the
databases including the master database what procedure to
you follow? | | 2 |
| please tell me the query to get details of the employee
having the second largest salary | 247Customer | 8 |
| MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE | IBM | 1 |
| |
| For more SQL Server Interview Questions Click Here |