| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| how to rest identity columns in sql server | Matrix | 3 |
| What are the different ways of moving data/databases
between servers and databases in SQL Server? | HCL | 2 |
| 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 |
| Whether the updations made to the views reflect the
original records in the table | NIIT | 5 |
| What is Peer to peer Replication? | HCL | 1 |
| What is the difference between having and where clause? | | 4 |
| About types of indexes in SQL server ? | Cognizent | 1 |
| What is normalization and what are the different forms of
normalizations? | | 1 |
| How can u convert the Date to String? | TCS | 4 |
| Can we create a clustered index on composite primary key. | | 2 |
| write down the sql query?
Table Name : emp1
empid empname
1 bala
2 guna
Table Name : emp2
empid empname
1 <Null>
2 <Null>
Solution : emp1 names are updated in emp2, write a query?
| | 7 |
| Can a stored procedure call another stored procedure. If yes
what level and can it be controlled? | | 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 a materialized view? | | 2 |
| 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 |
| what is a cursor and what is its use? | | 1 |
| How will u find the query which is running in some other
machine | IBM | 2 |
| What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE? | Yardi-Software | 4 |
| is there more the two primary key in a single table? | Systematix | 22 |
| Can you give an example of Stored Procedure? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |