| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What does it mean to have quoted_identifier on? What are the
implications of having it off? | | 2 |
| How to delete particular value in the column of a table.Is
it possible or not?if possible give it as in query. | | 4 |
| There is table like Events...in that name ,startdate
,enddate,location are the column names
write a stored Procedure for this table to get events by
Months "GetEventsByMonths" | | 1 |
| Explain different isolation levels? | | 3 |
| 1.can we set the more than 1 primary keys for a table?
2.please give me the difference between Cluster Index and
non-Clustered Index
3.can we use query like this "Select * from Table1,Table2;" | | 6 |
| Can you explain the types of Joins that we can have with Sql
Server? | | 2 |
| How to write stored procedure to update the data in 10
tables | | 4 |
| wt is mean by acid property? i know it is
atomocity,consistency,isolation and durabulaty but wt is
these mean and wt actions it's perform | Idea | 1 |
| how to rest identity columns in sql server | Matrix | 3 |
| What is an extended Stored Procedure? | | 1 |
| 1.what is the purpose of using alias name in sql server?
with certain example?
2.what is cursor?will u plz explain me in detail with
certain example? | | 3 |
| What are the differences between stored procedure and
functions in SQL Server 2000? | TCS | 12 |
| Wht is the difference between stored procedure and trigger | TCS | 4 |
| Explain Trigger with an example?
| | 1 |
| 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 |
| How the data stores in a page? | | 1 |
| any one can explain
Self mapping
Delegation
Remote Credentials | | 1 |
| what is the output for this query
select * from employee where 1=1; | | 4 |
| when inserting to a table how many rows will be effected
using triggers
| | 1 |
| How to display n-1 columns from n number of columns, from a
single table in MS SQL server 2005? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |