| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the difference between local table and global table | Polaris | 1 |
| what is the main difference between constraints(like
primary key etc..)& joins? | Annik | 2 |
| hi,
how to match retrieve the unmatched records from 2 tables
in which we dont have any primary key. example : table1 has
1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want
the numbers from 6 to 10 to be displayed and should not
come as null. i need the numbers. please reply as soon as
possible.
| | 2 |
| What is the differecne between equi-join and inner-join and
natural join..Is there any difference or all are same? | Microsoft | 2 |
| What is the role that is required for killing a process
What is the role that is required for creating a linked
server
| IBM | 1 |
| Can you link only other SQL Servers or any database servers
such as Oracle? | | 1 |
| How to write stored procedure to update the data in 10
tables | | 4 |
| What is the difference between OLEDB and ODBC | CFCI | 3 |
| How to select nth record from a table? | DELL | 9 |
| If you are working on a SQL database and if suddenly a
developer changes the code and your queries results start
giving errors,how will you check using a T-SQL query (on
system tables) that what has changed in the database. | Microsoft | 2 |
| Which stored procedure will you be running to add a linked
server? | | 1 |
| WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE
RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,... | TVS | 2 |
| Can you give an example of Stored Procedure? | | 2 |
| A table contains list of customers and his city with other
details. Each customer has a unique number and the table
consists millions of data. Query is: I want to retrieve 10
customers from each city, no script, only from single query? | Infosys | 3 |
| Display a roll having miminum marks in two subjects? | Patni | 7 |
| I am having table Title with TITLE id,Author ID, Publiser
ID , table AUTHOR with Author ID, Author Name, table
PUBLISER with Pub ID, Pub name Here hot to find out the
publiser id who have relesed the books of patriticular
author? | | 3 |
| Can I know,how to Execute Funcion and Trigger through
command(Manualy Execution) in MS SQL/SERVER 2005,give me
answer with Example. | | 1 |
| What r sql reporting services and analysis services? how
can we use it. | Microsoft | 2 |
| what is Constraint? How many types of constraints in SQL ? | NIIT | 7 |
| What are different types of Keys? Please explain all the
keys with a suitable example. | | 2 |
| |
| For more SQL Server Interview Questions Click Here |