create function Now() returns datetime as begin declare @a datetime select @a=dd from OPENROWSET( 'SQLOLEDB', 'SERVER=ServerName;uid=sa;pwd=YourPasswd;Database=master','select getdate() as dd ') return @a endselect dbo.now()
全部替换Now()为getdate()!! select @a=dd from OPENROWSET( 'SQLOLEDB', 'SERVER=ServerName;uid=sa;pwd=YourPasswd;Database=master','select getdate() as dd ') 好高深阿,头疼
returns datetime
as
begin
declare @a datetime
select @a=dd from OPENROWSET(
'SQLOLEDB',
'SERVER=ServerName;uid=sa;pwd=YourPasswd;Database=master','select getdate() as dd ')
return @a
endselect dbo.now()
select @a=dd from OPENROWSET(
'SQLOLEDB',
'SERVER=ServerName;uid=sa;pwd=YourPasswd;Database=master','select getdate() as dd ')
好高深阿,头疼