What is save transaction and save point?
No Answer is Posted For this Question
Be the First to Post Answer
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
do you know how to configure db2 side of the application? : 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.
What is a Linked Server?
What is ms sql server triggers?
What is a trigger and types of a trigger?
Tell me what is log shipping?
What is the purpose of self join?
Explain the flow of creating a cube? : sql server analysis services, ssas
How to create stored procedures with parameters in ms sql server?
What is local temp table?
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
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)