There was an error while loading. Please reload this page. This script wil automate the T-SQL backup flow utilizing snapshots on FSx for ONTAP filesystem and TSQL ...
This repo is a collection of T-SQL scripts I wrote while supporting SQL Server 2008 through 2016. Most are simply quality of life functions, while others such as my availability group SQL agent job ...
this will return: "(1 row(s) affected)" But now I need to know, what data was actually inserted? SQL Server has answered this question in 2005 with the OUTPUT statement: This will return a dataset ...
I have a weird issue (well weird to me).<BR><BR>I'm using SSSRS and I'm using multivalued parms so people can select multiple values to pass for a single parameter. (i.e. EntryTypeId and they get a ...
In this third in a series on working smarter with T-SQL, let's give the built-in sp_executesql stored proc a go. In my previous posts, I've described some methods for generating and executing T-SQL ...
Though businesses typically use Microsoft's SQL Server for mundane items such as customer names, addresses and sales amounts, you can also store entire PDFs in a database record. Data items called ...
Working with dynamic SQL is all well and good, but avoid the risks that can lead to your code being susceptible to a SQL injection attack. As much as making your T-SQL work smarter for you, a la ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results