Interested to Buy Any Domain ? << Click Here >> for more details...
How to remove duplicate rows from table except one?
- 0 Answers
- 940 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How to trouble shoot if unable to connect SQL Server
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What is a periodical index?
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
What does null mean?
Why would you call update statistics?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
Which joins are sql server default?
Which sql server table is used to hold the stored procedure scripts?
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.
Comment,Datatypes are unlimited
How to compare the top two records using sql?
-
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)
