Technical Article

Last_Date_Of_Month

Get the Last date of the month for the given month and year In response to a post By: Anonymous - Posted: 2/16/2004 3:31:12 AM (Stored Procedure).... Thought that there should be a more efficient / functional way of doing this. And here it is. Of course, a function would probably be more efficient, and […]

You rated this post out of 5. Change rating

2006-11-16 (first published: )

101 reads

Technical Article

Process XML against XSL template and save output

Given SQL text (@sql_txt) that will return XML data, run that XML data against an XSL template (@xsl_file_nm), and save the output to the specified outputfile (@out_file_nm). If @xsl_file_nm is not specified, then output is just saved as XML.This script is very usefull, but not secure. One could easily overload any of the script input […]

You rated this post out of 5. Change rating

2004-09-17

281 reads

Blogs

New Pluralsight Course - Certified Kubernetes Administrator - Performing Cluster Version Upgrades

By

We’re working through the major refresh of my Certified Kubernetes Administrator series at Pluralsight! The...

What I actually do at Microsoft

By

I started working at Microsoft in January 2022. I enjoy it. I even wrote...

Talkie - a simple, private, responsive interface for LLMs

By

Watch this video on YouTube I like using ChatGPT. But I don't like the $20/month...

Read the latest Blogs

Forums

Strange behavior passing a variable in XML.value

By PatLap

Hi,  anyone would know why as soon as I add a WHERE statement (even...

What happened to my SSMS shortcuts in 20.1?

By Eric Mamet

I installed SSMS 20.1 and all my trusted keyboard shortcuts don't work anymore... <Ctrl>E...

logshipping is out of synch need to debug

By anoop.mig29

Hi We have logshipping which get out of synch in night due to purging...

Visit the forum

Question of the Day

Operator Precedence Order

What is the correct order of operator precedence from highest (evaluated first) to lowest?

See possible answers