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 […]
2006-11-16 (first published: 2004-09-30)
100 reads
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 […]
2004-09-17
277 reads
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
As we all know there is already a lot of information available about SQL...
As we all know there is already a lot of information available about SQL...
Comments posted to this topic are about the item Migrate the SSIS Catalog in...
hopefully a quick one This tsql SET IDENTITY_INSERT dbo.tblSCVMatchedv3 ON insert into dbo.tblSCVMatchedv3 select...
Hello Is there an equivalent for monitoring things like IO, reads, writes, ... produced...
Ask SSC