|
|
|
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 |
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 REQ help with BETWEEN on hour int column Posted by Rick at 8/21/2004 10:30:32 PM Hello,
Once again my sql ambitions exceed my training and I turn to you for
assistance. I read somewhere years ago that it's best to store dates with no
times (00:00:00 actually) and then add an hour column. This works great for
our needs because we have a counter stores it's results in the ta...more >>
Help need in Building the QUERY Posted by Prabhat at 8/21/2004 6:06:56 PM Hi All,
I have the Below 2 tables:
Donor
=====
DonorID Int -> Primary Key
LastName
FirstName
State
Source Varchar(5)
Donations
========
DonationID Int -> Primary Key
DonorID Int
PledgeDate
DatePaid
Source Varchar(5)
And I Need to Update / Do the folowing:
===============...more >>
SQL Server don't allow decimal data type ? Posted by Mario Reiley at 8/21/2004 4:39:14 PM Hi, Group
I am watch a extranger behavier on decimals fields in my tables.
When I try insert (0.23 or 1.23 or 4.9) or (0,23 or 1,23 or 4,9) the SQL
SERVER change my value to (0 or 1 or 4) or (0 or 1 or 4) WHY ..!
please let my know what would happening !
Best Regard
MArio
...more >>
Date conversion Posted by Maziar Aflatoun at 8/21/2004 3:44:08 PM Hi everyone,
I have a database with a date field 'StartDate' as smalldatetime. I need to
grab the date part and not the time part.
Ex. 2004-08-01 00:00:00 all I need is the 2004-08-01
How do I do that using SQL (Convert or Cast?? )?
Also, is there another datatype I can define it as i...more >>
Date conversion Posted by Maziar Aflatoun at 8/21/2004 3:44:08 PM Hi everyone,
I have a database with a date field 'StartDate' as smalldatetime. I need to
grab the date part and not the time part.
Ex. 2004-08-01 00:00:00 all I need is the 2004-08-01
How do I do that using SQL (Convert or Cast?? )?
Also, is there another datatype I can define it as in...more >>
How to tell when the index on a view is used Posted by Andre at 8/21/2004 3:11:01 PM I tried creating a view in SQL 2000 Standard Edition. It said it was
successful. When I ran an execution plan on it, I could not tell if it used
the index. Can anyone shed some light?...more >>
Understanding the LIKE Posted by Johnny Nielsen at 8/21/2004 2:50:11 PM SELECT @@VERSION
Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15
Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows
NT 5.2 (Build 3790: )
The following returns all records where filefttype is NULL:
SELECT * FROM link WHERE filefttype NOT LIKE...more >>
DTS Posted by Vincent at 8/21/2004 11:48:32 AM I've create a DTS package.
The package import data from a text file to a table.
However the filename is combined with the date (e.g. data2004-08-20)
The filename on the package designer is fixed.
How can I make the filename become dynamic?
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Which lock to use? Posted by Tomas PAJER at 8/21/2004 10:33:01 AM I have table, which contains column - counter which depends on a value in
another column.
Table MYTABLE structure:
id - primary key int identity,
counter int,
typ_id int, - foreign key which drives the values in counter column.
in "pseudo code" :-) ...
select @counter = max(counter)...more >>
Urgent help for object encryption Posted by Faheem Latif at 8/21/2004 3:45:01 AM i have accidently encrypt an object and source had been also dropped can any
one helps me to recover that particular object ,object type is view .
Thank's
Faheem Latif
NETWORK SOLUTIONS...more >>
multi-column indexing question Posted by Shailesh Humbad at 8/21/2004 2:39:24 AM I have several tables like this:
tblOneFishes (
OneID INTEGER PRIMARY KEY
)
tblCrossReference (
OneID FOREIGN KEY
TwoID FOREIGN KEY
)
tblTwoFishes (
TwoID INTEGER PRIMARY KEY
RedFish INTEGER
BlueFish INTEGER
ICanCount NVARCHAR
)
This defines a typical many-to-many relati...more >>
CHinese Character Posted by kiki at 8/21/2004 12:44:18 AM How can I extract a column with traiditional Chinese and
stored as varchar in SQL server via ADO connection in ASP?
My page return strange character and was unable to solve.
pls. help...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |