Professional ASP.NET 4 in C# and VB

Product Description
This book was written to introduce you to the features and capabilities that ASP.NET 4 offers, as well as to give you an explanation of the foundation that ASP.NET provides. We assume you have a general understanding of Web technologies, such as previous versions of ASP.NET, Active Server Pages 2.0/3.0, or JavaServer Pages. If you understand the basics of Web programming, you should not have much trouble following along with this book’s content. If you are br… More >>

Professional ASP.NET 4 in C# and VB

Microsoft Office 2008 for Mac Home & Student Edition

  • Streamlined user interface runs natively on both Intel- and PowerPC-based Macs
  • Open XML file formats, the Office Art graphics engine, and other features that result in compatibility and file fidelity
  • Professional design is within your power with hundreds of new customizable templates and suite-wide themes, SmartArt graphics, and the new Publishing Layout View in Word 2008
  • My Day keeps you connected to all of the day’s action. Command your calendar, tackle your tasks, and simplify your day
  • Includes: Word, Excel, PowerPoint, Entourage

Product Description
Provides the basics of Office 2008 for Mac for home users and students. Whether your projects are around the house or in the classroom, the reinvented Office 2008 for Mac experience makes it easier than ever to create professional-looking work. Includes: Word, Excel, PowerPoint, Entourage.Amazon.com
Homework and Home Work will be easier than ever with Microsoft Office 2008 for Mac Home and Student Edition. Get better results faster and create high-quality … More >>

Microsoft Office 2008 for Mac Home & Student Edition

Pro ASP.NET MVC Framework

  • ISBN13: 9781430210078
  • Condition: NEW
  • Notes: Brand New from Publisher. No Remainder Mark.

Product Description
Steven Sanderson has seen the ASP.NET MVC framework mature from the start, so his experience, combined with comprehensive coverage of all the new features, including those in the official MVC development toolkit, offers the clearest understanding of how this exciting new framework could improve your coding efficiency—and you’ll gain invaluable up–to–date awareness of security, deployment, and interoperability challenges. The ASP.NET M… More >>

Pro ASP.NET MVC Framework

Microsoft Office 2010 Home & Student

  • Rich and powerful new ways to deliver your work on your computer, Windows Mobile-based Snart phone or a Web browser
  • Easy-to-use Tools, Customizable Templates, Colr Schemes, and photo-editing capabilities
  • Work with people from different places at the same time with the new co-authoring experience
  • More ways to access your files from almost anywhere, Office 2010 puts you in control of getting things done according to your schedule
  • Simplifies your tasks and creates amazing results

Product Description
Microsoft Office 2010 gives you powerful new tools to express your ideas, solve problems, and connect with people.Amazon.com Product Description
With Microsoft Office Home and Student 2010, you and your kids can create great schoolwork and home projects from multi-page bibliographies to multimedia presentations. Capture ideas and set them apart with video-editing features and dynamic text effects. Then easily collaborate with classmates without being face-… More >>

Microsoft Office 2010 Home & Student

Microsoft Office Home & Student 2010 Product Key Card

  • Rich and powerful new ways to deliver your work on your computer, Windows Mobile-based Snart phone or a Web browser
  • Easy-to-use Tools, Customizable Templates, Colr Schemes, and photo-editing capabilities
  • Work with people from different places at the same time with the new co-authoring experience
  • More ways to access your files from almost anywhere, Office 2010 puts you in control of getting things done according to your schedule
  • Simplifies your tasks and creates amazing results

Product Description
Microsoft Office 2010 gives you powerful new tools to express your ideas, solve problems, and connect with people.Amazon.com Product Description
With Microsoft Office Home and Student 2010, you and your kids can create great schoolwork and home projects from multi-page bibliographies to multimedia presentations. Capture ideas and set them apart with video-editing features and dynamic text effects. Then easily collaborate with classmates without being face-… More >>

Microsoft Office Home & Student 2010 Product Key Card

Microsoft Office Home and Student 2007

  • Essential software suite for home computer users makes it a pleasure to complete schoolwork and other tasks
  • Includes 2007 versions of Excel, PowerPoint, Word, and OneNote
  • Intuitive user interface that exposes commonly used commands; updated graphics and formatting galleries help you to easily produce high-quality documents
  • Work with confidence and security thanks to the improved automatic Document Recovery tool and the Document Inspector tool, which removes personally identifiable information from your document
  • Enhanced Help system includes online tutorials with step-by-step instructions; includes OneNote, a digital notebook that helps you gather, organize, and search many types of information in one place

Product Description
May be installed on up to three non-commercial home computers.Amazon.com
Microsoft Office Home and Student 2007 is the essential software suite for home computer users and includes 2007 versions of Excel, PowerPoint, Word, and OneNote. This system enables you to quickly and easily create great-looking documents, spreadsheets, and presentations, and organize your notes and information in one place, making it easier and more enjoyable for you to get things d… More >>

Microsoft Office Home and Student 2007

MS SQL Server / SELECT clause with a CASE expression

In SQL Server, if you have a column which has NULLs and instead of nulls, if you want to display ‘Nothing’, what would you do?

The following query

SELECT CASE Dept_Name WHEN NULL THEN 'Nothing' ELSE Dept_Name END Dept_Name
FROM Inventory

would still display the nulls and not ‘Nothing’.

Workaround:

Continue reading “MS SQL Server / SELECT clause with a CASE expression”

How to create an auto-incrementing column in MS SQL Server 2000

Unlike Microsoft SQL Server 2005 and 2008, MS SQL Server 2000 does not have a ROW_NUMBER() function which applies only to the results of a SELECT query as it doesn’t store any permanent value in the DB.

The way it works is in keeping with the principles of relational databases. There is no implict ordering of records in an RDBMS. Only by using ORDER BY, a particular ordering (and not sorting) can be enforced only when doing a SELECT.

Since Microsoft SQL Server 2000 doesn’t have ROW_NUMBER(), the need for creating a primary key column of format int with the auto-increment functionality can be achieved using the keyword IDENTITY(1,1). IDENTITY means “a unique IDENTITY for the record so long as this table exists”.

Usage example:

CREATE TABLE jobs
(
job_id smallint IDENTITY(1,1)PRIMARY KEY CLUSTERED,
job_desc varchar(50) NOT NULL DEFAULT
min_lvl tinyint NOT NULL CHECK (min_lvl >= 10),
max_lvl tinyint NOT NULL CHECK (max_lvl <= 250) ) 

Microsoft’s T-SQL reference under SQL Server 2000 documentation at MSDN explains the IDENTITY property in detail at http://msdn.microsoft.com/en-us/library/aa933196(SQL.80).aspx