SQL Server stored procedure self-initiated

Pre-Preparation:

Use master;

CREATE table Loginlog (LoginName nvarchar (+), Logintime datetime);

CREATE PROCEDURE Sp_recordloginlog #注意没有参数的情况下不可以有 "()"

As

Begin

Insert into Loginlog (loginname,logintime) VALUES (System_user,getdate ());
End
Go

--------------------------------------------------------------------------------------------------------------- ------------------------------------------

Method 1,

Execute sp_procoption @ProcName = ' Sp_login ', @OptionName = ' startup ', @OptionValue = ' true ';
Go

SQL Server stored procedure self-initiated