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