Contents tagged with batch files

How many ways can we 'script' a stored proc or UDF from the command line?

Mar 26 2011No Comments by justin

Update: Added link to the scripts on github. If you've worked with SQL Server for any length of time, you've probably written some stored procedures and user defined functions. If you're like me, you've written many. Usually, when you edit a stored proc or UDF. you do it from Visual Studio or Sql Server Management Studio (SSMS). However, what if you want to script the sproc or udf from the command line? Well, there are quite a few ways to skin this cat, and I'll go through a few. Using sqlcmd …

Atlantis Interactive, batch files, Microsoft SQL Server, PowerShell Read more