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
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
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’
It shows the part of the screen that’s repainted by the browser, nice:
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)
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
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"