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 2006 > threads for saturday july 15

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

The colour combination & flash of this site is gd.
Posted by Ani at 7/15/2006 9:20:39 PM
The colour combination & flash of this site is gd. Flash is attractive, (I LIKE THAT - ITS REALLY GOOD MAN) the site is informing travel related discription here is some text from the site Come to the magical world of hundreds of miracles, Get free info of hundreads of destinations ...more >>

copy from ntext to nvarchar
Posted by Howard at 7/15/2006 8:49:12 PM
I have to 2 tables TABLE1 has columns:ID, TEXT TEXT is ntext format TABLE2 has columns: ID,ERROR,TEXT ERROR is int default value is 0 and TEXT is nvarchar(4000) I'd like to copy the content of TABLE1.TEXT to TABLE2.TEXT and if TABLE1.TEXT is greater than 4000, then truncate and copy and ...more >>

Is it acceptable to...
Posted by Daniel at 7/15/2006 6:56:42 PM
.....store some data in a logfile and a reference to the logfile location in the database? For instance i have a situation where any number of players could be playing a game. I can do this: GameTbl GameId GameName linked to a table: GameDetail GameDetailId GameId PlayerId ...more >>

best way to get percentages
Posted by rodchar at 7/15/2006 12:54:02 PM
hey all, this may look familiar to some of you but i have a new question regarding this: i have a small table that looks like the following: gender/age ------------- male 18 female 32 male 40 female 25 female 26 female 30 how can i store or display horizontally like ...more >>

LEFT OUTER JOIN
Posted by intractably NO[at]SPAM gmail.com at 7/15/2006 9:57:17 AM
What is a left outer join? If you don't know what a LEFT OUTER JOIN does in SQL, look into it in the docs. This will eliminate the need to perform many queries outside of SQL. It performs a "non-restrictive" join across multiple tables. In other words, if you try to join a field with a field i...more >>

Transactions in PHP on SQL Server 2005
Posted by ~john at 7/15/2006 8:40:14 AM
I'm trying to get a transaction to work with PHP 5.1.4 and SQL Server 2005... The first SQL statement deletes several rows in the database. The next SQL statement loops through and inserts several rows into the same table. What I'm wanting is for the database to rollback all transactions if any ...more >>

MSSQLSERVER I/O error (bad page ID) detected
Posted by erolozgunay NO[at]SPAM gmail.com at 7/15/2006 7:39:42 AM
have ms sqlserver 2000 istalled on windows 2003 standart edition server when i try to use my program program give error and then close in the event viewer MSSQLSERVER Error: 823, Severity: 24, State: 2 I/O error (bad page ID) detected during read at offset 0x00000000a1c000 in ...more >>

Why VC++ ADO runs slow on WIN2003 cluster ?
Posted by ikaliy at 7/15/2006 5:05:44 AM
Hello, I have a performance problem with component written in: - VC++ 6.0 as console application which uses - ADO for connecting to SQLServer2000 for - exporting data from one table into ASCII file. Component works fine on my laptop (WinXP,1GB RAM). But, when I run this component o...more >>



stored procedure execution
Posted by nithya at 7/15/2006 12:01:01 AM
We have upgraded our operating system of database server to win 2003 standard edition. We could install the sql server-2000 properly. All workstations are still win-NT and established the connectivity also. But when we tried to execute the stored procedures it shows error as follow. “Msg ...more >>


DevelopmentNow Blog