combining insert sql statment with select statement for more than 1 value

Question

I'm trying to combine an insert sql statement with a select statement, I successfully combined this statement:

insert into dbo.sessions (se_user) select user_id from dbo.users where username = 'bader'", badersql);

What I need now is to insert another value in the same sql statement, like this:

insert into dbo.sessions (se_user,*se_ip*) select user_id from dbo.users...

As you notice there is se_ip here in the second statement, the value will be from a text box, how can I combine it with my sql statement?

Matthew Abbott · Accepted Answer · 2010-12-15 16:47:35Z

1

INSERT INTO dbo.sessions (se_user, se_ip)
SELECT user_id, @ipAddress FROM dbo.users WHERE username = @username

answered Dec 15, 2010 at 16:47

Matthew Abbott

61.7k9 gold badges108 silver badges131 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

SLaks · Accepted Answer · 2010-12-15 16:45:42Z

1

You can select constant from a parameter:

using (var command = new SqlCommand(@"insert into dbo.sessions (se_user, se_ip) 
        select user_id, @text from dbo.users...", connection) {
    command.Parameters.AddWithValue("text", myTextBox.Text);

    command.ExecuteNonQuery();
}

answered Dec 15, 2010 at 16:45

SLaks

891k182 gold badges1.9k silver badges2k bronze badges

1 Comment

Bader Over a year ago

could you please provide your answer with an example ? , thanks

Joe Stefanelli · Accepted Answer · 2010-12-15 16:46:27Z

1

insert into dbo.sessions 
    (se_user,se_ip) 
    select user_id, @TextBoxValue
        from dbo.users...

answered Dec 15, 2010 at 16:46

Joe Stefanelli

136k21 gold badges244 silver badges242 bronze badges

Comments

pavanred · Accepted Answer · 2010-12-15 16:48:00Z

0

You can use the first insert statement that you have mentioned in your question and then add an update statement to modify the data as you need to

OR

I am assuming you have the value of the textbox in a variable and so you can use something like SELECT user_id,@yourtextboxvalue from userstable...

answered Dec 15, 2010 at 16:48

pavanred

14k16 gold badges56 silver badges60 bronze badges

Comments

Jeff Hornby · Accepted Answer · 2010-12-15 16:48:23Z

0

You'll need to add another field to the select portion of your insert statement

insert into dbo.sessions (se_user,*se_ip*) select user_id, other_value from dbo.users ...

If the value comes from a text box,, it depends on how you're running the insert statement. You'll probably have to set a parameter to your command object. see this link for more details.

answered Dec 15, 2010 at 16:48

Jeff Hornby

13.8k4 gold badges42 silver badges65 bronze badges

Collectives™ on Stack Overflow

combining insert sql statment with select statement for more than 1 value

5 Answers 5

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related