|
|
|
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 alternative function for to_char in sql server Posted by JP at 7/2/2006 10:38:02 PM Hi,
Is there any alternative function for to_char in sql server 2005(T-SQL) that
converts numeric to character in the specified format?
to_char(5,'09')
will result in 05 (in oracle)
to_char(10,'09')
will result in 10 (in oracle)
Thanks
...more >>
Update multiple tables Posted by divaof_7 NO[at]SPAM yahoo.com at 7/2/2006 8:34:17 PM Hi,
I need to update about 2000 database tables, for which update statement
(which I already have run on one table) for each remains the same.
Which is the effective SQL query method to do the same.
Thanks
...more >>
I downloaded and installed SQLEXPR_ADV.EXE Posted by iano at 7/2/2006 4:14:50 PM This file is 240 Megabytes. What am I supposed to see on the start
menu after this is installed?
Is there a tool in here with which I can create a database?
confused in florida,
IanO
...more >>
CREATE TABLE [ database . [ schema1 ] . | schema1. ] tableName Posted by RBC at 7/2/2006 3:36:01 PM Hi,
I try to create 2 schema as the syntax display's as below, but I get a error
as below. Do I have to change any parameters in SQL 2005?
And will I get any other problems in the future to use 2 schema?
Syntax
CREATE TABLE
[ database_name . [ schema_name ] . | schema_name . ] tab...more >>
SQL/.NET naming convention Posted by Byron at 7/2/2006 12:40:02 PM There seems to be a trend toward the SQL naming convention advocated by Joe
Celko that replaces Pascal casing of column names with underscores. For
instance rather than naming a column SaleDate the trend seems to be to use
the name sale_date instead. I much prefer this convention, but in the...more >>
How to convert xs:datetime into sql datetime type? Posted by John at 7/2/2006 11:32:34 AM I am trying to convert xs:datatime into sqldatetime
select cast ('2004-11-06T12:43:17.000+09:00' as datetime)
I got the following error
Conversion failed when converting datetime from character string.
Please advice.
Thanks in advance.
John
...more >>
sql statement Posted by magix at 7/2/2006 12:00:00 AM Hi let say I have table name "tblAmt" that have following record
Year Month Amount
2000 2 100
2002 2 200
2001 4 100
2001 4 100
2000 3 200
2002 1 100
2000 2 200
2002 4 100
I woul...more >>
|
Don't see what you're looking for? Search DevelopmentNow.com.
| home · blog · groups | Questions? Comments? Contact the dn |