Interested to Buy Any Domain ? << Click Here >> for more details...
What is a non-clustered index?
- 0 Answers
- 1043 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How you would rewrite the sql query to return the customerid sorted numerically?
Tell me what are the essential components of sql server service broker?
How to concatenate two character strings together?
What are secondary xml indexes?
How do you start single user mode in clustered installations?
Relational calculus is what type of language?
Explain atomicity?
What is a transact-sql statement?
How to write character string constants or literals in ms sql server?
Write a query to delete duplicate records in SQL SERVER
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.
What are constraints?
-
Oracle (3253) - 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)
