找不到用户定义的函数

Question

DECLARE @lastname VARCHAR(25) 
DECLARE @birthdate VARCHAR(25) 
SELECT @lastname = 'Smith' 

SELECT @birthdate = '19-Apr-36' 

INSERT INTO [TEST_TABLE](lastname, birthdate) 
VALUES (@lastname, (dbo.scrubDateDOBString(@birthdate))) 

无论如何，使前面的查询在ssms08中工作？

，我发现了以下错误：

Msg 4121, Level 16, State 1, Line 5
Cannot find either column "dbo" or the user-defined function or aggregate "dbo.scrubDateDOBString", or the name is ambiguous.

以下工作：

INSERT INTO TEST_TABLE (lastname, birthdate) 
VALUES ('test', (dbo.scrubDateString('2/2/48'))) 

Answer 1

你尝试使用INSERT INTO...SELECT

DECLARE @lastname VARCHAR(25) 
DECLARE @birthdate VARCHAR(25) 
SET @lastname = 'Smith'  
SET @birthdate = '19-Apr-36' 

insert into [TEST_TABLE] (lastname,birthdate) 
SELECT @lastname, dbo.scrubDateDOBString(@birthdate) 

您可能需要投你@birthdate以不同的格式

如果你需要区分它，你可以这样来做：

insert into [TEST_TABLE] (lastname,birthdate) 
SELECT @lastname, dbo.scrubDateDOBString(cast(@birthdate as datetime))