Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



About keyword Append in SQL

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 11-04-2009
Member
 
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

Reply With Quote
  #2  
Old 11-04-2009
Member
 
Join Date: May 2008
Posts: 2,292
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.
Reply With Quote
  #3  
Old 11-04-2009
Member
 
Join Date: May 2008
Posts: 2,383
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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "About keyword Append in SQL"
Thread Thread Starter Forum Replies Last Post
Keyword Analyzer and keyword ranking tool Captain Carrot Technology & Internet 5 21-06-2010 04:12 PM
Append text to end of file New ID Software Development 5 18-01-2010 09:35 AM
need to append string in a list Jannat Software Development 2 30-06-2009 10:24 AM
Asp.net 3.5 c# append to head karan k Software Development 3 29-05-2009 06:33 PM
How to use Search Engine Keyword Tracker & Keyword Ranking Code using PHP Burnet Software Development 3 09-01-2009 01:38 PM


All times are GMT +5.5. The time now is 05:38 AM.