|
|
|
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 The SELECT Question Posted by OKLover at 8/6/2005 11:57:18 PM I have one table as below:
TABLE1:
item_id tag_no formula
-----------------------------------------
.....
15 AA1 <null>
16 BB1 <null>
17 <null> f15+f16
.....
The content of formula: f15+f16 means that
item_id = 15 + item_id = 16.
My question is that how to SELECT the result as bel...more >>
Updating Database with Windows Installer Setup Posted by Paul Smith at 8/6/2005 11:28:57 PM Hi,
is there an best practice how to update an existing database with a setup
program?
Thanks for any hint
Paul
--
Paul Smith
...more >>
Help!!! Join question Posted by OKLover at 8/6/2005 9:49:01 PM Hi, All
I have two tables as below, TABLE1 and TABLE2.
TABLE 1: Base
ID PName PPrice
-------------------------------------
1 A 30
2 B 20
TABLE 2: History
ID Ldate Amount
-------------------------------------
1 2005/8/7 50
The ID of TALBE1 is the primary key and the ID...more >>
URDU LANGUAGE Posted by Urdu at 8/6/2005 1:34:46 PM How can i use the urdu language in sql server 2000? How does SQL Server 2000
enable support for a language like URDU?
...more >>
ROUND function Posted by Microsoft at 8/6/2005 12:37:13 PM ROUND(12.5, 0) return 12
How implement in T-SQL (SQL Server 2000) to return 13?
...more >>
clustered index on IDENTITY column Posted by Eugene at 8/6/2005 11:59:07 AM Hi, what opinion do you people have with clustered index on IDENTITY column?
Is there more advantage or disadvantage?
Wouldn't it causes all insertion to be added to the same page. Is this 'hot
page' a big issue? Can it helps to prevent fragmentation? How is it so?
Secondly, is adding IDEN...more >>
Conncurrent access to the same stored procedure Posted by Eugene at 8/6/2005 11:50:22 AM Hi all DB guys, I am curious of the performance of the database system on
concurrent access to a single stored procedure. What I mean is, when I have a
stored procedure that is access by multiple connections/clients, what is the
impact on the system?
Apart from that, if I am not mistaken, ...more >>
Max. No. of Columns in a Table Posted by Moorthy at 8/6/2005 6:24:02 AM How many columns can be created in a table in SQL Server 2000? Is it affect
performance?...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
How to insert an image into a table??..is it possible to insert?? Posted by saroja at 8/6/2005 12:04:35 AM I have a created a table pub_info with two fields 1.pub_id string 2.logo
image ...now i want to insert images into logo column and i want to retreive
that into my c#.net program...How can i do that??..please help
...more >>
Split Posted by Yahya at 8/6/2005 12:00:00 AM Dear Sirs,
Is there an sql function that would help me split a field I have with ","
delimiter like "one, two, three". When I select that field I want to
retrieve 3 columns separately with each result alone.
Regards,
Yahya
...more >>
SQL: Removing all spaces? Posted by Ottar Holstad at 8/6/2005 12:00:00 AM Hi, is there a built-in function (that I didn't notice when I looked in the
helpfile) for removing all spaces, or a given character, from a string-value
(most likely varchar)? It must work on MSSQL7 and newer, and if I have to
make a stored procedure, then it's not worth it...
...more >>
ORDER BY clause Posted by simon at 8/6/2005 12:00:00 AM I would like to order my select statement depends on column3 value,
something like this:
SELECT * from table
ORDER BY column1,column2,case when column3=1 then column4,column5 else
column5,column4 end
Any idea?
Regards,S
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |