Wednesday, January 6, 2010

Inserting data into a table

Syntax:
insert into table_name values(column_value,column_value,column_value,..n);

The column which have datatype as:
char
varchar
nvarchar
text
are enclosed within single quotes(' ').
Example:
insert into sub values(1,'computer science','cs3yr');

No comments:

Post a Comment