Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2006
    Posts
    83

    Lightbulb Unanswered: Creating object type

    How to create object type in sql server,
    i.e in Oracle we can directly create an object TYPE and we can use it in other applications.
    What's the equivalent of this object Type in SQL Server

  2. #2
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    do you mean a user defined type?

  3. #3
    Join Date
    Oct 2006
    Posts
    83
    Yes, a user defined type

  4. #4
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    have a look at udts in BOL:

    for CLR based types (2005 only): http://msdn2.microsoft.com/en-us/library/ms131106.aspx

    for SQL based types:
    http://msdn.microsoft.com/library/de..._addp_584l.asp (2000 syntax, deprecated in 2005 - there you should use CREATE TYPE instead)

  5. #5
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    I was going to bring up CLR triggers here but I am not sure I want all of that application code running under my sql service. The book I am writing makes a fair case for some things .Net does faster than sql like string manipulation, running totals and such but I am not sure I am sold yet.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •