Andrew Channels Dexter Pinion

Wherein I write some stuff that you may like to read. Or not, its up to you really.

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


Posted by: Babu on June 4, 2003 05:30 PM

In 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...

Posted by: Rose on June 7, 2003 07:20 AM


It is standard sql. Given two tables (call them tab_one and tab_two) you insert rows into one from another with code like;

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

Posted by: Andy Todd on June 9, 2003 12:23 PM