| Groups | Blog | Home |
|
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 August 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 group results into a string Posted by nonno at 4/10/2005 8:57:02 PM how to group results from a select statement with single column into a comma
separated string? e.g.
results
--------
a
b
c
....
string:
a, b, c, ......more >>
SQL command problem Posted by Alan Ho at 4/10/2005 7:34:36 PM how can i get data from database...between 1time and 1 time..
e.g. select * from abc where time > 12:00 and time <20:00 <----but it
seems not work
thanks
...more >>
Logical constant in Select Posted by Constantin Chionas at 4/10/2005 6:57:01 AM I can add a constant to any Select statement, SELECT 0 as xxx,* From XYZ, but
how I can add a Logical constant?...more >>
Linked Server - How to write a Query with condtion (string) Posted by Ahmed Jewahar at 4/10/2005 12:14:48 AM Hi all,
I have created a linked server from SQL 2k to Informix which is fine.
I wrote below query which also fine and got results:
select * from OPENQUERY
(myLinkServer, 'select a.emp_number,a.emp_name,a.emp_loc,a.emp_stat,
b.emp_grade,b.emp_title from employee a,title b where a.emp_numbe...more >>
Use a CASE statement Posted by Chris at 4/10/2005 12:00:00 AM I am currency performing the following query in a stored procedure...
IF EXISTS (SELECT TOP 1 T.MyID FROM T INNER JOIN C ON T.CSer = C.CSer LEFT
OUTER JOIN OC ON C.CSer = OC.CSer WHERE T.MyID = @MyID AND DepNo > @DepNo
AND (OC.OSer = @OSer OR @OSer IS NULL) ORDER BY T.DepNo)
SELECT TOP 1...more >>
select into problem Posted by AM at 4/10/2005 12:00:00 AM Hi all
When I run the query I get the problem
select * into table1 from syscomments
I got the error
Server: Msg 511, Level 16, State 1, Line 1
Cannot create a row of size 12029 which is greater than the allowable
maximum of 8060.
The statement has been terminated.
why this happen?
...more >>
Maximum value Posted by James T. at 4/10/2005 12:00:00 AM Hello!
What's the maximum value of Money field?
Thanks
James
...more >>
newbie question on tsql Posted by Hi. In the line:
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].FK_Products_Categories]') and OBJECTPROPERTY(id,
N'IsForeignKey') = 1)
what does the
N' ... '
bit actually do/mean? For example, what does the N do in the
N'IsForeignKey' bit?
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL command problem Posted by Alan Ho at 4/10/2005 12:00:00 AM how can i get data from database...between 1time and 1 time..
e.g. select * from abc where time > 12:00 and time <20:00 <----but it
seems not work
thanks
...more >>
DTS query with vb to excel Posted by xandi at 4/10/2005 12:00:00 AM Hi,
does anyone have an example for doing a query in dts via vb an exporting it
to excel
ths and reg
bxandi
...more >>
dates Posted by Trond at 4/10/2005 12:00:00 AM I have a view that shows me how many visits i have had on my website.
UniqueVisits(number), TheYear(2005 (using datepart)), TheMonth(April (using
datename)), TheDay (Sunday (using datename),TheDate (10 (using datepart)).
The result is like this:
..........
23, 2005, April, Sunday, 10
So f...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |