Wednesday, March 7, 2012

help needed

Hi

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

thnx

ice

Quote:

Originally Posted by realredice

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,|||hi

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

regards

ice

No comments:

Post a Comment