 Related Questions It's working in MySQL but not in SQL-Server. Latest Answer : Use a procedure which will delete record from child table first and then it will delete the same record from parent tableSame thing can be achieved using cascade delete and cascade update, this feature was not there in sql server 7.0 ... Read Answers (3) | Asked by : kathir Latest Answer : For primary key if that record is being refered by some other (Child Table) sql server won't let you to delete that record.While creating relationship if you had mention "Delete Cascade" option and then if you delete the ... How to deny insert, update, delete, update permissions for a specific user of a specific user database? Latest Answer : So what context is the user in? A role a datareader? Datawriter?You want no permissions?USE Drop USER In a role?EXEC sp_droprolemember 'rolename' , 'Member'single objects?Revoke SELECT, ... How to deny delete and drop permission to the user for the particular database in SQL Server 2005. Latest Answer : USE [PARENTDB] GO DROP SCHEMA [USER] GO USE [DB]GO DROP USER [USER] GOor in GUI SQL SQL server Managment Studio go to your DB open it's security section up. . select users folder .. select user adn press delete on the keyboard .. ... 1. how to insert five rows in a table using single query(in ms-sql or oracle)2.how to delete duplicate values in a table. for example, the table containing five duplicate values(like name rani). Latest Answer : Inset data:insert into targettableselect top 5 * from sourcetabledelete data:1. select distinct * into targettable from sourcetable2. delete from sourcetable3. insert into sourcetable    select * from targettable ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0 
2