Hvordan scripter man en UDF ?
Jeg bruger det følgende script til at scripte tabeller med. Jeg generer noget Delphi kode ud af det.select
SysObjects.name AS FunctionName,
SysObjects.ID,
SysColumns.name AS ColumnName,
SysColumns.colid AS FieldID,
SysTypes.name AS ColumnType,
SysColumns.length,
SysTypes.length AS StandardLength,
SysObjects.crdate,
SysObjects.refdate,
SysColumns.isnullable AS AllowNulls,
SysObjects.XType AS ObjectType
FROM
SysColumns (NOLOCK)
INNER JOIN
SysTypes (NOLOCK) ON SysColumns.xtype = SysTypes.xtype
INNER JOIN
SysObjects (NOLOCK) ON SysColumns.id = SysObjects.id
where
SysObjects.parent_obj = 0
and
SysObjects.Name = 'GenerateSalid'
order by
SysObjects.Name, SysColumns.Name
Det fungerer også til at scripte UDF'er med. Men hvordan finder jeg ud af hvad der er min parametre liste, og hvad der er felter i en retur tabel ?
Jens B