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_emailInsert into consultant values 106,Abdelrazek,Maged,Lexington,KY,4079520220,Prof.mAbdelrazek@yahoo.com 
more ▼

asked Mar 26 '10 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 '10 at 07:29 AM

Fatherjack gravatar image

Fatherjack ♦♦
41.3k 73 77 107

(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 '10 at 02:54 PM

CirqueDeSQLeil gravatar image

CirqueDeSQLeil
4k 10 11 15

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

The answer is yes.

more ▼

answered Mar 26 '10 at 03:16 PM

Ian Roke gravatar image

Ian Roke
1.7k 29 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 '10 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 '10 at 09:11 AM

Fatherjack gravatar image

Fatherjack ♦♦
41.3k 73 77 107

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

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:

x362
x74

asked: Mar 26 '10 at 02:53 PM

Seen: 934 times

Last Updated: Mar 26 '10 at 04:36 PM