自动创建具有多个列的SQL表 [英] creating a SQL table with multiple columns automatically
本文介绍了自动创建具有多个列的SQL表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
解决方案
至少可以生成 ALTER TABLE
脚本,然后运行这些脚本。
DECLARE @COUNTER INT = 1
WHILE @COUNTER< 10
BEGIN
PRINT'ALTER TABLE table_name ADD N'+ RIGHT('00'+ CONVERT(NVARCHAR(4),@COUNTER),2)+'bit'
SET @COUNTER + = 1
END
I must create an SQL table with 90+ fields, the majority of them are bit fields like N01, N02, N03 ... N89, N90 is there a fast way of creating multiple fileds or is it possible to have one single field to contain an array of values true/false? I need a solution that can also easily be queried.
解决方案
At least you can generate ALTER TABLE
scripts for bit fields, and then run those scripts.
DECLARE @COUNTER INT = 1
WHILE @COUNTER < 10
BEGIN
PRINT 'ALTER TABLE table_name ADD N' + RIGHT('00' + CONVERT(NVARCHAR(4), @COUNTER), 2) + ' bit'
SET @COUNTER += 1
END
这篇关于自动创建具有多个列的SQL表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文