help needed

[realredice]

Hi

I've just started learning SQL today. How do i insert values to a table i've created?

thnx

ice

[Anu139]

Hi

I've just started learning SQL today. How do i insert values to a table i've created?

thnx

ice

hi,
just go through all the commands available in SQL server books on line, which is available with all MS SQL server installation, and try 2 learn urself best.. any way the answer is
INSERT INTO tab_name Values('MSSQL', 134)
if u r inserting varchar values enclose data between two single quotes like 'MSSQL"
if it is Numeric values write as it is like 14, 78.9 etc etc

regards,

[realredice]

hi

thnx 4 the reply. Another q. Is there much difference between MySQL and SQL* Plus?

regards

ice