I am continuing putting some common examples of operations for Microsoft SQL Server. In addition to some of the Date related code snippets published before, there are few more today: — Last 90 days: select DATEADD(day, -90, GETDATE()) — Get Date portion of DateTime value select DATEADD(d, 0, DATEDIFF(d, 0, Read more…
Is SQL Server Collation setting your enemy or your friend? How to change server default collation? In general, it is your friend, it will help SQL Server to figure out how to store character strings in different locale. It becomes even more important when data you are storing goes beyond Read more…
Last time we have seen how to manipulate text files from SQL Server code using Scripting object. This time we would look at “Read File As Table” operation from a different angle – using BULK INSERT operation. There are pros and cons in this approach. Lets look at them. Advantages: Getting Read more…
Writing a log, dumping data, looking for file to be used in Bulk insert…
There are many situations when you would want to have access to files from inside your SQL code on Microsoft SQL Server.
Did you know that you actually can do this? No? Check below for code snippets to perform various operations on files. It is presented in form of the functions but you are actually not limited to that
Prerequisites and assumptions
Check if file exists
(more…)
Did you ever faced a situation when you need quickly calculate some boundaries of the Date value like First Day of the month, Last Day of the month, etc… in T-SQL? Colegue of mine asked me this question… WOW! What do you know… It is actually very easy if we think Read more…
Over past several years Microsoft SQL Server became primary database platform for me when it comes to Windows Development. Why am I so specific? When it comes to Web development and it is not ASP.Net related, then MySQL is THE engine for me. Just to be fair, I should also mention Interbase, DB2, Read more…