|
|
|
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 Variable argument lists for SP's Posted by Richard Hollis at 12/12/2004 11:47:00 PM Is it possible to pass variable argument lists to SP's - akin to the C
va_list (...) train of though?
I've not found a way of doing this and just wondered if it is actually
possible.
Richard
...more >>
Question for Joe Celko - re-post Posted by Michael C at 12/12/2004 10:58:00 PM Hi Mr. Celko,
A few questions on your improved Soundex from SQL For Smarties, which I'm
trying to implement on SQL Server 2K and .NET:
1) In step 2 you say to replace all non-leading vowels with "A". Does that
include "Y"?
2) At one step (5.0) you say to "perform cleanup functions".....more >>
transfer database to new server Posted by shank at 12/12/2004 8:29:04 PM What is the easiest way to transfer a database over to a new server? I've
used DTS but have to go back and fix the ID fields from decimal to numeric.
That's a pain! I've generated the create table script, created the table on
the new server then transferred data. That was OK, but to do that fo...more >>
timeout Posted by Frank Dulk at 12/12/2004 6:10:18 PM Hello, I am with the following problem:
Use vb6 with sqlserver 7 and the time limits to give timeout mistake it is
very small. I need to create a big index or a consultation that it is long a
little more, and soon I receive timeout. What can make to administer this
time?
Or which is the imp...more >>
Deleting Duplicate Records based on "Text" column Posted by Brian Madden at 12/12/2004 2:35:02 PM Hi All,
I have a table with duplicate records in text fields. I would like to delete
the duplicate records, however, everything I have been able to find on the
Internet about this only works when finding duplicates based on number
fields.
For example, if my table was:
1, "hello"
2. "hi...more >>
Code to disable Shift Key Posted by jlybbert at 12/12/2004 2:23:01 PM Does anyone have code or can point me to code that will disable the shift key
in a MSACCESS 2000 Project database?
I appologize for this newbie question. But I need your help.
...more >>
Update problem Posted by Roy Goldhammer at 12/12/2004 1:56:47 PM Hello there
I have on sql two tables: Imp, Cur
The Imp table is being update every month and the update should be transfare
to Cur
If some of the fields was updated on Imp these fields should be updaet on
Cur table
for this i've built:
Update Cur
SET field1 = Imp.Field1.....
FROM Im...more >>
Insert Into Problem Posted by Roy Goldhammer at 12/12/2004 1:09:19 PM Hello there
I have two tables on sql server with the same key
one of them have more records then the second. I need to transfare these
records to the second table.
I've tried INSERT INTO Table2(fields)
SELECT Table1.{ fields }
FROM Table1 LEFT JOIN Table2 ON ....
WHERE Table2.[Key] is n...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Help w/update query using agregate Posted by WhiskyRomeo at 12/12/2004 11:21:03 AM A Batch consists of multiple CustomerOrders that are processed through the
system as whole. We would like to keep a count of the orders in a batch in
the Batch table. But we want to be able to update the count for all batches
(doing a single batch is easy).
I would like to do something li...more >>
trig with identity problem on SQL 2K. Posted by Leon McCalla at 12/12/2004 10:55:00 AM The triggers below send '0' to the XP with every insert instead of the
current identity value. How can send the current identity value from within
an insert trigger? I'm I violating a rule of some kind?
I've resorted to using a GUID/uniqueidentity column to be able to identify
the row to the ...more >>
Help with subquery Posted by larzeb at 12/12/2004 10:22:40 AM I have the following query which works:
SELECT maildate FROM vMailings
WHERE
(SELECT
DATEADD(DD,
(CASE WHEN DATEPART (DW, maildate)= 1
THEN 1
ELSE 9 - DATEPART (DW, maildate)
END),
maildate) as NextMonday) < getdate()
I ca...more >>
Need to select first record by column Posted by Jake at 12/12/2004 9:53:41 AM Hi
I have an ordered table in SQL Server.
I need to select the FIRST record by uniqueID. This is
easy in Access (use the FIRST function) - but how is it
doen in SQL Server???
eg
unID course
---- ------
121 Excel
133 Access
133 db2
147 Word
147 AmiPro
...more >>
Table variable question (sql 2000) Posted by Kevin NO[at]SPAM test.com at 12/12/2004 6:20:30 AM Inside an update trigger, is it possible to create a table variable
(actually, two table variables) from the INSERTED/DELETED tables?
Thanks,
Kevin
...more >>
best practise of clustered primary key Posted by davidw at 12/12/2004 1:42:20 AM I know this is a question people asked again and again, I did that too, but
I still have no clue.
It seems there are some quite clear rules, like user integer, a field that
have unique value, never changed in a period of time. Well, I did that on
all my tables, I give them a identity column a...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |