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 > february 2005 > threads for february 8 - 14, 2005

Filter by week: 1 2 3 4

Order by query question
Posted by James Hancock at 2/10/2005 5:43:46 PM
Ok, this is stupid, I know I should know this but... I've got the following SELECT ID, Name + ': ' + SerialNo AS Name FROM Products ORDER BY Name This always orders by the Products.Name field. I notice that if I change the AS Name to something that isn't in the Products table and change ...more >>

what is database integration?
Posted by coderazor at 2/10/2005 10:05:22 AM
What does database integration mean? I assume it means "integrating databases" but what does that translate as in a real life example. I'm hoping someone can give a helpful definition and an explanation of what that means in the real world. Does it mean merging 2 different kinds of databa...more >>

Failed to copy Database.mdf using copy database wizard
Posted by Mbladen at 2/10/2005 4:37:06 AM
Hi, I'm trying to copy a live database onto a test server so that I can do some work without messing up the live. I seem to of sorted out the Logins, i'm using windows authenticaition and have the same user that I have logged in with set up as the service logon within SQL (had lots of fa...more >>

SQL server and ASP
Posted by TM at 2/9/2005 5:08:22 PM
I need to run ASP pages on laptops without internet connections. The laptops are setup as master and client using SQL Server. Does SQL only server databases? Can IIS or PWS and SQL co-exist on the same machine? I know nothing about server technology. Thanks, TM ...more >>

how to insert decimal number
Posted by Murat D. Hekimoưlu at 2/9/2005 10:52:52 AM
Hi all I am using Asp with SQL Server. When I want to insert a value (ex. 0,20) into db with the data type int. But it doesnt work. What is the problem and how can I solve this -- Murat Demir HEKÝMOÐLU have a nice day ...more >>

Incorrect syntax - help
Posted by Luiz Horacio at 2/8/2005 10:57:23 PM
Hi, Need some help here... Table1 collums number - name Table 2 collums number1 - number2 - other Need to get 'name' from Table 1 , considering that number1 = number and number2 = number. They are not the same number, and number1 and number2 are not related. Just need to get 2 differ...more >>

Moving SQL 6.5 from NT4 to W2K3. Please help
Posted by warsai at 2/8/2005 2:51:05 PM
Hello, As part of Active Directory migration (from NT 4.0 to Server 2003 Enterprise), we will be replacing our current SQL server hardware with a newer server which will be running windows 2003. Can anyone point me to any document on how to go about doing this please. I am very new to SQL ...more >>



DevelopmentNow Blog