Click here to Skip to main content
15,890,282 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: duplicates Pin
Peace ON28-May-10 19:07
Peace ON28-May-10 19:07 
GeneralRe: duplicates Pin
NetQuestions28-May-10 19:30
NetQuestions28-May-10 19:30 
AnswerRe: duplicates Pin
Peace ON28-May-10 20:08
Peace ON28-May-10 20:08 
AnswerRe: duplicates Pin
Eddy Vluggen29-May-10 0:28
professionalEddy Vluggen29-May-10 0:28 
QuestionTo create a website for Examination system Pin
adit ya16928-May-10 14:58
adit ya16928-May-10 14:58 
AnswerRe: To create a website for Examination system Pin
Peace ON28-May-10 19:31
Peace ON28-May-10 19:31 
AnswerRe: To create a website for Examination system Pin
R. Giskard Reventlov28-May-10 19:32
R. Giskard Reventlov28-May-10 19:32 
Questionsql help Pin
Aljaz11128-May-10 7:45
Aljaz11128-May-10 7:45 
I would like to know how to add data into 2 tables in one procedure. I have table1 and table2. Now i insert data to first table, but i have problems with inserting ID(auto-increment) of first table into second table.

I have procedure like this but it doesn't work:

<br />
ALTER procedure dbo.insert_test<br />
<br />
////<br />
<br />
@value1,<br />
@value2,<br />
@value3<br />
///<br />
<br />
as<br />
<br />
declare @table_1 int<br />
<br />
insert into table1(value1,value2,value3) values(@value1,@value2,@value3)<br />
<br />
SET @table_1 = (SELECT table1.ID FROM table1) --> table1.ID is primary key<br />
<br />
insert into table2(table_1, value2) values(@table_1, @value2) --> @value2 is same as for table1<br />


Thanks
AnswerRe: sql help Pin
Not Active28-May-10 8:05
mentorNot Active28-May-10 8:05 
GeneralRe: sql help Pin
Aljaz11128-May-10 8:40
Aljaz11128-May-10 8:40 
Questionhow to fire an event from a different Pin
raghvendrapanda28-May-10 5:33
raghvendrapanda28-May-10 5:33 
AnswerRe: how to fire an event from a different Pin
Peace ON28-May-10 5:44
Peace ON28-May-10 5:44 
AnswerRe: how to fire an event from a different Pin
Sandeep Mewara28-May-10 7:38
mveSandeep Mewara28-May-10 7:38 
GeneralRe: how to fire an event from a different Pin
raghvendrapanda1-Jun-10 3:37
raghvendrapanda1-Jun-10 3:37 
QuestionAjax CascadingDropdownControl Pin
Ratnesh N Bharos28-May-10 3:16
Ratnesh N Bharos28-May-10 3:16 
AnswerRe: Ajax CascadingDropdownControl Pin
Peace ON28-May-10 3:22
Peace ON28-May-10 3:22 
Answer[Cross-post]: Ajax CascadingDropdownControl Pin
Sandeep Mewara28-May-10 4:20
mveSandeep Mewara28-May-10 4:20 
QuestionImage upload dimensions Pin
Paul McGann28-May-10 2:12
professionalPaul McGann28-May-10 2:12 
AnswerRe: Image upload dimensions Pin
JHizzle28-May-10 2:26
JHizzle28-May-10 2:26 
GeneralRe: Image upload dimensions Pin
Paul McGann28-May-10 2:57
professionalPaul McGann28-May-10 2:57 
AnswerRe: Image upload dimensions Pin
Peace ON28-May-10 2:28
Peace ON28-May-10 2:28 
GeneralRe: Image upload dimensions Pin
Paul McGann28-May-10 2:58
professionalPaul McGann28-May-10 2:58 
Questionmultiple web.config file in on application Pin
tanweer28-May-10 1:50
tanweer28-May-10 1:50 
AnswerRe: multiple web.config file in on application Pin
Peace ON28-May-10 2:03
Peace ON28-May-10 2:03 
AnswerRe: multiple web.config file in on application Pin
Jamil Hallal28-May-10 3:37
professionalJamil Hallal28-May-10 3:37 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.