Interested to Buy Any Domain ? << Click Here >> for more details...
How to create a login account in ms sql server to access the database engine using "create login" statements?
- 0 Answers
- 1063 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What are sparse columns?
What is data compression?
what is performance tunning in sql server ? explain.
How to create a simple stored procedure in ms sql server?
If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?
what operator performs pattern matching?
How to get all stored procedures in sql server?
What does man by sql wildcard characters in sql server?
Explain the benefits of user-defined functions?
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.
Explain the difference between cross join and full outer join?
Why do we use stored procedures 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)
