|
|
|
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 Table Design Question Posted by Timothy at 4/25/2004 11:05:09 PM Hi,
I have a question about database design. I have a main table that has 5
child tables referring to it through a one to one relationship. The design
of my table is the following:
Products
ProductID (autoincremental)
ProductCode
....
Table1ID (foreign key)
Table2ID (foreign key)
Tab...more >>
Select the most recent date Posted by Donald Pickering at 4/25/2004 10:14:30 PM Running SQL Server 2000 on Windows 2000 server.
I have a table where one field is a date field.
I want to find the records with the most recent date in them.
What SELECT command will find the most recent date?
...more >>
Could it be permissions? Posted by Rob Meade at 4/25/2004 9:59:50 PM Hi all,
I have written a small windows service (vb.net) which checks a directory for
a new
file, upon receiving one writes a line to the log file and then copies the
file (small text file) to SQL server.
I've had a few problems with it today, so have been running it in debug
mode (visual s...more >>
Cannot resolve collation conflict for equal to operation. Posted by Glenn at 4/25/2004 7:46:04 PM Getting this error when trying to join tables, does anyone have any direction for me to look to solve this problem
I have seached the support pages at MS and found nothing that will help
Running SQL Server service pack
...more >>
Alter column to change IDENTITY Seed Posted by Kevin3NF at 4/25/2004 3:56:13 PM Is it possible to reset the seed of an identity column in TSQL? I know =
I can do it via EM, and I don't want to drop and re-add the same column =
with a new seed each time I run the SP.
Thanks,
--=20
Kevin Hill
President=20
3NF Consulting
www.DallasDBAs.com/forum - new DB forum for D...more >>
Disadvantages of Stored Procs in SQL Server 2000 Posted by Jonathan Derbyshire at 4/25/2004 3:46:02 PM Hi
What are the disadvantages of using Stored Procedure's in SQL Server 2000
Thank
JD...more >>
HELP! Using CASE statement within WHERE clause? Possible? Posted by Utter Newbie at 4/25/2004 3:25:26 PM I was wondering if it were possible to use a case statement within a
where clause... Something like:
UPDATE #RequiredItems SET Quantity=@Unit1
WHERE PartNo = (CASE(@SystemType) WHEN 'full' THEN '21' WHEN 'Half
THEN '23' ELSE '26' END)
I'm guessing it isn't but would like confirmation. Plea...more >>
How do Stored Procedures provide greater security? Posted by Jonathan Derbyshire at 4/25/2004 12:01:03 PM Hi
Could you please tellme how Stored Procedures provide greater security? Books often promote the use of SP's as they improve security, but never seem to explain why
Thank
JD...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Sr. SQL DBA job open in Texas Posted by yimincanada88 NO[at]SPAM yahoo.com at 4/25/2004 10:57:03 AM Hi,
Looking for a Sr. SQL Server DBA to work for Verizon in Texas. It will
be contract-based job through an IT consulting firm. Good rate. If
anyone interested or if you know someone could be interested, please
email resume to:
yimincanada @ yahoo . com
Thanks...more >>
how to delete log files Posted by sunitha at 4/25/2004 5:46:38 AM If i did any operation(backup etc) in sql server 2000 it
is recorded in log files. but i don't want to record my
operation
Can It possiable.
or else how can i delete specified log information by
stored procedure
thx a lot...more >>
Updating statistics Posted by Sky Fly at 4/25/2004 4:03:14 AM Hello all,
I've written a stored procedure which runs OK for the
first few thousand records it processes, then around
about the 10,000th record it suffers a sudden and dramatic
drop in performance (from about 40 records per second to
about 1 per second).
I've found that when this happens, ...more >>
HowTo - Pass in an array of values to SP & sp_executesql Posted by RoveR at 4/25/2004 12:05:48 AM Hi,
I want to pass in an array of values to be used in a select statement as a
where clause with the IN operator like this:
Select * from TableX where id in ('A1', 'A2', 'A10' )
The 'A1', 'A2', 'A10', etc are to be passed in as an array of strings. I
can't seem to find any documentation o...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |