your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
- 0 Answers
- 737 Views
- I also Faced
- E-Mail Answers
What purpose does the model database server?
What is the use of group by clause?
What are exact numeric data types in ms sql server?
How to select true false based on column value in sql server?
What are different types of data sources?
what is the difference between table and view
What is default constraint in ms sql server?
What is stored in the mssqlsystemresource database? : sql server database administration
how to copy only distinct data into another table which is not already exist in database?
What are alternate keys?
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 transact-sql statement?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
