-
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…