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

102 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

A New Word: Opia

By

opia – n. the ambiguous intensity of eye contact The entry for this says...

Friday Flyway Tips: Searching a Migration

By

This was actually a cool tip I saw internally from one of the product...

Build Recovery into the Design

By

It's like disaster recovery (and business continuity) planning is the end-of-term research paper that...

Read the latest Blogs

Forums

sqlclient data provider .net provider connection

By jaango123

I have a task to check the connection managers as part of ssis integration...

How

By cw255

Hi, wondering if someone can help me. We're trying to build an application that...

Log Backup failed on Secondary Replica

By aroojsql

I have a scenario where log backup is getting failed in Secondary replica on...

Visit the forum

Question of the Day

Statistics Histograms

I have a statistics objects with 2 key columns from my tables. How many histograms and their type are stored?

See possible answers