Technical Article

Manage Extended Property

     While we are exploring the possibility to build data-driven application whose GUI are all dynamically generated according to database objects' extended property, we find the system provided procedures: sp_addextendedproperty, sp_dropextendedproperty,sp_updateextendedproperty can add extended property to only one object each time, while fn_listextendedproperty can not let you search objects to display their extended property. […]

2003-06-27

479 reads

Blogs

Daily Coping 31 Jan 2023

By

Today’s coping tip is to take a small step towards and important goal. One...

Tales From The Field Weekly Wrap Up for the Week of 01-23-2022

By

 Hello Dear Reader!  It's been a while since I had time to sit down...

CONCAT_WS Function Truncates Text

By

I was writing some dynamic SQL that generates some SQL statements to load my...

Read the latest Blogs

Forums

parameterizing a sql server connection

By winston Smith

I am parameterizing an sql server connection. There are the following fields: username password...

'DATE' is not a recognized built-in function name

By yrstruly

Please assist. I am getting the above error: CREATE VIEW DailyAccountBalances AS SELECT DATE(TransactionDate)...

SSIS Sort Alphanumeric?

By John524

Hello, I'm pretty new to SSIS, but I have an Excel source that I...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers