| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| 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 |
| write down the code for "how we delete a table without
using of Drop command " ? | Sonata | 2 |
| WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT? | | 5 |
| 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 any one please send sql quries most used in applications. | | 1 |
| what is the signification difference of this bit data type
between sql 6.5 and later version sql server? | | 1 |
| What is transaction ? Give me one example. | Melstar | 7 |
| What are the main control-of-flow T-SQL constructs?
| | 1 |
| Can a stored procedure call another stored procedure. If yes
what level and can it be controlled? | | 2 |
| What types of integrity are enforced by a foreign-key
constraint | | 1 |
| What is the difference between UNION and UNIONALL? | CTS | 2 |
| What is the Query of getting last 10 transaction Reports
(like insert, update, Delete Data from Tabele) ? | Wipro | 4 |
| explain different types of jions with examples briefly? | Zensar | 3 |
| What are the two virtual tables SQL Server maintains for
triggers? | | 2 |
| how many joins we can write if at all we have n no of
tables | Tanla-Solutions | 4 |
| Difference between writing SQL query and stored procedure ? | Cognizent | 8 |
| Which virtual table does a trigger use? | | 3 |
| How to select Distinct columns from the table, table having
20 columns and i want all coulmns | Wipro | 3 |
| wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records | | 16 |
| 1.How to check the backup file details if we do not have
access to that folder
2.how to check the backup file size without connecting to
the folder
| IBM | 1 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
