Back to Basics: Count, Count, Count, Sum or how to Count

home
database
view story

4 Kicks

Back to Basics: Count, Count, Count, Sum or how to Count (weblogs.sqlteam.com)

submitted by spirit1(3160) 4 years, 3 months ago

There are at least 4 ways you can COUNT in SQL Server: COUNT(*), COUNT(ColumnName), COUNT(DISTINCT ColumnName) AND SUM() All 4 combined can be used to speed up queries especially for reporting.

add a comment |category: Database |Views: 13
Tweet

tags: SQLServer 2000 Database 2005 another

Everyones tags:

Your Tags:

Please login or signup.

Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

"Kick It" text
"Kick It" background
kick count text
kick count background
border

Simply copy and paste this HTML into your blog post.

Users who kicked this story:

Widescreen(105) -

moff(0) -

kprernn(1445) -

spirit1(3160)

Comments:

No comments so far

Most Active Users

What's this?