Mark Clerget's Blog - Latest Comments on Dynamic T-SQL in Just Minutes!

Scott in response to: Dynamic T-SQL in Just Minutes!

Tue, 24 Jan 2006 21:30:30 +0000

Try www.sqlscripter.com to generate your scripts. This tool supports all commands (Insert+Update+Delete).
Its free of charge.

andrew krenitz in response to: Dynamic T-SQL in Just Minutes!

Wed, 24 Aug 2005 07:00:50 +0000

Hi,

How would you write the code to update a table.

sql = ‘update #table set’+@col+’= ‘+@var+’where colname =’+@val

exec sql

will this work ?

mclerget in response to: Dynamic T-SQL in Just Minutes!

Tue, 08 Feb 2005 08:27:27 +0000

Thanks David and Gregor for the positive feedback.

The purpose of this post was to give primer on the system tables as well as Dynamic SQL for novice to intermediate users. The next post should provide a solid tool for advanced users as well.

–Mark

David Walker in response to: Dynamic T-SQL in Just Minutes!

Mon, 07 Feb 2005 22:56:43 +0000

Great article!

Really looking forward to the next one though! As the previous commentor mentioned, the CREATE TABLE scripts are reasonably easy to come by. But a full script for INSERT is definitely going to be interesting to see!

Thanks again!

gregor suttie in response to: Dynamic T-SQL in Just Minutes!

Tue, 01 Feb 2005 18:50:24 +0000

If you press ctrl-c on a table or stored proc and then do ctrl-v into notepad or any other program such as query anaylser youll get the full create sql as well.

Cheers
Gregor