Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Null on Null Input | False |
| Schema Bound | False |
| Assembly | iSQLFile |
Parameters
| Name | Data Type | Length | Description |
|---|---|---|---|
| @Folder | nvarchar | -1 | |
| @filter | nvarchar | 255 |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE FUNCTION dbo.axFilelists (@Folder nvarchar(max),
@filter nvarchar(255))
RETURNS TABLE (
filename nvarchar(max) NULL,
size decimal(18, 4) NULL,
datecreate datetime NULL
)
AS
EXTERNAL NAME iSQLFile.[iSQLFile.iFileTools].axFilelists
GO
GO
CREATE FUNCTION dbo.axFilelists (@Folder nvarchar(max),
@filter nvarchar(255))
RETURNS TABLE (
filename nvarchar(max) NULL,
size decimal(18, 4) NULL,
datecreate datetime NULL
)
AS
EXTERNAL NAME iSQLFile.[iSQLFile.iFileTools].axFilelists
GO