摘要：Create PROCEDURE UpdateWanjun@UserName nvarchar(500),@UserPassword nvarchar(500),@ReturnVal int outputAS --Set XAcT_ABORT ON Begin Transaction T Update admins set UserPassword = @UserPassword where UserName = @UserName Update admins set UserPassword = @UserPassword,a='aaadfasdfasdfas' where 阅读全文

摘要：ALTER PROCEDURE [dbo].[sp_get_room_fans_list] @room_id bigint, @start bigint, @end bigintASBEGIN SET NOCOUNT ON; ......ETNOCOUNT使返回的结果中不包含有关受Transact-SQL语句影响的行数的信息。语法SETNOCOUNT{ON|OFF}注释当SETNOCOUNT为ON时，不返回计数（表示受Transact-SQL语句影响的行数）。当SETNOCOUNT为OFF时，返回计数。即使当SETNOCOUNT为ON时，也更新@@ROWCOUNT函数。当SETNOCOU... 阅读全文