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. … Read more

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 … Read more

Pro ASP.NET MVC Framework

ISBN13: 9781430210078 Condition: NEW Notes: Brand New from Publisher. No Remainder Mark. Product DescriptionSteven 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 … Read more

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 … Read more

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 … Read more

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 … Read more

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:

Read more

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 … Read more