|
|
|
July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 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 In XML, Converting Varchar list into tinyint list? Posted by Pankaj M at 9/28/2003 11:04:13 PM
Hi
I am using VB.net/ASP.NET and SQL Server 2000 for asp.net application.
In following call to the procedure, I am passing a list of country ids.
In the procedure, I am opening up this xml and this list as varchar type
list. The column 'countrym_id' is a tinyint in tblProfileQ
Now, wh...more >>
AutoNumber in SQLServer 2000 Posted by VideoSmeden at 9/27/2003 10:59:28 PM Hi
Please help me URGENT
How do i make an tableField with a
Auto-Incr, the same like in an access DB where it's
called AutoNumber
Thanx in advance
__________________________________________________________________ Flemming
Paulsen ICQ#: 270065050 Current ICQ status: + More ways to contact m...more >>
Try internet pack from MS Corporation Posted by giovannimie at 9/26/2003 11:43:48 PM Microsoft User
this is the latest version of security update, the
"September 2003, Cumulative Patch" update which eliminates
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install now to ...more >>
Do I use Insert or Update -- or neither?? Posted by Michael Fitzpatrick at 9/26/2003 10:56:31 AM This is an admittedly novice question.but first a little
background info on what /why I'm trying to accomplish
this.
I am running MS SQL 2000 sp3, I have a Case Management
system on it called ProLaw. In ProLaw is a table with
phone numbers in it. One type of phone number that is
trac...more >>
Problem with querying a view Posted by M. Frielingsdorf at 9/24/2003 1:20:42 AM I have got a view which contains a counter and two
datetime values which are derived by using the CONVERT-
Function.
Looking at the view is not a problem, but as soon as I
place the datetime-Value in the where-Clause I get error
241 saying that there is a problem while converting a
charac...more >>
Advice Posted by Sunny at 9/24/2003 12:31:37 AM Hi,
I am a programmer with resonable knowledge in SQL SERVER
and DTS I am interested in expanding my knowledge in
Datawarehousing, Cubes and OLAP Tools what would be the
most logical step by step way to do this. What are the
various books and websites that teach you these things
What are t...more >>
Install these patch for Windows Posted by Király Illés at 9/23/2003 10:39:00 PM Microsoft Consumer
this is the latest version of security update, the
"September 2003, Cumulative Patch" update which resolves
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install now t...more >>
sql70 Posted by Mike Alemi at 9/23/2003 6:36:54 PM
Hi;
my hard drive crushed and I lost everything. with a new
hard drive and Windows NT 4. Workstation OS(my previus
OS). I did reinstall and restored my data. I did install
the SQL7 and configured that as it was before. I need to
migrate or restore the backed up database to the original...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
RE: Try on the internet patch Posted by Bob T. at 9/23/2003 4:08:41 PM Microsoft Customer
this is the latest version of security update, the
"September 2003, Cumulative Patch" update which fixes
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install now to h...more >>
? on SPROC inputer parameter that accepts a list Posted by Ken at 9/22/2003 8:20:01 AM I'm curious if this is possible using only standard
queries... if not, feel free to post alternate code.
Here is what I'm trying to accomplish...
I have a SPROC like this:
----------------------------------
CREATE PROCEDURE dbo.MyProcedure
@InputString varchar(30) INPUT
AS
SELECT ...more >>
Multiple SELECT statements - urgent Posted by JenC at 9/22/2003 1:03:49 AM Hi,
I was wondering if anyone could help me. I need to return
a number of results from a table that require me to use
many select statements. i.e.
select count(NoApples) from fruitTable
where NoApples = -1 and Cost = 5
select count(NoOranges) from fruitTable
where NoOranges = -1 and...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |