|
|
|
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 Difference in miliseconds Posted by Jens Gotthardsen at 7/16/2005 11:49:37 PM Hi there,
Can anybody explain to me why
select convert(datetime, '2005-07-16 22:05:27.332')
returns:
2005-07-16 22:05:27.333
Whichs has a difference at 1 miliseconds.
When I try to store time in a datetime field with miliseconds they
seldom gets saved with the correct miliseconds....more >>
sp_executesql Posted by Jan Hruz at 7/16/2005 11:43:54 PM Hi,
Is there any way how to dynamically create ntext in procedure and pass it to
sp_executesql ?
My statement is longer than 4000 chars. I have found one solution :
add ntext parameter to stored procedure and create this statement on
application level. But I'd rather have solution how to cr...more >>
last updated column Posted by Big D at 7/16/2005 7:47:05 PM I have a database that stores computer assets with SystemName(computername)
being the primary key. I update this database from a Staging table. Below is
a script that gets all the records from the StagingSystemInfo table and if
the computername exists the row is inserted into System Info. If a...more >>
Error in msdn transact sql reference Posted by MariusI at 7/16/2005 10:43:04 AM Hi, i'm creating my own sql object model and parser. I'm using the BNF syntax
specified by the microsoft sql transact reference on the msdn library (see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_tsqlcon_6lyk.asp
for details). The syntax for table joins specif...more >>
Using Identity Columns Posted by MD Websunlimited at 7/16/2005 8:54:53 AM I'm attempting to move data from one database to another =
programmatically. But for the life of me can not get the identity =
columns to work correctly.=20
I create the table, then I issue a SET IDENTITY_INSERT OFF so that I can =
insert the existing data into the newly created table. Howeve...more >>
performance Posted by Jan Hruz at 7/16/2005 12:52:54 AM Hi all,
I created search query that combines fulltextsearch with some other
subsearches and other conditions. My problem is that SQL server also
evaluates conditions or some subqueries which are not needed. For example:
....
@search_string is null or contains(b.*, @search_string)
....
...more >>
HAVING! Posted by Arpan at 7/16/2005 12:07:19 AM Should a column that is being used in the HAVING clause always be
referenced in the GROUP BY clause even if that column is contained in
an aggregate function in the SELECT list (as shownin the second
example below) unless the column being used in the HAVING clause is
contained in an aggregate f...more >>
|
Don't see what you're looking for? Search DevelopmentNow.com.
| home · blog · groups | Questions? Comments? Contact the dn |