This post is not about SQL Server but WordPress. As many of you know that I host SQLAuthority.com on self hosted Wordpress. This blog is powered by PHP and MySQL and hosted on an Apache Server.
In the month of January, I had offered a unique offering for training – “SQL Server Performance Tuning Practical Workshop”. I was initially planning to offer this for one month, however the response for this training was so much that I had to extend it for the entire first quarter. At this point of time, I am still delivering 2-3 classes every week as the training is extremely popular.
In versions prior to 2012, you need to use the CONVERT function with different styles to convert the date values into a different format. Let us learn about the FORMAT function in this blog post.
Question: How to Add Column at Specific Location in Table?
Answer: Order of the column in the table should not matter.