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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
|