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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|