| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is INTVAL( )and where we use
Plz any body help me | | 1 |
| what is syntex second or third highest salary.
thanks & Regards
Dhirendra sinha | | 4 |
| What is transcation?Plz give One example? | | 2 |
| what is Constraint? How many types of constraints in SQL ? | NIIT | 7 |
| Can you explain the role of each service? | | 1 |
| What are the types of model in sql server and explain | TCS | 1 |
| Please tell me some knowledge about Clustering and how to
add clustering? | | 1 |
| 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 |
| What are the authentication modes in SQL Server? | | 2 |
| What does it mean to have quoted_identifier on? What are the
implications of having it off? | | 2 |
| Can we create clustered index on non primary key column | CTS | 14 |
| What is the difference between temp table and table variable? | Microsoft | 4 |
| Difference between Triggers and Stored Procedure | Protech | 9 |
| select empid empname from employee
What is the result for the about query? | | 4 |
| What is de-normalization and when do you do it? | | 3 |
| Explain the architecture of SQL Server? | | 2 |
| CREATE TABLE [dbo].[HPMS_CompetencyTypes](CompetencyType
varchar(50) )
go
create trigger hpms_create_Insert
on HPMS_CompetencyTypes
for insert
as
if Exists ( select * from [HPMS_CompetencyTypes] where
CompetencyType=(select * from [HPMS_CompetencyTypes]))
begin
Rollback tran
Raiserror ('duplicate value',12,6)
go
insert HPMS_CompetencyTypes (CompetencyType) values ('new')
I'm new to trigger can any one tell me where is the issue.
Please. | | 2 |
| what is the importence of the trigger in sqlserver2000? | ATI | 1 |
| how can i store resumes in database? | HCL | 2 |
| in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc. | | 7 |
| |
| For more SQL Server Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
