|
Posted by R.A.M. on 07/12/06 07:00
I have one more question - concernign functions.
I've written function:
[SqlFunction(Name="GetCurrentDateText")]
public static SqlString GetCurrentDateText()
{
DateTime dt = new DateTime();
return dt.ToString();
}
And I have tried to create a function:
CREATE FUNCTION GetCurrentDateText RETURNS nvarchar(MAX) AS EXTERNAL
NAME DemoSQLServer.DemoGetCurrentDateText
(according to Books Online) But I recive an error:
Incorrect syntax near 'RETURNS'.
I cannot guess what is wrong. Could you help me please?
Thank you!
/RAM/
Navigation:
[Reply to this message]
|