InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 19:26:50 GMT20http://www.sqlservercentral.com/Forums/Topic497713-8-1.aspxYou lost me on that last post. I understand what yaml is and I can see if being beneficial. I am lost on how you are using it though. Is this for outputting the data into yaml? Currently I have two ways I output one is sharepoint compatible (excel) and the other I use codesmith to put it in html docs so i have define the whole DB if needed. Would Yaml some how replace those?Thu, 03 Dec 2009 12:35:21 GMTJKSQLhttp://www.sqlservercentral.com/Forums/Topic497713-8-1.aspx[p]Yes. I put everything in MS_Description because this is the only thing that is accessible to SSMS. I then put a YAML structure into the string so I can do lists and sections.[/p][p]The section between the /** **/ is placed into, or updated to, the extended property by an automated process. [/p][font="Courier New"][size="2"][color="black"][/color][color="blue"]IF [/color][color="magenta"]OBJECT_ID[/color][color="gray"]([/color][color="red"]N'IsSpace'[/color][color="gray"]) [/color][color="blue"]IS [/color][color="gray"]NOT NULL   [/color][color="blue"]DROP FUNCTION [/color][color="black"]IsSpaceGO[/color][color="blue"]CREATE FUNCTION [/color][color="black"]dbo.[IsSpace] [/color][color="gray"]([/color][color="#434343"]@string [/color][color="blue"]VARCHAR[/color][color="gray"]([/color][color="magenta"]MAX[/color][color="gray"]))  [/color][color="green"]/** summary:   >                      IsSpace string Function Returns Non-Zero if all characters                       in s are whitespace characters, 0 otherwise.example:     - code:    Select dbo.IsSpace('how many times must i tell you')     - code:    Select dbo.IsSpace(' <>[]{}"!@#$%9  )))))))')     - code:    Select dbo.IsSpace(' ????/>.<,')*/returns:     integer:  1  IF whitespace, otherwise 0**/[/color][color="blue"]RETURNS INTAS BEGIN      RETURN [/color][color="magenta"]CASE [/color][color="blue"]WHEN [/color][color="magenta"]PATINDEX[/color][color="gray"](              [/color][color="red"]'%[A-Za-z0-9-]%'[/color][color="gray"], [/color][color="#434343"]@string  [/color][color="black"]COLLATE Latin1_General_CS_AI                                [/color][color="gray"]) > [/color][color="black"]0 [/color][color="blue"]THEN [/color][color="black"]0                  [/color][color="blue"]ELSE [/color][color="black"]1             [/color][color="blue"]END   END[/color][color="black"]GO[/color][/size][/font]Thu, 03 Dec 2009 11:38:25 GMTPhil Factorhttp://www.sqlservercentral.com/Forums/Topic497713-8-1.aspxThat was great helped me out so I can export properties and I added column definitions. Currently I am putting my descriptions in just saying MS_Description. Should I be using something more appropriate. Do you break apart your descriptions into more logical formats? If so can you give me an example so I do not stumble on this in a year?Thu, 03 Dec 2009 11:07:31 GMTJKSQLhttp://www.sqlservercentral.com/Forums/Topic497713-8-1.aspx[font="Courier New"][size="2"][color="blue"]SELECT  [/color][color="black"]SCHEMA_NAME[/color][color="gray"]([/color][color="black"]tbl.schema_id[/color][color="gray"]) [/color][color="blue"]AS [/color][color="black"][Table_Schema][/color][color="gray"],        [/color][color="black"]tbl.name [/color][color="blue"]AS [/color][color="black"][Table_Name][/color][color="gray"],        [/color][color="black"]clmns.name [/color][color="blue"]AS [/color][color="black"][Column_Name][/color][color="gray"],        [/color][color="black"]p.name [/color][color="blue"]AS [/color][color="black"][Name][/color][color="gray"],        [/color][color="magenta"]CAST[/color][color="gray"]([/color][color="black"]p.value [/color][color="blue"]AS SQL_VARIANT[/color][color="gray"]) [/color][color="blue"]AS [/color][color="black"][Value][/color][color="blue"]FROM    [/color][color="black"]sys.tables [/color][color="blue"]AS [/color][color="black"]tbl        [/color][color="blue"]INNER JOIN [/color][color="black"]sys.all_columns [/color][color="blue"]AS [/color][color="black"]clmns [/color][color="blue"]ON [/color][color="black"]clmns.[/color][color="magenta"]OBJECT_ID[/color][color="blue"]=[/color][color="black"]tbl.[/color][color="magenta"]OBJECT_ID        [/color][color="blue"]INNER JOIN [/color][color="black"]sys.extended_properties [/color][color="blue"]AS [/color][color="black"]p [/color][color="blue"]ON [/color][color="black"]p.major_id[/color][color="blue"]=[/color][color="black"]clmns.[/color][color="magenta"]OBJECT_ID                                                   [/color][color="gray"]AND [/color][color="black"]p.minor_id[/color][color="blue"]=[/color][color="black"]clmns.column_id                                                   [/color][color="gray"]AND [/color][color="black"]p.class[/color][color="blue"]=[/color][color="black"]1[/color][color="blue"]ORDER BY [/color][color="black"][Table_Schema] [/color][color="blue"]ASC[/color][color="gray"],        [/color][color="black"][Table_Name] [/color][color="blue"]ASC[/color][color="gray"],        [/color][color="black"][Column_ID] [/color][color="blue"]ASC[/color][color="gray"],        [/color][color="black"][Name] [/color][color="blue"]ASC[/color][/size][/font]Tue, 24 Nov 2009 06:40:26 GMTPhil Factorhttp://www.sqlservercentral.com/Forums/Topic497713-8-1.aspxHi everybody, mistersI create extended properties asociated to columns of tables:EXEC sp_addextendedproperty @name = N'TablaMaestra', @value = 'Descripcion',@level0type = N'Schema', @level0name = dbo,@level1type = N'Table', @level1name = tabla1,@level2type = N'Column', @level2name = Descripcion;GOI get the value of extended property of columns of the "tabla1" table:select objtype,objname,[name],[value]from fn_listextendedproperty (null,'Schema','dbo','TABLE','tabla1','COLUMN',null)How can I get extended properties of all columns of all tables ?Greetings, regards, thanks in advanceFri, 09 May 2008 04:21:59 GMTenrique.prados