Interested to Buy Any Domain ? << Click Here >> for more details...
what are the different ways to return the rowcount of a table?
- 0 Answers
- 962 Views
- Microsoft, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is logshipping and its purpose?
How to retrieve error messages using mssql_get_last_message()?
What is inline variable assignment?
How to change server name in sql server?
What are the Pre Requisites when you apply Srvice Packs?
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.
How can you ensure that the database and sql server based application perform well?
How do you find the number of rows in a table?
How to find out the list schema name and table name for the database?
What is rank function?
What are primary keys and foreign keys?
Why it is recommended to avoid referencing a floating point column in the where clause?
-
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)
