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

avatar 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

avatar image

Fatherjack ♦♦
43.7k 79 98 117

(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

avatar image

CirqueDeSQLeil
5.5k 11 13 20

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

The answer is yes.

more ▼

answered Mar 26, 2010 at 03:16 PM

avatar image

Ian Roke
1.7k 32 35 38

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

avatar image

Fatherjack ♦♦
43.7k 79 98 117

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

x428
x97

asked: Mar 26, 2010 at 02:53 PM

Seen: 1336 times

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

Copyright 2016 Redgate Software. Privacy Policy