| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| how to get the rowid/rownumbes of a table in sqlserver | IBM | 5 |
| What is a transaction and what are ACID properties? | | 2 |
| How To Change Column Ordinal Position in SQL Server 2005
using Query i.e I Want To Add Column at Particular Ordinal
Position in SQL Server 2005 | | 2 |
| Rate yourself in .NET and SQL ? | Cognizent | 1 |
| What is an Index? | Yardi-Software | 3 |
| how insert selected column only ? | Robert-Half | 2 |
| how to update a null value field in sql server
eg
a table contains 3 fields id,name,salary
and 3 records
salary of 1 record is null
i want update the nullfield
111 arun 300
112 ddd 200
113 ttt null
i want to update table with add 100 to every record include null
after updation
the recrds should be
111 arun 400
112 ddd 300
113 ttt 100
| HCL | 6 |
| How can we write or define DDL statements in Sql server and
DML statements? | | 2 |
| what is a stored procedure and trigger? | | 1 |
| Which virtual table does a trigger use? | | 3 |
| what is the main difference between constraints(like
primary key etc..)& joins? | Annik | 2 |
| how to find the particular row in table?(means suppose one
table contain 10 rows , in these 10 rows how to find the
particular row(example in 10 rows i want 5 row how)? | Marlabs | 8 |
| How to work on DTS?what is the main requirement? | ivan | 1 |
| Following are some of the question related to below
mentioned query?
select e1.salary from employee3 e1
where 2=
(
select count(distinct(e2.salary))
from employee3 e2 where e2.salary>=e1.salary
)
1) What the query returns?
2) How it works? - Detail explanation (what the sub query
does, why it is (where 2=)....etc...Please?
| | 3 |
| how to delete duplicate rows from table in sql server | HCL | 8 |
| could u plz explain about joins and views? | | 2 |
| What's the difference between a primary key and a unique key? | Wipro | 8 |
| Let us say master db itself has no backup. Now you have to
rebuild the db so what kind of action do you take? | | 1 |
| Explain different isolation levels? | | 3 |
| What meant by Performance Tuning,how can we do the
performance tuning on stored procedures and tell some steps
to do the performance tuning | TCS | 2 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
