| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| when inserting to a table how many rows will be effected
using triggers
| | 1 |
| What are mdf,ndf,ldf files and how to see the data in those
files? | Accenture | 5 |
| When do you create cluster and noncluster index? | Satyam | 4 |
| what is Data Transformation Services (DTS) ?can u explain
me in detail? | TCS | 5 |
| What is BCP? When do we use it? | | 1 |
| i need some interview questions on sql server developer plz
any onee send some links. | | 1 |
| Is it possible to delete duplicate rows in a table without
using a temporary table ? | | 6 |
| Difference between Triggers and Stored Procedure | Protech | 9 |
| Questions regarding Raiseerror? | | 1 |
| What are the two virtual tables SQL Server maintains for
triggers? | | 2 |
| how to get the rowid/rownumbes of a table in sqlserver | IBM | 5 |
| Write a query to delete duplicate records in SQL SERVER | Infosys | 19 |
| WHAT IS DIFFRENCE BETWEEN TRUNCATE AND DELETE STATEMENT | CTS | 10 |
| hi,
how to match retrieve the unmatched records from 2 tables
in which we dont have any primary key. example : table1 has
1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want
the numbers from 6 to 10 to be displayed and should not
come as null. i need the numbers. please reply as soon as
possible.
| | 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 a Lock and let me know Different types of locks? | | 1 |
| Which system tables contain information on privileges
granted and privileges obtained | | 1 |
| how to get the automatic backup of the database in the sql
server | | 3 |
| what is mean by crystal repoart? ahere we will mainly use
that? | | 1 |
| When you first load SQL SERVER you will startup with what
all databases? | CompuSol | 3 |
| |
| For more SQL Server Interview Questions Click Here |