|
|
|
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 SQL Mail Problem Posted by nomi at 7/4/2004 11:31:01 PM Hi everybody,
I am using sql mail for sending emails. i am facing a problem regarding sending of mails. I have configured sql mail correctly, but whenever i send the mail using xp_sendmail it is present in the inbox of my outlook profile and it never moves from there unless i press send button fo...more >>
Use of Real and Float Posted by davidanoble NO[at]SPAM hotmail.com at 7/4/2004 10:12:43 PM We've come across a serious issue with using these approximate data
types. Basically whoever used them to store our monetary values should
be shot, but moving on .....
Has anyone actually chosen them (apart from in error) for any
application or come across a good example to use them on, and wh...more >>
sql manipulation Posted by Alex at 7/4/2004 9:32:01 PM Hello all;
First of all, Happy Independence Day!!!
Here is the sql I am working with, currently:
insert into dbo.Donor (FirstName, LastName, Street, City, State, Zip, Phone, CompanyID, DateAdded, ControlNo)
select a.FirstName, a.LastName, a.Address, a.City, a.State, a.Zip, a.Phone, 1,getdate...more >>
INPUT type Table Posted by Frank Dulk at 7/4/2004 9:19:42 PM I would like to know if it is possible the use of parameter INPUT type Table
in SP and to execute her saw application VB with ADO.
Is it also possible to use parameter INPUT array (vector) independent of the
date type and did to execute her see application VB with ADO?
Thank you for the attentio...more >>
per SQl Statment SpaltenNamen aendern MsSql 2000 Posted by markusistgut NO[at]SPAM aol.com at 7/4/2004 3:57:48 PM ich möchte per SQl Statment Spalten Namen von Tabellen auf einem
MsSql Server ändern,
so gehts nicht:
RENAME COLUMN customer.customerID to c.num
go
so auch nicht:
alter table customer rename column customer.customerID to phone
go
In beiden Fällen lautet die Meldung: Falsche Syntax in ...more >>
backing up sql server DB nightly Posted by Allen Anderson at 7/4/2004 12:50:35 PM I'm trying to write a program that backs up an sql server database
with all the data, tables, stored procs, functions, (though not users)
nightly as an automated process. I need to be able to handle if
others add new tables, views, and such so I can't preset things to
copy (other than the datab...more >>
Need to know how errors are returned from SQL Server (kinda ADO question) Posted by Larry Woods at 7/4/2004 9:54:01 AM YES, I know that this is kinda' an ADO question, but the ADO newsgroup is
DEAD and
you guys ALWAYS have the answers. Sorry...
I have an SP that I am executing (VBScript - ADO) via 'connection.execute'.
If I
do NOT have 'on error resume next' I get:
Microsoft OLE DB Provider for SQL Serve...more >>
Storing PDF Files Posted by Subzero at 7/4/2004 9:15:18 AM Is it possible/recommended to store PDF files in SQL
Server. Any help is appreciated.
Ed...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Performance problem with stressed environment Posted by sonbaby at 7/4/2004 6:43:02 AM We have some fast SPs which transaction isolation level set with "read uncommitted" (=> that means theses SPs don't wait for locks and don't make any shared locks)
And the disk I/O and CPU usage are very low.
So, the response time of these SPs are very short with no stress.
But.. when we do...more >>
Time Only Field Posted by Wayne Wengert at 7/4/2004 6:37:14 AM I have a field in a SQL Server 2000 database in which I really only want to
store the time of day (e.g. 6:45, 14:30, etc.). I do not care about the
date. If I am getting the time from a textbox what syntax should I use to
store this?
Wayne
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |