SQL 向数据库中添加一列
USE [MySchool] GO IF COL_LENGTH('Student','Score') IS NULL BEGIN ALTER TABLE Student ADD Score DOUBLE END GO
COL_LENGTH判断表中是否含有列,比如此处判断Student表中是否含有Score
记录编程的点滴,体会学习的乐趣
USE [MySchool] GO IF COL_LENGTH('Student','Score') IS NULL BEGIN ALTER TABLE Student ADD Score DOUBLE END GO
COL_LENGTH判断表中是否含有列,比如此处判断Student表中是否含有Score