ansi sql standard

( GETDATE ()) not null,--creation time Laster varchar () not null,--Last modified by person Lastdate DateTime Default (getdate ()) not null --Last modified time) Add a table field if not exists ( select * from syscolumns where id = object_id(‘WYEstate‘) and name = ‘MSQuestion‘ ) alter table WYEstate add MSQuestion NVARCHAR(500) null--问题 Delete a table field if exists ( select * from syscolumns where id = object_id(‘WYEstate‘) and name =

Label:CREATE ProcedureEsp_changestart--Esp_changestart @ID int, @RetVal Int = 0Output as Declare @Badge varchar(Ten), @ID_Max int Begin Select @Badge =Badge fromEchange_registerWhere [ID] = @ID --whether the registration record confirms IF not Exists(Select 1 fromEchange_registerWhereId= @ID and IsNull(Initialized,0)= 1) Begin Set @RetVal = 911005 Return @RetVal End Begin Transaction UpdateaSe