USE [HR]
GO
/****** Object: StoredProcedure [dbo].[Pro_test] Script Date: 2020-10-23 18:59:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[Pro_test]
@Daycode varchar(20)
AS
BEGIN
SET NOCOUNT ON;
update MANEXTRADAY set @Daycode=12 where cod_emp ='31248' and ym = SUBSTRING('2020-10-21 08:00:00', 0, 8);
end
然后執行EXEC [Pro_test] 21；
發現資料沒有變化。之前值為null。現在還是null。有沒有大神可以指導一下；
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/188174.html
標籤：其他數據庫