| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| 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 |
| Let us say the SQL Server crashed and you are rebuilding the
databases including the master database what procedure to
you follow? | | 2 |
| Can you give an example of Stored Procedure? | | 2 |
| What is BCP? When do we use it? | | 1 |
| What are cursors? Name four types of cursors and when each
one would be applied? | Adea-Solutions | 1 |
| What is difference between Triggers and store procedure? | | 2 |
| How to create logins using windows Authentication mode? | | 2 |
| Accidentally i deleted my table. How can i get that table? | | 4 |
| If there exist a index on the table, and we then make a
view on that table (include the indexed column from base
table) than why do we require indexing on view?Doesnt it
create an overhead? | | 1 |
| What is a trigger? | | 6 |
| Explain Different types of Projects? | | 1 |
| How can i give the restrictions for the data entry, if i
wish to enter only I ,II, III, IV in the grade actegory of
student table? | | 3 |
| what is the signification difference of this bit data type
between sql 6.5 and later version sql server? | | 1 |
| What do you mean by COLLATION? | | 4 |
| What is the difference between a Application Server and a
Database | Oracle | 2 |
| I have a table in which phno is one of the columns.i do have
some values in tht phno column.i need to update phno column
values with 0(zero) as prefix.give me a correct solution plz... | Value-Labs | 5 |
| Questions regarding Raiseerror? | | 1 |
| what is the difference between sql query and google query? | TCS | 6 |
| What is transcation?Plz give One example? | | 2 |
| i have a table student like
sname
-----
ram
ram
ram
raj
raj
raj
i need the output like
sname
-----
ram
raj
ram
raj
ram
raj
| IBM | 7 |
| |
| For more SQL Server Interview Questions Click Here |