调视图 ALTER view v_getdate As Select Getdate() as Today
CREATE VIEW CurrentDate AS SELECT Date = GETDATE() GO CREATE FUNCTION myFunction () RETURNS DATETIME AS BEGIN DECLARE @myDateTime DATETIME SELECT @myDateTime = Date FROM CurrentDate RETURN (@myDateTime) END GO SELECT dbo.myFunction() GO
ALTER view v_getdate
As
Select Getdate() as Today
GO
CREATE FUNCTION myFunction () RETURNS DATETIME AS
BEGIN
DECLARE @myDateTime DATETIME
SELECT @myDateTime = Date FROM CurrentDate
RETURN (@myDateTime)
END
GO
SELECT dbo.myFunction()
GO