sql我用语句创建数据库,想同时创建表,提示这样的错误答:Date"文件夹,再执行SQL.方法2.直接创建在D盘。SQL如下:CREATE DATABASE xsgl ON PRIMARY (NAME='xsgl',FILENAME='D:\xsgl.mdf',SIZE=10MB,MAXSIZE=UNLIMITED,FILEGROWTH=1MB)LOG ON (NAME='xsgl_log',FILENAME='D:\xsgl_log.ldf',SIZE=1MB,MAXSIZE=UNLIMITED,FILEGROWTH=10%)GO ...
sql数据库一个表定时改名字并创建一个新表答:declare @tbName varchar(100),@sql varchar(2000),@date datetime select @tbName = convert(varchar(10),getdate(),120)select @tbName = substring(@tbName,1,4)+substring(@tbName,6,2)+substring(@tbName,9,2)select @sql='select * into syslogd_'+@tbName+' from syslogd'exec(@...
Test数据库中,用T-SQL语句创建员工工资表,各列的要求如 下表所示答:CREATE TABLE dbo.员工工资(No int NOT NULL IDENTITY (1, 1),Xm varchar(30) NOT NULL,Gz decimal(8, 2) NOT NULL,YwJj decimal(8, 2) NOT NULL,Sds decimal(8, 2) NOT NULL,SfGz AS Gz+YwJj-Sds) ON [PRIMARY]GODECLARE @v sql_variant SET @v = N'员工工资'EXECUTE sp_...