SQL Recipes
A FREE cookbook for SQL queries and examples
FAQ Search Today's Posts Mark Forums Read

General DB Chat If it relates to databases ... write about here.

Go Back   SQL Recipes a FREE cookbook of SQL queries and examples > SQL queries and examples > General DB Chat
Insert Statement Insert Statement

Reply
 
LinkBack Thread Tools Search this Thread
  #1 (permalink)  
Old 08-07-2008, 07:03 AM
sushi gulhane
 
Posts: n/a
Exclamation Insert Statement
I Have one query,


How to insert data in two table using single query????
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 08-26-2008, 10:11 AM
Unregistered
 
Posts: n/a
Default Re: Insert Statement
You cannot use a single statement to insert data into 2 different table...

Thanks
Sandesh S
Microsoft SQL Server
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 09-16-2008, 11:06 AM
Unregistered
 
Posts: n/a
Default Re: Insert Statement
Technically not possible but logically yes using triggers
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« New SQL Statement without re-opening connection | - »

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 06:50 AM.

Contact Us - SQL Recipes - Archive - Top

Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.0.0
Copyright (c) 2006-2008 SQL Recipes

1 2 3 4 5 6 7 8