How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
No Answer is Posted For this Question
Be the First to Post Answer
What is thr feature of change data capture?
How to filter records of table in SQL SERVER?
0 Answers Petranics Solutions,
Explain the architecture of SQL Server?
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 are cursors in ms sql server?
Can we write a distributed query and get some data which is located on other server and oracle database?
What is query optimization process?
How each E-R model constructs can be mapped to the relational model?
How real and float literal values are rounded?
Explain the difference between clustered and non-clustered index?
How to insert multiple rows with a subquery?
What is implicit mode 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)