| Groups | Blog | Home |
|
January 2003 March 2003 April 2003 May 2003 June 2003 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 April 2008 August 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 SQL/PSM Newbie Posted by catsma_97504 NO[at]SPAM yahoo.com at 5/1/2004 11:09:10 PM Currently running Access XP modules for statistical calculations at
work. This process has become very cumbersome, and I have been asked
to find a way to speed this process up. After going through the
Access database and optimizing everything I could think of, this
process has been reduced to ...more >>
How to ReNumbered as Column? Posted by Hoa at 5/1/2004 8:45:13 PM Hi *.*
I've a table with a Column named Num and another Column named Date, every
time user enter a row I would like to check the Date and automatically fill
the Num col, this way :
Date Num
----- ------
02-01-01 1
02-04-02 4
02-03-23 3
02-02-02 2
04-01-05...more >>
SQL Server tablesize Posted by sean at 5/1/2004 7:05:15 PM HI There,
I am only really new SQL Server and would like to know how many columns a
SQL Server table can support? Also is there a good explanation (on the web)
of SQL Server column datatypes and when to use them?
Sean - thanks in advance for your answer
...more >>
Create Database Posted by Jeff at 5/1/2004 6:30:09 PM Hi -
I'm trying to create a database using VB.NET (see code below), and I'm
coming up with a login exception. I'm probably missing one or more steps,
and I'd appreciate it if you could suggest what I'm missing (or otherwise
how to create a database without raising an exception).
Thanks for...more >>
How do I connect to server by dial up Posted by Antonio Ortiz at 5/1/2004 6:24:21 PM how configure windows connection?
it's possible?
OLE DB connection string?
thanks
Antonio Ortiz Ramirez
asesor en sistemas
ant@aortiz.net.nospam
www.aortiz.net
www.progvisual.com
...more >>
Strange connections, can somebody tell what to do? Posted by Arjen at 5/1/2004 2:29:01 PM Hello,
When I use the command netstat I can see the current connections.
This is what I see:
1. myservername : microsoft-ds OMNIBACK:3296 ESTABLISHED
2. myservername : ms-sql-s ox.ntntc.edu.tw:37720 TIME_WAIT
3. myservername : ms-sql-s ERPSERVER:15372 TIME_WAIT
What does this mean?
Can ...more >>
Best Practice for an Update Statement Posted by Jim Abel at 5/1/2004 12:19:32 PM I was wondering if there is a "best way" to write an
UPDATE statement for the following situation:
Table1 (15 columns) will be updated with Table2 (10
columns) where any one or more columns may contain
differnt data for each inner joined record?
...more >>
How do I schedule a "non-SQL" vbscript for execution Posted by Larry Woods at 5/1/2004 8:47:37 AM Hi,
I want to take advantage of the SQL Server Scheduler to execute a script
that will manipulate some tables in a database, send an email, etc.
Possibly execute an ASP script.
Is this a problem with the scheduler?
TIA,
Larry Woods
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
primary key for a personnel system Posted by toylet at 5/1/2004 1:55:33 AM
Will you use a social security number as the primary key for your tables
in a personnel system? I wouldn't.
--
.~. Might, Courage, Vision. In Linux We Trust.
/ v \ http://www.linux-sxs.org
/( _ )\ Linux 2.4.26
^ ^ 1:52am up 3:15 0 users 1.01 1.00...more >>
sqlserver agent sp exposed? Posted by Guy Brom at 5/1/2004 12:35:49 AM I've noticed the msdb.sysjobschedules table, and I would like to implement a
similiar table for my web-based scheduling task.
Is there any sp or function that can return true/false based on the
rules/values set on this sysjobschedules table?
In other words, assuming I adpot the sysjobschedul...more >>
help on bitmask Posted by Guy Brom at 5/1/2004 12:27:28 AM Hi there,
Can anyone provide a short example on the use of (int) bitmask with sql?
I would like to implement a single int field that is composed of different
values (as seen in sysjobschedules.freq_interval).
Thanks!
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |