/ Published in: SQL
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
BEGIN TRY /* Code here */ DECLARE @UserGroupId INT INSERT INTO UserGroup (RoleId, ScopeGroupId) VALUES (5555, 7777) SET @UserGroupId = SCOPE_IDENTITY() IF @UserGroupId IS NULL RAISERROR('User group creation failed', 16, 1) END TRY BEGIN CATCH SELECT ERROR_MESSAGE() AS Error END CATCH