Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
Insert mutiple table recored in single query
This is a discussion on Insert mutiple table recored in single query within the Database General forums, part of the Databases category; hai, A view can have a column of two table one column is same for both the table I try to insert record in that view but has some bugs ...
|
|||||||
01-24-2009
|
|||
|
|||
|
Insert mutiple table recored in single query
hai,
A view can have a column of two table one column is same for both the table I try to insert record in that view but has some bugs Give the solution for this Saravana Pandian.k 
|
| The Following User Says Thank You to saravanapandian.k For This Useful Post: | ||
| Sponsored Links |
|
01-27-2009
|
|||
|
|||
|
Re: Insert mutiple table recored in single query
Please post your query,table structure for reference
|
|
01-27-2009
|
|||
|
|||
|
Re: Insert mutiple table recored in single query
|
|
03-04-2009
|
|||
|
|||
|
Re: Insert mutiple table recored in single query
You cannot insert records in to a table through a multi table view, in case , any of the column names is common in both the base tables. In case of a multi table view, you can only insert data into base tables, if all the columns included in the INSERT query belong to one base table, and having no similar column name(s) in another base tables. Columns that whose names are commong among the base tables, cannot be included in INSERT through views.
|
|
06-18-2009
|
|||
|
|||
|
Re: Insert mutiple table recored in single query
Always consider
1. one table columns 2. Avoid common columns 3. Should satisfy the check condition if you have. otherwise insert will fail.
|
 |
|
«
sql
|
Version info
»
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| insert query | ronaldrahme | SQL | 2 | 07-03-2008 08:13 AM |
| Insert in a table | raj_imr2000 | SQL | 2 | 02-12-2008 09:15 AM |
| Unique key and Single Query | mail2das.ashok | SQL | 2 | 02-11-2008 04:53 AM |
| How to insert data from one table to an empty table | sahanai mishra | Oracle Apps | 1 | 08-11-2007 11:45 AM |
| Insert of multiple records in single query | ramvidhu | SQL Server | 5 | 07-03-2007 08:53 AM |
All times are GMT -4. The time now is 08:29 PM.
