Ken

摘要： 语法sp_executesql [ @stmt = ] stmt [ {, [@params=] N'@parameter_name data_type [ [ OUT [ PUT ][,...n]' } {, [ @param1 = ] 'value1' [ ,...n ] } ]用法实例1、获取一个输出结果使用output获取输出结果的值declare @num int, @sqls nvarchar(4000) set @sqls='select @a=count(*) from customer 'exec sp_executesql @ 阅读全文

摘要： ALTER PROCEDURE [dbo].[ken_overtime_check](@p_use_code nvarchar(100),@p_table_name nvarchar(1000)) ASBEGINdeclare @cursor_name cursor;declare @employeeid nvarchar(100);declare @cur_employeeid nvarchar(1000); SET NOCOUNT ON; begin try begin transaction ; SET @sql = 'SELECT @tc_1 = EMPLOYE... 阅读全文