摘要： 一.查询CREATE????? PROC sp_GetBBSPost?@board_id int/*=====================================================功能:?得到该版块的所有帖子参数:?@board_id int??:?该版块ID=====================================================*/ASselect *,COALESCE(last_replay_time,send_time)?from bbs_post?where? (sysbulletin = 1)union allSELECT 阅读全文

摘要： 一.插入时SET QUOTED_IDENTIFIER OFF GOSET ANSI_NULLS ON GOALTER? TRIGGER [insertReply] ON [dbo].[BBS_Reply] FOR INSERTASdeclare @post_id? intselect @post_id = post_id from inserted--update BBS_Post set replay_times=replay_times+1 where post_id = @post_idGOSET QUOTED_IDENTIFIER OFF GOSET ANSI_NULLS ON GO? 阅读全文