|
|
|
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 Query hints exceed maximum command buffer size of 1023 bytes Posted by Sri at 11/7/2004 11:03:01 PM I have built a SELECT query (@StrSql) of length around 3500.
And I am trying to BCP query out to a text file.
SET @StrBCP = 'BCP "' + @StrSql + '" queryout "d:\test_result.csv" -t"," -c'
EXEC master..xp_cmdshell @strbcp
When I execute I am getting the following error.
Query hints exceed...more >>
Call a store procedure Posted by Alberto at 11/7/2004 8:23:10 PM I need call a store procedure from another and store the return value in a
var.
How can I do it?
Thank you very much
...more >>
install SQL SERVER 2000 Posted by Frank Dulk at 11/7/2004 6:49:12 PM I have Windows XP service pack 1, I want to install SQL SERVER 2000 but I
heard to say for the own friends that already tried to install SQL that not
of the right, because SQL is not compatible with Windows XP, more precisely
the version Beta of SQL, now I don't know what do if I arrange MySql or...more >>
ADOMD.Net cellset and datareaders Posted by Charile at 11/7/2004 4:22:22 PM Hi,
What is the difference, from a performance standpoint, between using
AdoMd.Net cellset and using AdoMD.Net DataReader?
Thanks in advance,
...more >>
Please help SQL Posted by Ed at 11/7/2004 2:41:01 PM use northwind
Declare @Customerid varchar(5)
Declare @SQL varchar(500)
Set @Customerid = 'ALFKI'
Set @SQL = 'Select CustomerID from customers where customerID = ' +
@Customerid
Exec (@SQL)
What's wrong with the above T-SQL, it said Invalid Column Name ALFKI..
Do i miss something for this ...more >>
PK,FK** Posted by maryam rezvani at 11/7/2004 1:31:27 PM Hi
I'm working with SQL Server 2000,I have a conceptual question:
imagin I desgned 2 table with following structure:
Books (BookId PK numeric(2),BookName AK char(50),BookDate date)
Authors (AuthorsId PK numeric(3),AuthorsName char(20),BookId FK)
there is a relat...more >>
Sending sql database to user what files will they need? TIA sal Posted by sal NO[at]SPAM spp.net at 11/7/2004 12:00:07 PM Greets, All
I've just finished a vb.net program that connects to an MS SQL database locally. The user doesn't have
MS SQL server MSDE installed. Will they have to install the MSDE sql Server or will they be able to
just have the one ms SQL database file I created on thier system?
TIA
...more >>
between start_date and end_date sql statement Posted by yan at 11/7/2004 11:18:35 AM Hi, Guru,
In the customer table, I have two fields with "DataTime" data type in the
format "mm/dd/yyyy". In my VC application, I have two variable values in
the type of COleDateTime. How can I build a sql statement to retrieve data
from a table? Please show an example in C++. I use a CStrin...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
update trigger help!! Posted by ST at 11/7/2004 8:16:02 AM Hi,
I'm trying to make this trigger that inserts, updates, and deletes a record
from a table, when the original table is changed. I've gotten the "insert"
trigger down...but I can't figure out the update part? For instance: If I
want to change the date field for a subject in the original ta...more >>
optimal indexing Posted by Lee The Moodster at 11/7/2004 6:03:02 AM Correct me if I am wrong. If you have a table that has columna and columnb
and you create an index of columna and columnb, then there really is no valid
reason to create another index of columna alone. If you attempt to search
for columna alone, it will use the columna / columnb index automa...more >>
how to construct a sql statement with a date field Posted by yan at 11/7/2004 2:20:00 AM I have a table with a field of type "DateTime" in SQL Server 2000. How can
I construct an INSERT sql statement in Visual C++ with a proper format of
the "date" field. The "DATE" field is in the format of "mm/dd/yyyy".
MyTable (id primary key,
customer_name varchar (50),
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |