|
|
|
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 SQL CMD string is wrong... HELP !!!!! Posted by Dial ISDN Newsgroups at 6/26/2004 6:54:50 PM I have code that looks like below.
I get this error: Run-time error -2147217904 (80040e10) No value given
for one or more required parameters.
I know it is in the CMD string that is wrong. Can anyone help.
Below is code:
Dim cnn1 As ADODB.Connection
Dim rstProcessLog As ADODB.Re...more >>
Dynamic SQL Posted by exBK at 6/26/2004 4:55:01 PM Hi,
In a SP, I want to switch table names based on an input parameter. I am afraid of dynamically building the entire SQL because of SQL Injection problems. Any suggestions on how to achieve this ?
...more >>
invalid object name when executing stored procedure Posted by mj at 6/26/2004 4:04:27 PM hi. new to sql server here. thanks for any help. i have an
update query that i'm trying to execute from query
analyzer and it's giving me an error:
Procedure UpdateAccountsTerritoryID, Line 3
Invalid object name 'accounts'.
"accounts" is definately the name of the table. here's the
thin...more >>
How to list all non-unique data items? Posted by Peter at 6/26/2004 3:55:11 PM Hi, dear friends,
How to list all non-unique data items in a special table field (e.g.
UserName) by using either SQL(select) or T-SQL?
Thanks,
Peter
...more >>
paralell bcp load from same machine? Posted by dbsearch04 NO[at]SPAM yahoo.com at 6/26/2004 2:13:23 PM In the BOL article "Optimizing Bulk Copy Performance", there is a
section about "Loading Data in Parallel from Multiple Clients" using a
partitioned data file on each client.
Is this performace improvement also realized if you invoke the copy
from multiple cmd-shells on the same computer?
P...more >>
Hypothetical speed increase with parent/child records Posted by Rob Nicholson at 6/26/2004 11:34:19 AM We're looking into optimisation of a customers database which we have many
parent/child structures liked by the parent ID, simplified like this:
People Table:
PersonID: Unique ID
Name: Name of person
Addresses Table:
AddressID: Unique ID
PersonID: Parent ID
Address: Per...more >>
Need to make Sort ORDER in SP defined by Input variable Posted by Larry Woods at 6/26/2004 8:32:37 AM I am trying to define my ORDER field and direction (Asc/Desc) as a variable
(or variables) that I pass into a SP. SQL Server doesn't like this.
How do I do it?
TIA,
Larry Woods
...more >>
Insanely Confusing Query - Need Help BAD! Posted by Anthony SQL Dunce at 6/26/2004 8:27:34 AM Here is a simplified example of the setup of the tables I'm working =
with.
Table PROJECT_DETAILS
DetailID | ProjectName | Task | Item | Quantity
1 "Jones House" "Wash" "Car" 2
2 "Jones House" "Empty" "Trash" ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Altering fields in production Posted by Enric at 6/26/2004 6:04:01 AM hi everybody,
I ask myself how many time Sql Server would need in order to alter the lenght of a bloody column?
We've got a table with almost 300 million of rows and we'd like to choose a field which right now own 7 pos and set up till 12.
any help will be appreciate,...more >>
How to use Group By for Text fields Posted by Sree at 6/26/2004 4:20:01 AM I have a table with two fields
Id Name
1 A
1 B
2 C
2 D
I need to get the data in the following form
ID Name
1 A,B
2 C,d
What should i do for the same
Thanks
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |