Interested to Buy Any Domain ? << Click Here >> for more details...
What are cursors and when they are useful?
- 0 Answers
- 1101 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Is natural join and equi join same?
Write a sql query to sort on different column name according to the parameters passed in the function?
How to test odbc dsn connection settings?
Relational calculus is what type of language?
Can the “if update (colname)” statement be used in a delete trigger?
How would we use distinct statement? What is its use?
What does nvl stand for?
What is normalization and its types?
What is a Stored Procedure?
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 the elements of dbms?
What is the purpose of optimization?
-
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)
