CodeWidgets.com: Online Source Code Library: C#, ASP, ASP.NET, VB, VB.NET, VB Script, Microsoft Access, Excel, JavaScript, J Script, XML, VBScript, Website Design, DevExpress Components, Reporting, Application and Website Templates.

Widget #CS0002

Adding a Default value of zero in a lookup Query (SQL Server)

Format and License Info?

Free

When no value has been selected in a Combo Dropdown, add a default value of zero to the query as a placeholder.

SELECT CategoryId, Category
FROM dbo.tblCategories
UNION
SELECT 0 AS CategoryId, 'PlaceHolder' AS Category
FROM dbo.tblCategories

Last Updated: 4/11/2018


Related Widgets 
Price 
# 
CS0035 Alternate row colors on reports with Microsoft Access 2000-2016$0.00Add To Cart
CS0036 Microsoft Access Monthly Calendar Report (ACCDB)$10.00Add To Cart
CS0037 Microsoft Access Monthly Calendar Report (MDB)$10.00Add To Cart
CS0005 Pop-Up Search Form Template$18.00Add To Cart
CS0009 ProperCase Function VB 6.0$0.00Add To Cart
CS0001 Universal Navigation Buttons (Microsoft® Access)$10.00Add To Cart

Recently Viewed Widgets 
Price 
# 
No data to display

Collapse/Expand
Format

Plug & Play Code

Copy the Source Code Above..

Collapse/Expand
License

License

PromoWare

Single Developer Licence.
Re-Distribution Permitted only as part of a compiled Application.This source code is provided to you "as is" without warranty.
CLICK HERE FOR TERMS OF USE
Copyright 2000-2018 CodeWidgets.com and Comrie Software Solutions

This website uses Cookies to store User information and Shopping Cart Items for the duration of your visit to CodeWidgets.com.

No Credit Card or Financial information is stored by CodeWidgets.com. Click Here For Our Complete Privacy Policy and Terms of Use.

I Understand