dbregister.sql

来自「asp.net技术内幕的书配源码」· SQL 代码 · 共 21 行

CREATE PROCEDURE DBRegister
(
  @username Varchar( 100 ),
  @password Varchar( 100 )
)
AS

IF EXISTS( SELECT u_id
  FROM UserList
  WHERE u_username=@username )
  RETURN - 1
ELSE
  INSERT UserList (
    u_username,
    u_password
    ) VALUES (
    @username,
    @password
    )
  RETURN @@IDENTITY