how many type of indexing in database?
No Answer is Posted For this Question
Be the First to Post Answer
What are the tool windows in sql server management studio? : sql server management studio
how to control the amount of free space in your index pages? : Sql server database administration
How you can get a list of all the table constraints in a database?
What are mdf,ndf,ldf files and how to see the data in those files?
Define candidate key, alternate key, composite key.
13 Answers Infosys, Software India,
Explain about sql server login?
What is the use of =,==,=== operators?
How to enter comments in transact-sql statements?
What is log cache in sql server?
What are the limitation of the Online Index Rebuild Operation?
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.
Differentiate between SQL and ORACLE joins and write their syntax.
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)