|
|
|
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 Format retrieve data Posted by Ryan Joseph So at 8/1/2004 11:52:31 PM
How can I format my retrieve data on SELECT statement if for example I
am retrieving a numeric data with 6 decimal places and I want the return
data to retrieve only decimal places that is not equal to zero for
example 123.043000 and i want my SELECT query just to return 123.043
Supressing any...more >>
Dynamically create an ordering field Posted by Derek at 8/1/2004 10:57:01 PM I am in the preliminary design of creating a table based off some other tables. The table is to show how long each of our clients was with us each time they were working with us. (They are long term unemployed that come to us for a set period of time during which we attempt to help them get a job)...more >>
What is the cleanest way to: Update Full Text Index? Posted by Russell Mangel at 8/1/2004 8:40:01 PM Hi,
What would be the cleanest way to update a Full Text Index catalog on two
Merge Replication (Push) subscriptions?
It is simple to update the FT Index on the Publisher, but how do update the
Push Subscribers (two in this case)?
I would rather not use the FT schedule...
The behavior:
On...more >>
which is better... SET or SELECT? Posted by Anubis at 8/1/2004 7:35:54 PM Hello All,
Just a simple (yet interesting) question...
Which is better to use in stored procedures?
SET @Variable = 1 + 1
OR
SELECT @Variable = 1 + 1
Any thoughts on this are welcome!
Thanks
-Steve
...more >>
Could not find stored procedure error Posted by Powerbuilder-Sql Server at 8/1/2004 5:57:02 PM Hello,
I am trying to understand something. I am running Powerbuilder 7.0 against sql server 2000. When I run under a particular group, I can run all the stored procedures. When I change groups and try to run the insert stored procedures. I am getting the erro "Could not find stored procedure < s...more >>
How do I change the database owner of a table? Posted by Leon at 8/1/2004 5:07:33 PM How do I change the database owner of a table?
...more >>
deleting rows without fk errors using dts Posted by Bernie Yaeger at 8/1/2004 8:22:49 AM Here's what I'm trying to do: I'm using dts to export a given table to a
dbase5 file on my client's server. I then want to bring that file to my
system via tcp/ip and then import it using dts to my sql server, so that my
client's server tables and mine are the same, for various testing
requirem...more >>
SQL 2K, ADO and character set Posted by Tumurbaatar S. at 8/1/2004 4:18:57 AM My database's collate is set to Cyrillic_General and I have
no problem with a Cyrillic text when using Query Analyzer.
(changed the font settings in Options). But when my JScript
code retrieves the data using ADO, all Cyrillic char-s converted
to '?'. If anybody does not know, JScript's string t...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
can't see japanese/chinese character Posted by Guy Brom at 8/1/2004 2:05:34 AM Hi there,
Using MSSQL2K and W2K Server. On a navchar table I cannot see Japanese or
Chinese letters correctly, although I do see them fine on my OS (browser and
text files). Is there any setting or collation I must use to fully support
unicode?
Thanks!
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |