|
|
|
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 Arrays and lists in SQL 2005 Posted by Erland Sommarskog at 3/3/2007 10:48:11 PM I am glad to announce that there is now a version of my article "Arrays and
Lists in SQL Server" for SQL 2005 available on my web site.
THe URL for the article is
http://www.sommarskog.se/arrays-in-sql-2005.html. If you are curious about
the performance numbers they are in an appendix at
htt...more >>
Twelve Proofs that Muhammad is a True Prophet Posted by lovelydiab NO[at]SPAM hotmail.com at 3/3/2007 9:13:52 PM My brothers and sisters everywhere! With this essay, I am not singling
out the adherents of Islam - to which I ascribe - but rather I am
writing this essay to every man and woman throughout the whole world.
I ask Allah that He facilitates tat this essay reaches every ear,
falls under the sight...more >>
Column does not allow nulls when saving Posted by John at 3/3/2007 6:05:02 PM Hi
I have a vb.net winform data app with sql server 2005 backend. The ID field
in the tblClients table is an 'int' identity column that does not allow
nulls. The problem is that when I try to save the record using the below
code;
Me.Validate()
Me.CompaniesBindingSource.EndEdit()
Me.Com...more >>
for a better understanding - the table structure as script Posted by Xavier at 3/3/2007 12:09:03 PM CREATE TABLE [dbo].[Foobar](
[article_id] [char](13) COLLATE Latin1_General_CI_AS NOT NULL,
[sales_volume1] [int] NOT NULL,
[sales_volume2] [int] NOT NULL,
[sales_volume3] [int] NOT NULL,
[sales_volume4] [int] NOT NULL,
[sales_volume5] [int] NOT NULL,
[sales_volume6] [int] NOT NULL,
...more >>
calcualte "special average" depending on colums values Posted by Xavier at 3/3/2007 9:54:03 AM hello,
i have to calculate the average of 4 values from 6 where the Min and Max of
this 6 are eleminated.
example table
article(varchar(18))
salesvolumeweek1 (int)
salesvolumeweek2(int)
salesvolumeweek3(int)
salesvolumeweek4(int)
salesvolumeweek5(int)
salesvolumeweek6(int)
example
...more >>
left join/inner join/outer join with repeat values Posted by shripaldalal at 3/3/2007 4:17:38 AM hi david,
thanks for the reply.
basically what i need this for is:
there are two tables:
table1 is a master table, table2 is a detail table.
table1's primary_id is present in details_id of table2
table1 has only 1 record
table2 could have many records, usually upto 6 or seven
the...more >>
no duplications in inner join / left join / right join query / JOIN HELP Posted by shripaldalal at 3/3/2007 2:37:05 AM Hi,
I have two tables
table1:
========================
name sirname
===== ======
shripal dalal
deepak dalal
table2:
========================
name ...more >>
Cheap way to get a count on a large table Posted by Simon Harvey at 3/3/2007 12:00:00 AM Hi all,
Can someone tell me the cheapest way to get a count on all rows in a
table. I did a STATISTICS IO ON on a COUNT(*) and it looks like its
doing a full scan on the entire table.
It could be that that is the only way to do it, but surely there's a
cheaper way - it seems quite ineffi...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|
| home · blog · groups | Questions? Comments? Contact the dn |