Archived Months
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
all groups > sql server programming > july 2007 > threads for sunday july 22

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

Want to add 00 to the end of values in a table
Posted by Sam at 7/22/2007 11:59:58 PM
I have a table apdoc which has certain itmes in there are 6 character values and I wanted to add 00 to these values so e.g 456789 would become 45678900. Could some guide me on a script for the same. Thansk Sam ...more >>


sp_trace_create returns error for @maxfilsize
Posted by jase at 7/22/2007 11:18:44 PM
Hi Can anyone help. I can create and use trace files usung so_trace create, but when I use the @maxfilesize I get an error: Procedure expects parameter '@maxfilesize' of type 'bigint'. I create my trace like so: sp_trace_create @traceid = @traceid OUTPUT, @options = 2, @maxfilesize = 10, @t...more >>

Where do I start?
Posted by wipeout64 NO[at]SPAM hotmail.com at 7/22/2007 8:32:37 PM
I'm planning to transport a desktop application to the web. A spin-off of this application has already been put on the web by another programmer. He used ColdFusion with MS SQL, Access, VC, and Java. It is faster than the desktop application (written in VFP). 1. Can I get the same results usi...more >>

sql mail in SQL 2000/Outlook 2003/POP3
Posted by Jack at 7/22/2007 2:20:01 PM
I am using Outlook 2003 and sql 2000 and POP email service. When completing backup jobs, I want an email notification to be sent out. The email is not being received. Only when I stop sql server and open outlook on the server do all the emails get sent out. If I keep outlook open on the se...more >>

saving an xml to a file
Posted by pelegk1 at 7/22/2007 2:10:02 PM
i am building xml in a Stored Procedure,by connecting a string of results from a table. and i want to save the xml to a file on the Local Disk on the server. how can i do this? thnaks i nadvance peleg...more >>

Date!!
Posted by Nigel at 7/22/2007 12:00:00 AM
Hey guys, I need to setup a query on an ASP page that will query a table and return only the records that have been updated on a given date but I am stuggling on the format that the date needs to be in. I am using the following query but it fails when it gets to the time section of the date...more >>

Any function to get date only?
Posted by Bpk. Adi Wira Kusuma at 7/22/2007 12:00:00 AM
If I have: Set I='2005/4/5 5:9:0' I want to get date only, so I='2005/4/5' Any Function to do it? ...more >>



DevelopmentNow Blog