开发者

Generating script for subset of the data

开发者 https://www.devze.com 2023-04-02 12:04 出处:网络
Is there a way I can use Generate and Publish Scripts to generate 开发者_高级运维INSERTs for a subset of my data, e.g., requested > \'2011-09-01\' where requested is a field in my table?You could cons

Is there a way I can use Generate and Publish Scripts to generate 开发者_高级运维INSERTs for a subset of my data, e.g., requested > '2011-09-01' where requested is a field in my table?


You could consider the venerable sp_generate_inserts, which allows you to specify a filter condition using the @from parameter. The original version can be found at http://vyaskn.tripod.com/code/generate_inserts.txt, although it's not without (minor) bugs, there might be a better version of this by now, although I haven't come across one.

0

精彩评论

暂无评论...
验证码 换一张
取 消