Interested to Buy Any Domain ? << Click Here >> for more details...
Explain what is the difference between a local and a global temporary table?
- 0 Answers
- 1014 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is tempdb in sql server?
how to count datewise data in sqlserver
4 Answers CarrizalSoft Technologies, IndusInd Bank,
What are the main sources of data?
Explain what are page splits? : SQL Server Architecture
What is the difference between ddl and dml?
Why is replication required on the sql server?
Can sql servers link to other servers like oracle?
What are different types of collation sensitivity?
How to concatenate two character strings together?
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 types of integrity are enforced by a foreign-key constraint
What are the source of constraints?
-
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)
