Loading HTML fragments with jQuery
When I want to load a html fragment I prefer the contents of the container div in the page and the HTML fragment to have the same ID, like: Master page <!DOCTYPE html> <html>
Month: January 2014
Casting when dealing with nullable fields in a SqlDataReader
When dealing with nullable fields in a SqlDataReader, use: int? field_a = reader["field_a"] as int?; string field_b = reader["field_a"] as string; instead of: int? field_a = Convert.ToInt32(reader["field_a"]); string field_b = Convert.ToString(reader["field_a"]); http://stackoverflow.com/questions/2141575/how-to-efficiently-convert-cast-a-sqldatareader-field-to-its-corresponding
Convert date to "Dutch" string format "dd-mm-yyyy" in T-SQL
If you want to convert a date to a string in the format "dd-mm-yyyy" in T-SQL, you can use the following code: declare @Now date = '2014-01-22' select convert(varchar(10), @Now, 105) Result
How to get the day of week of a all dates between start and end date in T-SQL
If you want to get a list of all dates between a start and end date and their corresponding day of week in T-SQL, you can use the following code: set datefirst 1 declare @StartDate
Fixing: User ‘Domain\Admin’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed. On a Windows 8.1 machine with SQL Server 2012 installed.
After I installed Microsoft SQL Server Reporting Services 2012 and configured it with the Reporting Services Configuration Manager and clicked on de Report Manager URL: I got the error message: User ‘Domain\Admin’
Just discovered the Google Chrome option: Show paint rectangles
It shows the part of the screen that’s repainted by the browser, nice:
How to validate a value can be cast to an integer in T-SQL
Validating if a value is an integer can be done by using TRY_CAST in SQL Server 2012 or a combination of ISNUMERIC and cast to float in <= SQL Server 2008. declare @value as varchar(255)
Building in the cloud and deploying locally with visualstudio.com with Microsoft Visual Studio 2013
If you use the Team Foundation Service (on visualstudio.com) as your source control system, you can build your sources in the cloud, but access the build outputs locally. Just start a new project on visualstudio.com
Just a reminder: null = null, is not true in T-SQL
If you have a nullable column "Description" in one table and a nullable column "Description" in an other table and you join both tables on this column, records with both null in the field "Description"