what's the difference between a primary key and a unique key? : Sql server database administration
No Answer is Posted For this Question
Be the First to Post Answer
what does the automatic recovery do? : Sql server administration
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
What are subqueries in sql server? Explain its properties.
what is raid? : Sql server database administration
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.
Do you know what is sql service broker?
What is the use of placing primary key and foreign key constrains on columns.
How to view the error log for any specific instance? : sql server database administration
What is a document index?
Distinguish between commit and rollback?
What is the difference between functions and scalar functions?
How do I view views in sql server?
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)