sql 代码调试

  begin 
	--开启事务
	begin tran 
		--插入
		INSERT INTO [DICTIONARY] (TablName,Column_Id,Column_Name)
		--数据源
		select o.name,c.column_id,c.name   
		from  sys.all_columns c inner  join  sys.objects o
		on c.object_id=o.object_id 
		where o.name='v_job'
		--查询  这里查询结果 检查是否正确 再考虑是否执行提交
		select * from [DICTIONARY] order by Id desc
	--提交事务
	commit
  end 

　　

转载于:https://www.cnblogs.com/liucai/p/4950151.html