Archived Months
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
all groups > sql server new users > august 2007 > threads for august 22 - 28, 2007

Filter by week: 1 2 3 4 5

Why Doesn't this Simple Query Work?
Posted by GeyikBaba at 8/28/2007 3:21:18 PM
Using SQL Server 2003, I am trying to add a field, then populate it. I am getting an error on the last two lines saying the column ClaimType does not exist. When I look at the columns in the table, indeed, it is not there. If I remove the two update lines and run the query again, the cilumn...more >>


Is "Catalog" like Oracle's Schema?
Posted by Emby at 8/28/2007 12:00:00 AM
Hello All, I am brand-spanking new to SQL Server - will be installing it soon. I'm a software app engineer and have used Oracle for many years - and yes, I'll be buying a book (any suggestions welcome!). So a quick into newbie question ... is SQL Server's catalog similar to the Oracle Sc...more >>

Top 10 admin tasks
Posted by Marco Shaw at 8/27/2007 2:19:35 PM
I want to put together a demo of the top 10 SQL admin tasks, but using PowerShell (if it supports that task) to demo it. Anyone know of an online reference that might point me in the right direction, or even just post your own "top 10 list" here. Marco -- ---------------- PowerGadgets ...more >>

Query Q:
Posted by Ana at 8/26/2007 6:27:09 PM
Hi, The following query lists 21786 records when UNION ALL is used and 19015 records when UNION is used. In both cases, only LASTNAMEs are displayed. What am I doing wrong? I'm playing with UNION to understand its use so I can combine several queries into one. TIA Ana SELECT LASTNAME F...more >>

Learning to create tables..what am I doing wrong?
Posted by Rachel at 8/25/2007 12:02:48 AM
Very new to sql and not a programmer. I am learning to create a very = simple database for my client using infopath. I am trying to create = tables and as I am doing the insert by doing new query editor..it does = not work. I can not add to the table. I am using sql server 2005 = management ...more >>

Query Help - multiple selects based on logic inserted into one table
Posted by Jim in Arizona at 8/23/2007 10:22:57 AM
I'm having trouble trying to creat a query that does several things. I have two tables. One is called address the other customer. Both tables have the same column names (mostly, for our purposes here). The goal is to pull out all address related records (addr1, city, state, zip) from the ad...more >>

SQL query for shrink severeal dbs and log files
Posted by Henrik at 8/23/2007 12:00:00 AM
Hi, Im new at SQL and have a question. I need help with a query command that can shrink log files for several DBs when running this query. Greatfull for help. Regards Henrik ...more >>

I have 3 Win 2003 servers - where do i put MOM 2005
Posted by MSExchangeStudent at 8/23/2007 12:00:00 AM
Hi The following 3 servers i do have (all latest updates) 1) Win 2003 Server with Exchange 2003 on it. All latest updates. (E-mail server) 2) Win 2003 Server. Pastel is on it with its SQL database component. 3) Win 2003 Server. I'm setting up Portal 2003 on here. SQL Enterprise is also i...more >>




DevelopmentNow Blog