 |
|
|
|
 |
Membership: |
 |
Latest:
shokr.ahmed |
 |
New Today:
0 |
 |
New Yesterday:
0 |
 |
Overall:
747 |
|
|
|
|
|
|
|
|
|
|
|
|
Click here to join our community!
|
|
|
|
|
|
|
|
|
|
TOP vs. Row Count in SQL -
So what approach should you use, TOP or ROWCOUNT? If you are using SQL Server 6.5 or earlier, you'll have to use ROWCOUNT, as TOP wasn't introduced until SQL Server version 7.0. Of course, unless you are supporting a legacy system, chances are you are using at least SQL Server 7.0, if not SQL Server 2000 or SQL Server 2005.
In SQL Server 2005, TOP can do everything ROWCOUNT can. The TOP value can be a parameter, it can be applied to INSERT, UPDATE, and DELETE statements.
"In previous versions of SQL Server, developers used SET ROWCOUNT to limit how many rows the query would return or impact. In SQL Server 2005, you should use the TOP keyword instead of SET ROWCOUNT as the TOP will usually perform faster."
|
|
|
|
|
|
|
|
|
|
Technology is moving into the next era. Are you ready to take the leap with us?
At IT Evolution 08, join us as we unveil the latest technologies that could help change the very DNA of your IT department.
Get a front row seat as we unveil technologies like Hyper-V, App-V and Virtual Machine Manager that will help you ride the hottest trend in IT today - Virtualization. Learn how the new SQL Server 2008 will help you manage any data, any place, any time. See how Visual Studio 2008 provides the most productive developer experience and learn how you can deliver the next generation of rich interactive applications with Silverlight.
|
City |
Date |
|
Abu Dhabi |
Tue Nov 4th |
|
Bahrain |
Sun Nov 9th |
|
Oman |
Sat Nov 15th |
|
Qatar |
Wed Nov 19th |
|
Dubai |
Sun Nov 23rd |
|
Kuwait |
Wed Nov 26th |
|
|
|
|
|
|
|
|
|
| |
Kuwait Univ. Day
|
| Kuwait University Day 2008 |
|
|
| |
Kuwait Univ Day2
|
| Seminar about Silverlight and Sharepoint |
| |
|
|
|
|
|
|
|
|
|
|
|
|
| Welcome to the DotNetBoom portal!
|
|
|
|
|
 DotNetBoom is the first and largest .Net community in Kuwait & Gulf. Established in 2005 the community's ultimate goal is to Help, facilitate and encourage the sharing of knowledge among peers in Microsoft Technologies.
The DNB Community Site now has a lot of new services including forums, blogs, web casts, presentations and downloads, to name a few.
Please read more about us.
|
|
|
|
|
|
|
|
|
|
The DotNetBoom community is introducing a new FREE service to all its members: Hot Jobs! Now, all DNB members may upload their resume/CVs here. These resumes will be available to all concerned corporations at all times.
Remember, you have to login to join!
For corporations that wish to join free of charge please email info@dotnetboom.net for access authorization.
Available Vacancies
- VB.Net, C# or Delphi Developers to be based in Saudi Arabia, post CVs/Resumes here (login required).
- Microsoft Dynamics GP Consultant, post CVs/Resumes here (login required).
- Programmer (.NET), post CVs/Resumes here (login required).
- Sr. Developer (.Net), post CVs/Resumes here (login required).
- MS Dynamics CRM Implementers, post CVs/Resumes here (login required).
- Application Specialists / Consultants / Subject Matter Experts, post CVs/Resumes here (login required).
- BI Technical Specialist for Dynamics GP, post CVs/Resumes here (login required).
- Archiving & EDM Specialist, post CVs/Resumes here (login required).
- Dynamics GP Developer, post CVs/Resumes here (login required).
Post your CVs now!!
|
|
|
|
|
|
|
|
|
|
|
Text/HTML
11/1/2008
Technology is moving into the next era. Are you ready to take the ...
|
Re: Track Visitors
10/31/2008
Hi Ahmed,
Sorry for replying late,to get analytical reports as you are looking for as web...
|
Mea TechEd 08
6/29/2008
|
| 1 2 3 4 5 |
|
|
|
|
|
|
|
|
|
|
| Are you sure that people read your blog???? by bilo2000 | Times Viewed: 109  Updated: Monday, February 04, 2008 10:33 AM | | MS Project 2007: Resource Pool by bilo2000 | Times Viewed: 389  Updated: Monday, February 04, 2008 10:28 AM | | MS Project 2007: Why and How to split a Task by bilo2000 | | Times Viewed: 477 Updated: Monday, February 04, 2008 10:09 AM | | MS Project 2007 :: The first 4 Steps to start using Cubes by bilo2000 | Times Viewed: 363  Updated: Monday, February 04, 2008 10:11 AM | | MS Project 2007: Efforts Driven Tasks by bilo2000 | | Times Viewed: 389 Updated: Monday, February 04, 2008 10:15 AM | | MS Project 2007: How to share resource to Enterprise Resource Pool by bilo2000 | | Times Viewed: 405 Updated: Monday, February 04, 2008 10:25 AM | | MS Project 2007, Task Types by bilo2000 | | Times Viewed: 395 Updated: Monday, February 04, 2008 10:35 AM | | MS Project 2007: Calendars for project, resource and tasks by bilo2000 | Times Viewed: 357  Updated: Monday, February 04, 2008 10:38 AM | | MS Project 2007: More talks about resources by bilo2000 | | Times Viewed: 413 Updated: Monday, February 04, 2008 10:39 AM | | MS Project 2007 References by bilo2000 | | Times Viewed: 411 Updated: Monday, February 04, 2008 10:42 AM |
|
|
|
|
|
|
|
|