Here is reusable function which can be used to format SQL dateTime to any format like C# or VB.net DROP FUNCTION dbo.fnFormatDate GO CREATE FUNCTION dbo.fnFormatDate (@Datetime DATETIME, @FormatMask VARCHAR(100)) RETURNS VARCHAR(100) AS BEGIN DECLARE @StringDate VARCHAR(100) SET @StringDate = …
T-SQL Date Format Function – fnDateFormat like .net Read more »
If you ever tried to cast string to XML data type in SQL Server then you may encounter this error select cast(xmldata as XML) from XMLFiles Msg 9402, Level 16, State 1, Line 1 XML parsing: line 1, character 54, …
unable to switch the encoding error with XML Data type Read more »
Consider scenario where you want to populate missing data from previous date when data was available. In the following example we want to populate price of orders from most recent previous date when price was available. create table #orderinfo ( …
How to backfill data using SQL – populate missing values from historical data Read more »