blogjava's web log

/**/ /* ?是否已經存在? */
create ? proc ?UP_users_IsHas
@u_id ? int
as
?????? declare ? @TempID ? int
?????? select ? @TempID = count ( 1 )? from ?users? where ?u_id = @u_id
????????? if ( @TempID = 0 )
?????????????? return ? 0
?????????? else
??????????????? return ? 1
go
/**/ /* ?增加一條記錄? */
create ? proc ?UP_users_Add
@u_id ? int , @nS_id ? int , @u_name ? varchar , @u_pwd ? varchar , @u_Q ? varchar , @u_A ? varchar , @u_email ? varchar , @u_address ? varchar , @u_tel ? varchar , @u_regtime ? datetime , @u_title ? varchar , @u_sum ? int , @u_wjieshao ? varchar , @u_typeid ? int , @u_grde ? int , @u_sortNum ? int , @u_liouyanNum ? int , @u_pinglunNum ? int , @u_newNum ? int
as
insert ? into ??users(
nS_id,u_name,u_pwd,u_Q,u_A,u_email,u_address,u_tel,u_regtime,u_title,u_sum,u_wjieshao,u_typeid,u_grde,u_sortNum,u_liouyanNum,u_pinglunNum,u_newNum) values ( @nS_id , @u_name , @u_pwd , @u_Q , @u_A , @u_email , @u_address , @u_tel , @u_regtime , @u_title , @u_sum , @u_wjieshao , @u_typeid , @u_grde , @u_sortNum , @u_liouyanNum , @u_pinglunNum , @u_newNum )
go
/**/ /* ?修改一條記錄? */
create ? proc ?UP_users_update
@u_id ? int , @nS_id ? int , @u_name ? varchar , @u_pwd ? varchar , @u_Q ? varchar , @u_A ? varchar , @u_email ? varchar , @u_address ? varchar , @u_tel ? varchar , @u_regtime ? datetime , @u_title ? varchar , @u_sum ? int , @u_wjieshao ? varchar , @u_typeid ? int , @u_grde ? int , @u_sortNum ? int , @u_liouyanNum ? int , @u_pinglunNum ? int , @u_newNum ? int
as
update ?users?? set
nS_id = @nS_id ,u_name = @u_name ,u_pwd = @u_pwd ,u_Q = @u_Q ,u_A = @u_A ,u_email = @u_email ,u_address = @u_address ,u_tel = @u_tel ,u_regtime = @u_regtime ,u_title = @u_title ,u_sum = @u_sum ,u_wjieshao = @u_wjieshao ,u_typeid = @u_typeid ,u_grde = @u_grde ,u_sortNum = @u_sortNum ,u_liouyanNum = @u_liouyanNum ,u_pinglunNum = @u_pinglunNum ,u_newNum = @u_newNumwhere ?u_id = @u_id
go
/**/ /* ?刪除一條記錄? */
create ? proc ?UP_users_delete
@u_id ? int
as
delete ?users?? where ?u_id = @u_id
go
/**/ /* ?查詢一條信息? */
create ? proc ?UP_users_select
@u_id ? int
as
select ? * ? from ?users?? where ?u_id = @u_id
go
/**/ /* 查詢所有 */
create ? proc ?UP_users_selectAll
@u_id ? int
as
select ? * ? from ?users
go