Hallo,
wie kann ich folgende FUNCTION im Query Analyzer testen?
CREATE FUNCTION getAge
-- Input Birthday
(@dtmbirth smalldatetime)
RETURNS decimal(2,0) --Year
AS
BEGIN
RETURN (ISNULL(RIGHT(('03.04.2003'- @dtmbirth), 2), ''))
END
SELECT getage('12/26/1999') AS 'age'
bringt immer einen SYNTAX-Fehler
Gruss
Alex
www.aspintranet.de
~~~~~~~~~~~~~~~~~~~~~~~~~~~sponsored by United Planet~~~~~~~~~~~~~~~~~
Intrexx.BizWalker + ODBC/OLEDB-Daten = ASP-Formular
ATTACK! Download Intrexx CRM-Studio Now! http://www.intrexx.com
_______________________________________________
Database.asp mailing list
[EMAIL PROTECTED]
http://www.glengamoi.com/mailman/listinfo/database.asp
