 |
|
|
|
 |
Membership: |
 |
Latest:
sarfraz |
 |
New Today:
0 |
 |
New Yesterday:
0 |
 |
Overall:
733 |
|
|
|
|
|
|
|
|
|
|
|
|
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."
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
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!!
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| MS Project 2007: Resource Pool by bilo2000 | Times Viewed: 234  Updated: Monday, February 04, 2008 10:28 AM | | MS Project 2007: Why and How to split a Task by bilo2000 | | Times Viewed: 222 Updated: Monday, February 04, 2008 10:09 AM | | MS Project 2007 :: The first 4 Steps to start using Cubes by bilo2000 | | Times Viewed: 215 Updated: Monday, February 04, 2008 10:11 AM | | MS Project 2007: Efforts Driven Tasks by bilo2000 | | Times Viewed: 230 Updated: Monday, February 04, 2008 10:15 AM | | MS Project 2007: How to share resource to Enterprise Resource Pool by bilo2000 | | Times Viewed: 222 Updated: Monday, February 04, 2008 10:25 AM | | MS Project 2007, Task Types by bilo2000 | | Times Viewed: 228 Updated: Monday, February 04, 2008 10:35 AM | | MS Project 2007: Calendars for project, resource and tasks by bilo2000 | | Times Viewed: 211 Updated: Monday, February 04, 2008 10:38 AM | | MS Project 2007: More talks about resources by bilo2000 | | Times Viewed: 246 Updated: Monday, February 04, 2008 10:39 AM | | MS Project 2007 References by bilo2000 | | Times Viewed: 273 Updated: Monday, February 04, 2008 10:42 AM | | MS Project 2007 : Work and Material Resources by bilo2000 | | Times Viewed: 213 Updated: Monday, February 04, 2008 10:17 AM |
|
|
|
|
|
|
|
|