|
|
|
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 xp_sendmail Problems. Posted by David C at 5/1/2005 4:33:02 PM Hi All,
Recently my automated email sp has stopped working, I have attached the code
below, I don't really think it is the sp but was wondering what else could
make this job not work all of a sudden.
When run it just runs and runs and runs, usually it used to take around 1
second.
I h...more >>
Read a remote web file and parse it Posted by Andrea Moro at 5/1/2005 1:56:17 PM As subject, I need to read a remote web file, csv or xml isn't important,
from a t-sql sp scheduled in a job.
I don't know how to write the remote read steps. Any helps?
Andrea
...more >>
Customer IDs without identity Posted by yzarcman NO[at]SPAM gmail.com at 5/1/2005 12:08:53 PM I am aware of the problems with using identity. I would like a bit
more information on implementation. Concurency is a concern because
this is a net application.
Do I do this at the application level, in a trigger, or using another
method?
I want to make sure that the method I choose is rob...more >>
USE statement in a View - Possible? Posted by Cindy at 5/1/2005 11:31:06 AM I need to access a different database when creating a view, but am having
difficulty figuring out how to incorporate the USE statement.
Can anyone offer any help?...more >>
collation conversion Posted by Stan B at 5/1/2005 6:28:04 AM Hi, I'm using SQL2K OPENXML command to parse XML files in gb2312 encoding
into tables for further validation. I have Chinese characters in the data
like ¹«Ë¾
Due to application support compliance, the data to be stored in columns with
Collation SQL_Latin1_General_CP1_CI_AS.
I found that ...more >>
Problem with CHARINDEX Posted by kd at 5/1/2005 2:09:01 AM Hi,
CHARINDEX does not seem to work on nvarchar datatype.
Code:
declare @pCode as nvarchar(50), @pInfo as nvarchar(50), @index as integer
select @pCode = 'ABZC001'
select @pInfo = 'ABZC0011,CBQA03,FG0023'
select @index = charindex(@pCode,@pInfo)
if @index = 0
begin
.....
...more >>
Date Format Problem - SQL Server Insert From Web Application Posted by Steve at 5/1/2005 12:00:00 AM Hi,
I've written a short aspx file so that end users can insert lines into our
SQL server database. The following string is sent by Internet Explorer to
the database where it updates the relevant table -
INSERT INTO Tbl_Manual([Data Date],[Staff ID], Flag1, Flag2, Flag3, Ref1,
Ref2, Tim...more >>
Create view question Posted by Agnes at 5/1/2005 12:00:00 AM I want to create view to join several tables.
As I want to select the data by the date range , Can I pass the date
condition as parameter to it ?
Please tell me how to do .
I never use View before.
Thanks a lot
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Query problem - top 5 validation Posted by tw at 5/1/2005 12:00:00 AM Hi,
I have a problem to run a query like this scenario:
i have players in a table who have scored in many matches and i want to take
the 5 latest.
The latest i want to multiply with 1.0 and then after with 0.8, 0.6, 0.4 and
finally 0.2.
playerid round score
1, 10, 122
1, 9, 123
1,...more >>
Retrieve only last 4 records. Date descendent ordered. Posted by Shapper at 5/1/2005 12:00:00 AM Hello,
I want to load only the last 4 records of a MSSQL table considering they
are ordered descendent by date. What should my SQL be?
Thank You,
Miguel
...more >>
What mean current session in sql? Posted by JB via SQLMonster.com at 5/1/2005 12:00:00 AM What mean current session in sql?
--
Message posted via http://www.sqlmonster.com...more >>
Finding which db is current (not necessary default) for query and command objects. Posted by Avi at 5/1/2005 12:00:00 AM Hi experts,
How can I find out which database my query and command objects are currently
using.
Thanks
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |