How to drop an existing schema in ms sql server?
No Answer is Posted For this Question
Be the First to Post Answer
What are the recovery models in sql server 2000?
Can we store videos inside the sql server table?
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 the use of database index(apart from the last searching of records) and what is the use of composite key?
How to test odbc dsn connection settings?
Ek lifafa 10 noto se bhara hai usme 2 or 5 ke note nahi hai aur usme total 50Rs hai, to batao lifafe me kon se not kitne hia it’s a challenge thank’s
Explain about sql server login?
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
What is an Index?
Why we need to use secondry database file? though, we can do same work using primary database file also.
Is t sql the same as sql server?
Explain what is the difference between union and union all?
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)