请billpu帮忙,那天你回答我的问题我已结帖,不过还是有点问题不太明白,请不吝赐教!!!
那天您回答我的问题给我的思路正是我想要的,但是还有有些不太明白,请不吝赐教。我想给我的数据库的表通过执行SQL脚本在服务器端插入10万条记录,我的这个数据表生成的SQL脚本如下:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Student_User]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Student_User]
GO
CREATE TABLE [dbo].[Student_User] (
[S_ID] [int] NOT NULL ,
[S_UserName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[S_PassWord] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[S_PWD_Question] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[S_PWD_Answer] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[S_Email] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[S_RealName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[S_Sex] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[S_Area] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[S_City] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[S_Postcode] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[S_Address] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[S_Tel] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[S_Mobile] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[S_CertifiType] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[S_CertifiNo] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[S_AddTime] [smalldatetime] NOT NULL ,
[S_LastLogin] [smalldatetime] NOT NULL ,
[S_State] [bit] NOT NULL ,
[S_Money] [money] NOT NULL
) ON [PRIMARY]
GO
其中,S_ID、S_UserName、S_PassWord、S_Email、S_AddTime、S_LastLogin、S_State、S_Money字段不能为空,我希望随机生成,谢谢。