Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ODBC SQLState: 42000
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
ODBC SQLState: 42000
Miscellaneous
Thread ID:
00891334
Message ID:
00891334
Views:
46
Using SQL 2000. What can cause this UDF to get the following error? It works in one db but not another when you click "syntax check"!
Create function dbo.Test
(
	@userid		char(3)
)
Returns varchar(40)
as  
Begin 
   return @userid + "<<<<"
end
Microsoft SQL-DMO (ODBC SQLState: 42000)
Error 170: Line 2: Incorrect syntax near 'function'.
Must declare the variable '@userid'.
Reply
Map
View

Click here to load this message in the networking platform