How to create a new schema in a database?
No Answer is Posted For this Question
Be the First to Post Answer
What is the datatype of rowid?
Explain ms sql server reporting services vs crystal reports?
Can you have a nested transaction?
Which virtual table does a trigger use?
What is sql language?
What is dbcc updateusage?
What is the use of toad or sqldbx.?
What are the different types of subquery?
What is Report Server,Report Manager and Report Builder in SSRS 2005?
What does ss stand for sexually?
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 many cores do I need for sql server 2016?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)