locked
about collections usage in sql server RRS feed

  • Question

  • Hi All

    This is  bala .can you please tell me what is usage of collection in sql server , how to use and where to use.

    thanks 

    bala

    Monday, October 10, 2011 6:46 PM

Answers

  • Collection or collation? The latter is well documented in BOL or you can review the online version: http://msdn.microsoft.com/en-us/library/ms144260.aspx

    If it is collection then you've got data collection and schema collection in SQL Server as mentioned by others. There is also the notion of collections which is really just a bunch of elements of the same type. Common examples are array and list. We don't provide such types out of the box but many users create them in CLR which is then used like any other data type.

    There are also folks that simulate them using existing types. For example, a 2 column table is commonly used to simulate a 2 dimensional array - 1 column for counter, 1 column for data.

     


    No great genius has ever existed without some touch of madness. - Aristotle
    • Proposed as answer by Peja TaoEditor Wednesday, October 12, 2011 7:37 AM
    • Marked as answer by Peja TaoEditor Monday, October 17, 2011 9:01 AM
    Wednesday, October 12, 2011 6:19 AM
  • Hi Bala,

    In addition, you could refer to these online articles for more information about XML Schema Collection:

    1.Guidelines and Limitations in Using XML Schema Collections on the Server
    2.Viewing a Stored XML Schema Collection
    3.Managing XML Schema Collections on the Server
    4.CREATE XML SCHEMA COLLECTION (Transact-SQL)

    Hope this helps,


    Best Regards,
    Peja

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Wednesday, October 12, 2011 7:53 AM
    Answerer

All replies

  • Bala,

     

    Are you talking about XML Schema Collection?


    Fabrizzio A. Caputo
    Certificações:
    Oracle OCA 11g
    MCITP SQL Server 2008 Implementation and Maintenance
    MCITP SQL Server 2008 Developer
    Blog Pessoal: www.fabrizziocaputo.wordpress.com
    Blog Empresa: www.tripletech.com.br/blog
    Twitter: @FabrizzioCaputo
    Email: fabrizzio.antoniaci@gmail.com
    Monday, October 10, 2011 7:03 PM
  • No I am asking commonly  about collection information in sql server.how to use and where to use.

    Thanks

    bala

    Tuesday, October 11, 2011 10:49 AM
  • I am not aware of something like that expect of XML, can you be more specific, examples?
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Tuesday, October 11, 2011 10:55 AM
  • Hi

    do you mean Data collection under management menu in ssms?


    Regards Ahmad
    Tuesday, October 11, 2011 1:24 PM
  • Collection or collation? The latter is well documented in BOL or you can review the online version: http://msdn.microsoft.com/en-us/library/ms144260.aspx

    If it is collection then you've got data collection and schema collection in SQL Server as mentioned by others. There is also the notion of collections which is really just a bunch of elements of the same type. Common examples are array and list. We don't provide such types out of the box but many users create them in CLR which is then used like any other data type.

    There are also folks that simulate them using existing types. For example, a 2 column table is commonly used to simulate a 2 dimensional array - 1 column for counter, 1 column for data.

     


    No great genius has ever existed without some touch of madness. - Aristotle
    • Proposed as answer by Peja TaoEditor Wednesday, October 12, 2011 7:37 AM
    • Marked as answer by Peja TaoEditor Monday, October 17, 2011 9:01 AM
    Wednesday, October 12, 2011 6:19 AM
  • Hi Bala,

    In addition, you could refer to these online articles for more information about XML Schema Collection:

    1.Guidelines and Limitations in Using XML Schema Collections on the Server
    2.Viewing a Stored XML Schema Collection
    3.Managing XML Schema Collections on the Server
    4.CREATE XML SCHEMA COLLECTION (Transact-SQL)

    Hope this helps,


    Best Regards,
    Peja

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Wednesday, October 12, 2011 7:53 AM
    Answerer