| Groups | Blog | Home |
|
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 |
Filter by week: 1 2 3 4 5 Access SQL Server from System DSN in ASP Classic Posted by Jim Rodgers at 5/28/2007 6:00:00 PM How the heck do I get permission to use SQL Server from
a System DSN on a webpage?
I am using VBScript and ASP Classic and ADO (Classic), thus:
myConnection.Open "DSN=MySystemDSN"
This works if I use my MS Access database, but when I use my
new SQL Server database, I get the...more >>
Sum as extra field Posted by Vayse at 5/28/2007 3:40:17 PM I have a view, ClientSales. SQL is
SELECT ClientID, SaleValue,..............
FROM dbo.ClientSales
I'd like to add another column, which would be Sum(SaleValue) for the
client. So my output would look like
ABC 10 250
ABC 20 250
ABC 220 250
DEF 40 40
...more >>
Why is connecting to SQLExpress 2005 so difficult? Posted by dan at 5/27/2007 9:50:45 PM Hi,
I've been using db2 and mysql for many years and had no major problems with
connections. They just worked. I just switched to SQLExpress and what a
mistake! I have 4 machines: 3 clients and 1 server. I can connect to the
server from one of the client machines but can't from the other...more >>
login doesn't work Posted by Middletree at 5/25/2007 9:26:05 AM Using SQL Express 2005
I created a new login under the security tab. For these purposes, let's say
the login is called "asp". I then created a user on the specific database
that I want to use, and called it "asp." I tied it to the login called asp.
I made sure that SQL Server is running un...more >>
Change Windows authentication to Mixed mode Posted by Middletree at 5/24/2007 3:32:57 PM How do I Change Windows Authentication to Mixed Mode on SQL Server 2005
(Express)?
...more >>
convert NULL to 0 on import? Posted by HX at 5/24/2007 1:55:32 PM Is there a way to automatically convert any NULLS in a table to 0 (zero)
when importing the table? A setting or something?
...more >>
dropdown in DetailsView Posted by ascll at 5/24/2007 12:00:00 AM Greetings,
How do I insert a dropdown box (predefined values=A,B,C,D) in DetailsView
(prefer codeless)?
Thanks
ascll
...more >>
Script the data Posted by ascll at 5/22/2007 11:47:09 PM Greetings,
How do I use SQL Management Studio to generate the data from all tables (in
same database) to a .sql file?
I might need to execute the generated sql file to import the data to
different databases.
Kindly advise.
Thanks
ascll
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
insert leading zero in zip Posted by HX at 5/22/2007 3:27:51 PM I have some zip codes in my table that are only 4 digits because the leading
zero fell off at some point (during import, or in the xls they arrived in).
How do I now get the zero back in there? My plan is something like IF
len([zip])=4 THEN "0" & [zip] but I'm not sure of the proper syntax....more >>
Simple update query Posted by Nirmal Singh at 5/22/2007 12:00:00 AM I have a table as follows:
Empno VarChar(10) NOT NULL
StartDate DateTime NOT NULL
EndDate DateTime NULL
Letter VArChar(10) NULL
For each Empno there will be several StartDates. I want to update the table
to delete all Letter Codes except for the la...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |