Results 1 to 3 of 3

Thread: About keyword Append in SQL

  1. #1
    Join Date
    Feb 2009
    Posts
    78

    About keyword Append in SQL

    hello friends,

    I wanna know about the keyword called append in SQL. What is the importance of this keyword ? How do I use it in SQL ?
    Can somebody help me providing some useful information and ideas regarding the same....

    thnx

  2. #2
    Join Date
    May 2008
    Posts
    2,302

    Re: About keyword Append in SQL

    In SQL, append means to merge or to concatenate.

    It can be appending anything, for example, appending two strings or appending two tables, etc

    Also, this function is very useful in managing queries. The append keyword helps to simplify queries to a great extent.

  3. #3
    Join Date
    May 2008
    Posts
    2,393

    Re: About keyword Append in SQL

    SQL with fundamentally support it, but in communicating with MySQL you need
    to be careful to understand what you are doing. The result of your proposed
    query would be the same as the final query since that is what would be
    returned in the results set.

    You can union to queries which sounds closer to what you are after, but
    realistically the only time that a set of SQL statements make sense is when
    you are implementing some process (and insert followed by and update on a
    different table then a final selection). But from a programmatic side, each
    step should be isolated to understand any failure condition that might
    happen.

    So the long answer is yes, but you shouldn't use that capability. Union (and
    its counterparts) is available to join query results sets but each query
    should be distinct from programming implementation. If you are trying to
    combine queries for processing then stored procedures are a valid option
    since they provide the programming controls and DB side native processing.

Similar Threads

  1. Keyword Analyzer and keyword ranking tool
    By Captain Carrot in forum Technology & Internet
    Replies: 5
    Last Post: 21-06-2010, 03:12 PM
  2. Append text to end of file
    By New ID in forum Software Development
    Replies: 5
    Last Post: 18-01-2010, 08:35 AM
  3. need to append string in a list
    By Jannat in forum Software Development
    Replies: 2
    Last Post: 30-06-2009, 09:24 AM
  4. Asp.net 3.5 c# append to head
    By karan k in forum Software Development
    Replies: 3
    Last Post: 29-05-2009, 05:33 PM
  5. Replies: 3
    Last Post: 09-01-2009, 12:38 PM

Posting Permissions

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