ajunfly

摘要： --创建存储过程CREATE PROCEDURE procedure_test @ID VARCHAR(100)AS DECLARE @ReturnValue varchar(100)BEGINSET NOCOUNT ON; set @ReturnValue = @ID return @ReturnValueENDGO--------执行下面sql语句，获得上面存储过程的返回值declare @value varchar(100);exec @value = procedure_test '1111111';select @value 阅读全文

摘要： USE [ZJPJTX]GO/****** Object: UserDefinedFunction [dbo].[fun_GradeDiff] Script Date: 05/18/2012 10:57:42 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER FUNCTION [dbo].[fun_GradeDiff] (@sum decimal(10,4)) RETURNS char(1) AS BEGIN declare @returnValue char(1)declare @temp table (startMoney 阅读全文