Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005
    Posts
    13

    Unanswered: Text data type in Trigger

    Hi,

    I am using following query to get insereted records from a table, which is containing a column, having text datatype.

    'SELECT * INTO #TEMP FROM INSERTED'

    Then obviously it gives error.

    Wat if i want to get all the columns from inserted table excluding the text datatype column, without giving the column names.

    Thanks & Regards.
    Shabber.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Why would you need to copy data from INSERTED into a #temp table?
    Why would you NOT know the names of the columns, when they are the same as the column names on your database table?
    What you are doing does not make sense, and is almost certainly a bad design.

    Why don't you tell us what you are trying to do, and maybe we can suggest a better way. But if you are trying to create "universal" trigger code that you can apply to any table - bad idea.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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