Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
No Answer is Posted For this Question
Be the First to Post Answer
Differences between functions and stored procedures?
8 Answers 247Customer, Accenture,
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.
How to test subquery results with the exists operator?
Is null in sql server?
What is the difference between inner join and equi join?
How to create user defined functions with parameters?
Explain trigger classes i.e. Instead of and after trigger?
How to make a column nullable?
What happens when converting big values to numeric data types?
what is procedure in sql?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
What do you think of this implementation? Can this be implemented better?