for循环的使用之批量生成SQL

#!/bin/bash

echo ----------------------2022---------------------------------------
for ((i=202201; i<=202212; i++))
do
echo ALTER DATABASE database_name ADD FILEGROUP FG_Sales_$i";"
echo ALTER DATABASE database_name ADD FILE \(NAME = N\'SalesData_$i\', FILENAME = N\'E:\\SQLDATA\\DATA\\SalesData_$i.ndf\'\) TO FILEGROUP FG_Sales_$i";"
done