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 >>
|