June 04, 2003
Playing Vim Catchup
A useful tip that I didn't know until today is how to discover what the current value of various options
are. According to the manual you just type;
:set {option}?
Where {option} is the name of your option. So, to find out the current folding method we use;
:set foldmethod?
Posted by Andy Todd at June 04, 2003 02:31 PM
Also, if you don't know what option you are looking for, you can simply do
:set
Posted by: Babu on June 4, 2003 05:30 PMIn sybase / sql server, Can we have an insert statement like the following:
insert student(id, age) as (select, age from stud where age < 20 )
I need to append the results to student table..
Any thoughts on this...
Regards,
Rose
Rose,
It is standard sql. Given two tables (call them tab_one and tab_two) you insert rows into one from another with code like;
INSERT INTO tab_one
( col1, col2, col3 )
SELECT cola, colb, colc
FROM tab_two
Just make sure that the columns definitions are similar enough not to cause data type issues.