MS SQL: Insert Multiple Rows With One Query

Just figured this out. Using Microsoft SQl Server 2000, you can insert multiple rows into a table with one query as in the following examples:

Single Column:

CREATE TABLE test
(
val1 INTEGER NOT NULL
)

INSERT INTO test
SELECT 62
UNION
SELECT 91
UNION
SELECT 95
UNION
SELECT 98
UNION
SELECT 99

This will insert 5 rows into the table. To do multiple columns, use the following:

CREATE TABLE test
(
val1 VARCHAR(10),
val2 VARCHAR(10),
val3 VARCHAR(10),
val4 VARCHAR(10)
)
GO

INSERT INTO test
(val1, val2, val3, val4)

Please...Stop Using The Word Amazing

Just listening to the show "So you think you can dance," I've heard the word "amazing" at least 100 times. I hear it all the time. It has to be the number one overused word. For the love of God, get a vocabulary.

Topics:

Linux Tips: FTP with gFTP

gFTP is an open source graphical FTP client. It has a nice user interface and is easy to use. I've had problems with it doing large ftp transfers, so in those cases or cases where I want to transfer server to server, I use kasablanca. The GUI is a bit clunkier and is lacking some features, but it is best for certain situations.

Linux Tips: Image Editing With The Gimp

The Gimp, or GNU Image Manipulation Program, is an excellent, free image editing software package for Linux, and Windows. As far as I can tell, it does everything the big name programs do, except allow the creation of shapes. Coming from Fireworks, it was tough to get used to. But you can create vectors and areas, and then fill them. While I am not a professional, I did create this graphic using The Gimp.

Linux Tips: Installing And Updating

One of the reasons the average person complains about Linux is the perceived or rumored difficulty in installing software, or performing updates. It is true that it is somewhat difficult if you have to compile your application or driver, as I do with vmware (the only way to run Windows) and my video card driver, but installing and updating a Kubuntu system is not difficult and automatic most of the time.

Linux Tips: Move, Shade Window

In Kubuntu or KDE (I think...at least with Beryl), a window can get positioned so that you can't grab the title bar (the bar up top that has the menus on the left and right). To move it, hold down ALT and click anywhere on the window and drag.

Shading a window will collapse it into the title bar. To do this, double click on the title bar on top. You will be able to fit a ton of windows on a desktop and not have to go to the task bar, or use the ALT + TAB combination to cycle them. Simply double click them to "unshade??" them.

The Housing Market Bubble

The housing market in Washington State is terrible as it is in many places around the company. Real estate prices are skyrocketing out of control in this area (the greater Puget sound), way beyond what most people can afford. There are "condos," glorified apartments really, selling for $175,000 in some of the worst areas in these parts (Casino Road for the locals). These apartment conversions were built in the 60's, are barely 1000 square feet and are, as mentioned, located in one of the worst parts of this area. A house is going to set you back $300,000 dollars minimum.

MySpace Thwarts Parental Control

After a comment from a reader, I have finally realized the major flaw in the way MySpace does business, especially with minors.

A concerned parent wrote asking about access to her child's private MySpace profile. Her child does not login to the computer at home, but in other places such as friends' places. But because her daughter has a private profile, she can not access it.

As I thought about the reader's problem, a major issue with MySpace finally became clear.

Topics:

Dell Offers Ubuntu Linux!

C|Net News.com is reporting today that Dell is now offering Ubuntu Linux as an option for new computers. The article reports that Dell has attempted this before with little success. However, after actually listening to the consumers and realizing that Ubuntu has made great strides towards being a contender for the operating system of choice for the average consumer, Dell is giving it a try once again.

Linux Tip: Get Real Time System Information

To get real time system information from most Linux systems, use the command top. Open up a command prompt and type top. You'll get a updating readout of processor percentage used, memory percentage used, the amount of memory used by process. There are many ways to sort the list and you can kill processes as well (if you run the command using sudo or root).

Top Command

Pages

Subscribe to Jacob Steelsmith RSS