dacbuilder_demo.zip
DACBuilder_demo
DACBuilder.exe
DACCreator.dll
DataAccess.dll
DataGridCustomColumns.dll
DotNetScripting.dll
FieldTypes.dll
Templates
connection_strings
Access.xsl
AS400(iSeries).xsl
DBF - FoxPro.xsl
DSN.xsl
Excel.xsl
Exchange.xsl
Firebird.xsl
IBM DB2.xsl
Informix.xsl
Ingres.xsl
Interbase.xsl
Lightbase.xsl
Mimer SQL.xsl
MySQL.xsl
Oracle.xsl
Paradox.xsl
Pervasive.xsl
PostgreSQL.xsl
SQL Server 2005.xsl
SQL Server.xsl
Sybase.xsl
Text.xsl
UDL.xsl
Visual FoxPro.xsl
CustomFields
CustomFields_all.xsl
CustomFields_CSharp_util.xsl
CustomFields_sp.xsl
CustomFields_tbl.xsl
CustomFields_VisualBasic_util.xsl
CustomFieldsProperty_sp.xsl
CustomFieldsProperty_tbl.xsl
CustomFieldsPropertyList_sp.xsl
CustomFieldsPropertyList_tbl.xsl
CustomFieldsSecurity_sp.xsl
CustomFieldsSecurity_tbl.xsl
CustomFieldsTable_SELECT_ByName_sp.xsl
CustomFieldsTable_sp.xsl
CustomFieldsTable_tbl.xsl
CustomFieldsTableColumn_SELECT_ByFKTable_sp.xsl
CustomFieldsTableColumn_sp.xsl
CustomFieldsTableColumn_tbl.xsl
CustomFieldsType_insert.xsl
CustomFieldsType_sp.xsl
CustomFieldsType_tbl.xsl
CustomFieldsValueList_sp.xsl
CustomFieldsValueList_tbl.xsl
CustomFieldsValues_DELETE_sp.xsl
CustomFieldsValues_SELECT_sp.xsl
CustomFieldsValuesBool_CSharp.xsl
CustomFieldsValuesBool_sp.xsl
CustomFieldsValuesBool_tbl.xsl
CustomFieldsValuesBool_VisualBasic.xsl
CustomFieldsValuesDateTime_CSharp.xsl
CustomFieldsValuesDateTime_sp.xsl
CustomFieldsValuesDateTime_tbl.xsl
CustomFieldsValuesDateTime_VisualBasic.xsl
CustomFieldsValuesDecimal_CSharp.xsl
CustomFieldsValuesDecimal_sp.xsl
CustomFieldsValuesDecimal_tbl.xsl
CustomFieldsValuesDecimal_VisualBasic.xsl
CustomFieldsValuesInteger_CSharp.xsl
CustomFieldsValuesInteger_sp.xsl
CustomFieldsValuesInteger_tbl.xsl
CustomFieldsValuesInteger_VisualBasic.xsl
CustomFieldsValuesString_CSharp.xsl
CustomFieldsValuesString_sp.xsl
CustomFieldsValuesString_tbl.xsl
CustomFieldsValuesString_VisualBasic.xsl
DACCustomFields_CSharp.xsl
DACCustomFields_VisualBasic.xsl
GetPrimaryKeyColumnName_sp.xsl
GetPropertyListValues_fn.xsl
GetTableCustomFieldsXML_sp.xsl
select_custom_fields_type.xsl
vwCustomFields.xsl
DACExample_CSharp.xsl
DACExample_VisualBasic.xsl
DataAccess_PHP.xsl
DataAccessComponent_CSharp_Odbc.xsl
DataAccessComponent_CSharp_OleDb.xsl
DataAccessComponent_CSharp_SQL.xsl
DataAccessComponent_VisualBasic_Odbc.xsl
DataAccessComponent_VisualBasic_OleDb.xsl
DataAccessComponent_VisualBasic_SQL.xsl
DataAccessContainer_CSharp_Odbc.xsl
DataAccessContainer_CSharp_OleDb.xsl
DataAccessContainer_CSharp_SQL.xsl
DataAccessContainer_VisualBasic_Odbc.xsl
DataAccessContainer_VisualBasic_OleDb.xsl
DataAccessContainer_VisualBasic_SQL.xsl
dataset_schema.xsl
dataset_template.xsx
execRoutine_CSharp_SQL.xsl
execRoutine_VisualBasic_SQL.xsl
fnGetExtendedProperty_fn.xsl
GET_NEXT_ID_sp.xsl
GetRoutineParametersXML_sp.xsl
GetTableColumnsXML_sp.xsl
html.xsl
KeyTables_tbl.xsl
Libraries
CustomFields.dll
DACCreator.dll
DataGridCustomColumns.dll
DotNetScripting.dll
Odbc
DataAccessComponent.dll
DataAccessContainer.dll
OleDb
DataAccessComponent.dll
DataAccessContainer.dll
RJS.Web.WebControl.PopCalendar.dll
SQL
DataAccessComponent.dll
DataAccessContainer.dll
msaccess_2_sql.xsl
mysql_2_sql.xsl
select_type.xsl
simpleDAC_CSharp_Odbc.xsl
simpleDAC_CSharp_OleDb.xsl
simpleDAC_CSharp_SQL.xsl
simpleDAC_JScript_SQL.xsl
simpleDAC_PHP.xsl
simpleDAC_VB60_SQL.xsl
simpleDAC_VBScript_SQL.xsl
simpleDAC_VisualBasic_Odbc.xsl
simpleDAC_VisualBasic_OleDb.xsl
simpleDAC_VisualBasic_SQL.xsl
simpleDAC_WebUI_CSharp.xsl
simpleDAC_WebUI_VisualBasic.xsl
simpleDAC_WinUI_CSharp.xsl
simpleDAC_WinUI_VisualBasic.xsl
sp_ora.xsl
sp_sql.xsl
sp_sql_create_table.xsl
sp_sql_historic.xsl
sp_sql_insert_rows.xsl
sp_sql_search.xsl
sp_sql_select_by_pk.xsl
split.xsl
WebForm.xsl
WebUserControl.xsl
WindowsForm_resx.xsl
Xdo.ConnectionStringProject.dll
dacbuilder_src.zip
DACBuilder_src
App.ico
arrow_down.bmp
CustomFields
DACBuilder.csproj.user
Templates
connection_strings
Access.xsl
AS400(iSeries).xsl
DBF - FoxPro.xsl
DSN.xsl
Excel.xsl
Exchange.xsl
Firebird.xsl
IBM DB2.xsl
Informix.xsl
Ingres.xsl
Interbase.xsl
Lightbase.xsl
Mimer SQL.xsl
MySQL.xsl
Oracle.xsl
Paradox.xsl
Pervasive.xsl
PostgreSQL.xsl
SQL Server 2005.xsl
SQL Server.xsl
Sybase.xsl
Text.xsl
UDL.xsl
Visual FoxPro.xsl
CustomFields
CustomFields_all.xsl
CustomFields_CSharp_util.xsl
CustomFields_sp.xsl
CustomFields_tbl.xsl
CustomFields_VisualBasic_util.xsl
CustomFieldsProperty_sp.xsl
CustomFieldsProperty_tbl.xsl
CustomFieldsPropertyList_sp.xsl
CustomFieldsPropertyList_tbl.xsl
CustomFieldsSecurity_sp.xsl
CustomFieldsSecurity_tbl.xsl
CustomFieldsTable_SELECT_ByName_sp.xsl
CustomFieldsTable_sp.xsl
CustomFieldsTable_tbl.xsl
CustomFieldsTableColumn_SELECT_ByFKTable_sp.xsl
CustomFieldsTableColumn_sp.xsl
CustomFieldsTableColumn_tbl.xsl
CustomFieldsType_insert.xsl
CustomFieldsType_sp.xsl
CustomFieldsType_tbl.xsl
CustomFieldsValueList_sp.xsl
CustomFieldsValueList_tbl.xsl
CustomFieldsValues_DELETE_sp.xsl
CustomFieldsValues_SELECT_sp.xsl
CustomFieldsValuesBool_CSharp.xsl
CustomFieldsValuesBool_sp.xsl
CustomFieldsValuesBool_tbl.xsl
CustomFieldsValuesBool_VisualBasic.xsl
CustomFieldsValuesDateTime_CSharp.xsl
CustomFieldsValuesDateTime_sp.xsl
CustomFieldsValuesDateTime_tbl.xsl
CustomFieldsValuesDateTime_VisualBasic.xsl
CustomFieldsValuesDecimal_CSharp.xsl
CustomFieldsValuesDecimal_sp.xsl
CustomFieldsValuesDecimal_tbl.xsl
CustomFieldsValuesDecimal_VisualBasic.xsl
CustomFieldsValuesInteger_CSharp.xsl
CustomFieldsValuesInteger_sp.xsl
CustomFieldsValuesInteger_tbl.xsl
CustomFieldsValuesInteger_VisualBasic.xsl
CustomFieldsValuesString_CSharp.xsl
CustomFieldsValuesString_sp.xsl
CustomFieldsValuesString_tbl.xsl
CustomFieldsValuesString_VisualBasic.xsl
DACCustomFields_CSharp.xsl
DACCustomFields_VisualBasic.xsl
GetPrimaryKeyColumnName_sp.xsl
GetPropertyListValues_fn.xsl
GetTableCustomFieldsXML_sp.xsl
select_custom_fields_type.xsl
vwCustomFields.xsl
DACExample_CSharp.xsl
DACExample_VisualBasic.xsl
DataAccess_PHP.xsl
DataAccessComponent_CSharp_Odbc.xsl
DataAccessComponent_CSharp_OleDb.xsl
DataAccessComponent_CSharp_SQL.xsl
DataAccessComponent_VisualBasic_Odbc.xsl
DataAccessComponent_VisualBasic_OleDb.xsl
DataAccessComponent_VisualBasic_SQL.xsl
DataAccessContainer_CSharp_Odbc.xsl
DataAccessContainer_CSharp_OleDb.xsl
DataAccessContainer_CSharp_SQL.xsl
DataAccessContainer_VisualBasic_Odbc.xsl
DataAccessContainer_VisualBasic_OleDb.xsl
DataAccessContainer_VisualBasic_SQL.xsl
dataset_schema.xsl
dataset_template.xsx
execRoutine_CSharp_SQL.xsl
execRoutine_VisualBasic_SQL.xsl
fnGetExtendedProperty_fn.xsl
GET_NEXT_ID_sp.xsl
GetRoutineParametersXML_sp.xsl
GetTableColumnsXML_sp.xsl
html.xsl
KeyTables_tbl.xsl
Libraries
CustomFields.dll
DACCreator.dll
DataGridCustomColumns.dll
DotNetScripting.dll
Odbc
DataAccessComponent.dll
DataAccessContainer.dll
OleDb
DataAccessComponent.dll
DataAccessContainer.dll
RJS.Web.WebControl.PopCalendar.dll
SQL
DataAccessComponent.dll
DataAccessContainer.dll
msaccess_2_sql.xsl
mysql_2_sql.xsl
select_type.xsl
simpleDAC_CSharp_Odbc.xsl
simpleDAC_CSharp_OleDb.xsl
simpleDAC_CSharp_SQL.xsl
simpleDAC_JScript_SQL.xsl
simpleDAC_PHP.xsl
simpleDAC_VB60_SQL.xsl
simpleDAC_VBScript_SQL.xsl
simpleDAC_VisualBasic_Odbc.xsl
simpleDAC_VisualBasic_OleDb.xsl
simpleDAC_VisualBasic_SQL.xsl
simpleDAC_WebUI_CSharp.xsl
simpleDAC_WebUI_VisualBasic.xsl
simpleDAC_WinUI_CSharp.xsl
simpleDAC_WinUI_VisualBasic.xsl
sp_ora.xsl
sp_sql.xsl
sp_sql_create_table.xsl
sp_sql_historic.xsl
sp_sql_insert_rows.xsl
sp_sql_search.xsl
sp_sql_select_by_pk.xsl
split.xsl
WebForm.xsl
WebUserControl.xsl
WindowsForm_resx.xsl
|
IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_NAME = 'fnGetExtendedProperty')
BEGIN
DROP FUNCTION fnGetExtendedProperty
END
GO
/*
name: fnGetExtendedProperty
type: scalar function
returns sql_variant
parameters:
@property_name sysname, -- extended property name (usually, N'MS_Description')
@table_name varchar(128), -- table name for specified column to retrieve extended property
@column_name varchar(128) -- column name to retrieve extended property
scope: uses global function ::fn_listextendedproperty to retrieve a
value from an extended property added to a column in a table
*/
CREATE FUNCTION fnGetExtendedProperty(
@property_name sysname, -- extended property name (usually, N'MS_Description')
@table_name varchar(128), -- table name for specified column to retrieve extended property
@column_name varchar(128) -- column name to retrieve extended property
)
RETURNS SQL_VARIANT
AS
BEGIN
DECLARE @value SQL_VARIANT
SELECT @value = VALUE FROM ::fn_listextendedproperty(
@property_name, 'USER', 'dbo', 'table', @table_name, 'COLUMN', @column_name
)
RETURN @value
END
GO
|
By viewing downloads associated with this article you agree to the Terms of use and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
I live and work in Bucharest, Romania. I am programmer since 1998, when I have developed a "good taste" application for a catering company. Now I develop .NET applications (windows and ASP.NET) for large SQL Server database systems, with tens of millions of records.
I like to develop also in other languages like Object Pascal (Delphi), PHP, C++, VB, scripting. I enjoy the XML power, both on client side and server side.
Submit an article or tip
Post your Blog
