04 2013 档案
摘要：IF EXISTS(SELECT * FROM SYSOBJECTS WHERE NAME = 'StuWebName')DROP TABLE StuWebNameGOCREATE TABLE StuWebName(StuId INT IDENTITY(1,1) PRIMARY KEY,StuName VARCHAR(50) NOT NULL,StuPassword VARCHAR(50) NOT NULL,StuSex CHAR(2) DEFAULT('男'),StuNo INT NOT NULL)GODECLARE @ID INTSET @ID=1WHILE
阅读全文
摘要：//一般情况下我们会这么删除 DataTable dt = new DataTable(); for (int i = 0; i < dt.Rows.Count; i++) { if (99 % i == 0) { dt.Rows.RemoveAt(i); } } //但是这么删除会出现...
阅读全文
摘要：USE SilverlightDemo--SilverlightDemo为你所在的数据库GOselect b.[name] '表名',max(a.rowcnt) '记录数' from sysindexes a join sys.objects b on b.object_id=a.id where b.type='U' group by b.[name]
阅读全文
