-----------------------创建和使用函数----------------------------------- if exists (select * from dbo.sysobjects where id = object_id(N‘[dbo].[F_TEST2]‘) and xtype in (N‘FN‘, N‘IF‘, N‘TF‘)) drop function [dbo].[F_TEST2] GO CREATE FUNCTION F_TEST2(@NUM INT) RETURNS INT AS BEGIN RETURN @NUM+2 END --调用自定义函数 SELECT DBO.F_TEST2(4)--不加dbo报错 SELECT DBO.F_TEST2(4) AS NUM,* FROM SHANGPIN ----------------------------创建和使用存储过程----------------------------------------- if exists (select 1 from dbo.sysobjects where id = object_id(N‘[dbo].[P_TEST]‘) and OBJECTPROPERTY(id, N‘IsProcedure‘) = 1) drop procedure [dbo].[P_TEST] GO CREATE PROC P_TEST @NUM INT AS BEGIN SELECT @NUM END EXEC P_TEST 4
------------------日期转换为星期--------------------- SET DATEFIRST 1--星期的第一天为周一 select DATEPART(W,GETDATE())AS 星期
---------------------------两日期相隔所少天-------------------------------------- --SELECT DATEDIFF(DAY,开始日期,结束日期) select datediff(day, BYZD14,BYZD15) from shangpin
SQLServer中的存储过程和函数的创建使用以及一些常用的日期函数
原文:http://blog.csdn.net/jcy472578/article/details/19758681