|
|
|
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 Why float value will change when it is saved to DB Posted by George Shui at 8/26/2007 6:40:02 PM I feel it strange that after float value 1.19 saved to DB, and it becomes to
1.189999..., but not all the values has this problem, only a few transactions
will have this problem.
My Table Structure
ColumnnName float 8 not null.
My SP
Insert TableName(ColumnName)
select ColumnName
Fr...more >>
SELECT LOCK? Posted by William Bloodworth at 8/26/2007 2:28:00 PM Scenario:
I have 6+ servers all reading from a single database. There is a table that
is the "to be processed" table and it has a single column that holds IDs.
These IDs are unique and "point" to data in other tables that needs to be
processed.
Problem:
I want each "process" on each serv...more >>
Attention event (for timeout) not getting sent Posted by kumarandjayne NO[at]SPAM gmail.com at 8/26/2007 2:13:35 PM My understanding is that the client generates an "Attention" event
when the timeout has exceeded and sends this event to the SQL server,
which then acts upon this even by cancelling the query.
I am using the SQL Profiler to catch these events.
For one particular long running stored proc the ...more >>
MS Access and SQL Server Coding Differences Posted by robboll at 8/26/2007 12:35:25 PM I am looking for a reference that will present a task such as:
mString = "abcdefghijklm"
problem 1: Usa a function to display everything after the 5th letter:
MSAccess (all versions): mid(mString, 6,200)
Displays: fghijklm
SQL Server (all versions): substring(mString, 6, 200)
Dislpays:...more >>
INDEXDEFRAG and Dynamic SQL Posted by JayKon at 8/26/2007 7:49:03 AM INDEXDEFRAG returns a result set on the Results Grid that I would like to
capture.
The following code works fine and I see the results:
SET @SQL = 'DBCC INDEXDEFRAG(' + @DB + ', ' + @Table + ', ' +
RTRIM(CONVERT(CHAR(6), @IndexId)) + ')'
PRINT @SQL
--INSERT INTO #DBCC_IndexDefrag
...more >>
Convert (signed, VB) CLR UDT to XML Posted by justageezer at 8/26/2007 12:40:00 AM Hi,
I'm getting the 'cannot load dynamically generated assemblies' error when
trying to convert a CLR UDT to XML. The UDT is written in VB and is signed
with a strong name key (neither of which _should_ be relevant !).
I have followed the steps in: http://support.microsoft.com/kb/913668 as fa...more >>
over 4.5 millon reords 700mb file and too long to retrieve data Posted by .nLL at 8/26/2007 12:00:00 AM Hi, i have a database with over 4.5 records actual file is around 700 mb, db
includes ip2location ifromation and i query it with a stored procedure
------------------
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sp_findNetwork]
@ip int
As
SELECT CountryCod...more >>
|
Don't see what you're looking for? Search DevelopmentNow.com.
| home · blog · groups | Questions? Comments? Contact the dn |