SQL Server中语句的自动参数化
use mastergo if exists(select * from sys.databases where name = 'test') drop database testgo --创建数据库create database test if exists(select * from sys.tables where name = 't') drop table tgo --1.创建表tcreate table t(i int); --2.添加100000条记录,消耗56秒declare @i int;declare @sql varchar(1000); set @i = 1set @sql = ''; while @i
页:
[1]