Interested to Buy Any Domain ? << Click Here >> for more details...
When a primary key constraint is included in a table, what other constraints does this imply?
- 0 Answers
- 977 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
find 2nd highest salary of person using cursor concept?
The Difference between 'Count' and 'Count(*)'
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
Can some one please help with a query which will take only max value of a column in a join.
What is mapping schema?
What is meant by referential integrity?
What is the ‘fillfactor’?
How to create a trigger for insert only?
How data can be copied from one table to another table?
What is sparse columns of sql server 2008?
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 insert selected column only ?
-
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)
