Advanced Search

Return to Snippet

Revision: 29899
at August 5, 2010 01:18 by RealRover
Initial Code 
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
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
TRY - RAISERROR - CATCH

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL