Windows: ALT + W, R
Menu: Window | Reset Window Layout
Command: Window.ResetWindowLayout
Versions: 2005, 2008, 2010, 2012, 2013
Software engineering and business solutions blog featuring SaaS reviews, automation tools, and business insurance guides. Buyer-intent content designed to drive high-quality traffic and conversions.
Wednesday, March 26, 2014
Monday, March 10, 2014
LINQ Queries OR SQL checking Nothing or Null Values
You need to check if it's
Nothing first and use the AndAlso keyword to stop it from evaluating the latter statement. Also, when checking if the and object is null, you should use the Is or IsNotoperator rather than =. This should workDim otherRecords As List(Of Objects) = listOf.Where(Function(x) _
(x.ID_NUM = newID) AndAlso _
(x.Codes IsNot Nothing) AndAlso _
(x.Codes.Contains(ddlPrimaryCode.SelectedItem.Text.Trim()))).ToList()
Tuesday, March 04, 2014
Stored Proc Place holder to be filled later example
SELECT
Field1,
Field2,
Field3,
' ' AS FieldName,
FROM tbl_name
WHERE field = @param
Later fill this with the data you need.
Field1,
Field2,
Field3,
' ' AS FieldName,
FROM tbl_name
WHERE field = @param
Later fill this with the data you need.
Subscribe to:
Comments (Atom)
What Happens to 401(k) When You Change Jobs
Understanding Your 401(k) Account Upon Job Change What is a 401(k) plan? A 401(k) plan is a workplace retirement savings account that al...
-
How to clear SharePoint People Picker suggestion cache If you have been SharePoint Site owner long enough, you would have definitely ...
-
Getting the following error (Figure 1): Server Error in '/' Application. ID4014: A SecurityTokenHandler is not registered to ...
-
The problem was that the remote connection needed to utilize Named Pipes, but in order to utilize Named Pipes both the machine hosting the i...