sqlserver_sql_example
yql1986
这个作者很懒,什么都没留下…
展开
-
drop procedure code example
IF OBJECT_ID('[checkemailandsecques]','P') IS NOT NULLDROP PROC [checkemailandsecques]GO转载 2012-08-06 09:53:49 · 410 阅读 · 0 评论 -
SCOPE_IDENTITY
CREATE PROCEDURE [prefix_createattachment]@uid int,@tid int,@pid int,@postdatetime datetime,@readperm int,@filename nchar(200),@description nchar(200),@filetype nchar(100),@filesize转载 2012-08-06 10:09:08 · 437 阅读 · 0 评论 -
create procedure example
CREATE PROCEDURE [checkemailandsecques]@username nchar(20),@email char(50),@secques char(8)ASSELECT TOP 1 [uid] FROM [users] WHERE [username]=@username AND [email]=@email AND [secques]=@secq转载 2012-08-06 09:59:22 · 506 阅读 · 0 评论