x

Is this how I would add someone's information to a table

Select C_ID,C_Last,C_First,C_City,C_State,C_phone,C_email

Insert into consultant values 106,Abdelrazek,Maged,Lexington,KY,4079520220,Prof.mAbdelrazek@yahoo.com
more ▼

asked Mar 26, 2010 at 02:53 PM in Default

Michael 4 gravatar image

Michael 4
9 9 9 9

(comments are locked)
10|1200 characters needed characters left

4 answers: sort voted first

it depends . . .

more ▼

answered Mar 27, 2010 at 07:29 AM

Fatherjack gravatar image

Fatherjack ♦♦
42.8k 75 79 108

(comments are locked)
10|1200 characters needed characters left

You have provided nothing more than a query. You need to provide some detail and what your actual question is.

more ▼

answered Mar 26, 2010 at 02:54 PM

CirqueDeSQLeil gravatar image

CirqueDeSQLeil
4.9k 10 11 15

(comments are locked)
10|1200 characters needed characters left

The answer is yes.

more ▼

answered Mar 26, 2010 at 03:16 PM

Ian Roke gravatar image

Ian Roke
1.7k 30 33 34

Well, he is close this time. He needs the parenthesis and the single quotes around the character strings. Its easier to see that with the code formatted though.
Mar 26, 2010 at 04:38 PM TimothyAWiseman
(comments are locked)
10|1200 characters needed characters left

This is likely to work but we still need more information from you

Insert into consultant (C_ID, C_Last, C_First, C_City, C_State, C_phone, C_email) values (106, 'Abdelrazek', 'Maged', 'Lexington', 'KY', 4079520220, 'Prof.mAbdelrazek@yahoo.com') 
more ▼

answered Apr 10, 2010 at 09:11 AM

Fatherjack gravatar image

Fatherjack ♦♦
42.8k 75 79 108

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x376
x77

asked: Mar 26, 2010 at 02:53 PM

Seen: 1136 times

Last Updated: Mar 26, 2010 at 04:36 PM