Posts

GRANT SQL To SCHEMA

 -- Cấp quyền CONNECT cho user mới (GRANT) GRANT CONNECT TO test; -- Cấm quyền ALTER cho schema dbo đối với user mới (DENY) DENY ALTER ON SCHEMA::dbo TO test; -- Cấm quyền CREATE SEQUENCE cho schema dbo đối với user mới (DENY) DENY CREATE SEQUENCE ON SCHEMA::dbo TO test; -- Cấm quyền DELETE cho schema dbo đối với user mới (DENY) DENY DELETE ON SCHEMA::dbo TO test; -- Cấm quyền EXECUTE cho schema dbo đối với user mới (DENY) DENY EXECUTE ON SCHEMA::dbo TO test; -- Cấm quyền INSERT cho schema dbo đối với user mới (DENY) DENY INSERT ON SCHEMA::dbo TO test; -- Cấm quyền REFERENCES cho schema dbo đối với user mới (DENY) DENY REFERENCES ON SCHEMA::dbo TO test; -- Cấm quyền TAKE OWNERSHIP cho schema dbo đối với user mới (DENY) DENY TAKE OWNERSHIP ON SCHEMA::dbo TO test; -- Cấm quyền UPDATE cho schema dbo đối với user mới (DENY) DENY UPDATE ON SCHEMA::dbo TO test; -- Cấm quyền VIEW DEFINITION cho schema dbo đối với user mới (DENY) DENY VIEW DEFINITION ON SCHEMA::dbo TO test; -- Cấm quyền VI...
Post a Comment
Read more

Bulk Insert Update in C# using Stored Procedure

Image
 Nguồn:  Bulk Insert Update in C# using Stored Procedure - Dot Net Tutorials Bulk Insert Update in C# using Stored Procedure Back to:  ADO.NET Tutorial For Beginners and Professionals Bulk INSERT and UPDATE in C# and ADO.NET using Stored Procedure In this article, I am going to discuss  How to Perform BULK INSERT and UPDATE in C#  and ADO.NET using SQL Server Stored Procedure with Examples. Please read our previous article where we discussed  ADO.NET Architecture . Here, in this article, I will explain to you how to perform the Bulk Insert and Update using the Stored Procedure with Examples, and in the next article, I am going to discuss how to Perform Batch Operations Using SqlBulkCopy and DataAdapters. Advertisements × Bulk Insert and Update using Stored Procedure and C# ADO.NET: Let us understand how to perform Bulk Insert and Update using C# and ADO.NET. So, basically what we will do is, we will check if the record does not exist in the database, then w...
Post a Comment
Read more