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: )

105 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

292 reads

Blogs

How To Restore Change Data Capture – CDC Tables When Restoring a SQL Server Database

By

I have recently had the privilege of working with multiple clients who have been...

KDA: Echoes of Deception - Onboarding

By

I’ll walk through the KDA UI and tackle the first challenge before diving into...

Kusto Detective Agency - Intro

By

While I mostly write about SQL Server, I have a soft spot for Kusto....

Read the latest Blogs

Forums

Meta AI by Facebook: A New Contender in the AI Battle

By Daniel Calbimonte

Comments posted to this topic are about the item Meta AI by Facebook: A...

Is SQL Server Feature Complete?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is SQL Server Feature Complete?

The Monitor Server

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Monitor Server

Visit the forum

Question of the Day

The Monitor Server

What does the monitor server do in log shipping?

See possible answers