-
CTAS and Select Into
In both Oracle and MySQL, you can do: create table T1 as select * from T1 This CREATE TABLE AS statement basically clones table T1 with its structure and data in T2. This can be pretty handy at times. The equivalent of that in Sql Server is SELECT INTO. For example, you can do: select…
-
Sql Server GUI display setting for easy viewing
This is a little note for myself, when overhead projector is involved. Your milage may vary. Query Analyzer, options window: General tab: change Query File Directory to c:\MyPreferredFolder Fonts tab: Editor -> Arial Black, size 16 Fonts tab: Results Text -> Courier New 18 Fonts tab: Selected Text -> Foreground black, Background yellow Windows display…
-
CD writing in Windows XP and ISO Recorder
A couple of things learned while rebuilding my home pc: 1. If you have Windows XP and a CD or DVD rw drive, you do not need Nero, EasyCD Creator, Roxio, or any other third-party software to write stuff to your CD; 2. A free utility for Windows XP, called ISO Recorder, allows you to…
-
Knoppix 3.6 saved the day
For reasons not clear to me, our Windows XP machine at home died recently. It just wouldn’t boot, after trying safe mode, last known good, etc. This machine is an HP Pavilion 513x, around 6 years old. We had a bunch of children’s game software on it, along with other stuff, such as picture and…
-
Delete permission implementation differences
I mentioned when grant statements take into effect in Sql Server, MySql, and Oracle here. I found out recently that there are some implementation differences when you grant only delete permission on a table to a user. MySql and Sql Server do this the same way, whereas Oracle is different. Suppose you have: 1. Table…