if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tver]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tver]
GO
--表 tver 的结构
 CREATE TABLE tver(fid int IDENTITY (1, 1) not null,fbid varchar(255) not null,fver varchar(255) null PRIMARY KEY (fid))

--表 tver 的结构说明 注：在GO后需要重新定义变量，字段名和字段说明的个数要相同，不加说明的不要添加到字段清单中，最后要加个,用于结束。
declare @vD varchar(50),@vT varchar(50),@vT2 varchar(50),@vTc varchar(800),@vTr varchar(800)
set @vD='tver'
set @vTc='fid,fbid,fver,'
set @vTr=',,,'
while charindex(',',@vTc)<>0 begin
 set @vT=left(@vTr,charindex(',',@vTr)-1)
 set @vT2=left(@vTc,charindex(',',@vTc)-1)
 EXECUTE sp_addextendedproperty N'MS_Description', @vT, N'user', N'dbo', N'table', @vD, N'column', @vT2
 set @vTc=right(@vTc,len(@vTc)-charindex(',',@vTc))
 set @vTr=right(@vTr,len(@vTr)-charindex(',',@vTr)) end

--表 tver 的数据
  SET IDENTITY_INSERT tver ON
 insert into tver(fid,fbid,fver) Values(1,'693EA1D1-E341-42DC-995C-A2005708BDAF','   3640335')
 insert into tver(fid,fbid,fver) Values(2,'FF252386-B41C-46D7-8123-A2C2578E0F8C','   2419264')
 insert into tver(fid,fbid,fver) Values(3,'5C01C3EF-EBE3-4970-AA06-5EB5A1DA61EA','   1219676')
 insert into tver(fid,fbid,fver) Values(4,'A1990079-1A0D-41A3-8CCA-1EAF35F9E6DF','   3614049')
 insert into tver(fid,fbid,fver) Values(5,'02C70A6F-B96E-410C-8240-4D38E78E5AD4','   3807837')
 insert into tver(fid,fbid,fver) Values(6,'160EBF9C-8BA1-4B2C-BD39-FE634ECEAC4D','   3469447')
 insert into tver(fid,fbid,fver) Values(7,'1AF46459-D0D3-4186-96FB-3A165A2F48B6','   9251695')
 insert into tver(fid,fbid,fver) Values(8,'B4512265-CBED-4DF6-AEEC-9F8A97F07ADE','   7801641')
 insert into tver(fid,fbid,fver) Values(9,'4F7AC70F-E70C-457C-9130-9A89857EC500','   2306599')
 insert into tver(fid,fbid,fver) Values(10,'A9D29B1E-01F6-4A3B-951E-1050E44A2345','   2382036')
 insert into tver(fid,fbid,fver) Values(11,'AEC45CFD-15A2-453B-A485-1E6DE9CA0C3F','   8624035')
 insert into tver(fid,fbid,fver) Values(12,'DFD023F3-4DE9-4144-B6FE-820F1E4C6676','   1927760')
 insert into tver(fid,fbid,fver) Values(13,'02D2A1BD-90F7-406B-AACF-6EA3EDF580CC','   7006431')
 insert into tver(fid,fbid,fver) Values(14,'2CC436AC-0B40-42FE-ACF8-266EC241ED15','   6709052')
 insert into tver(fid,fbid,fver) Values(15,'FE8CFE97-6C11-47E1-82EF-1A2DE02A3805','   1815794')
 insert into tver(fid,fbid,fver) Values(16,'1F35C5C2-2806-44C6-BB86-676016D6D250','   9936937')
 insert into tver(fid,fbid,fver) Values(17,'247B489A-0911-497C-A3B7-7088CD6B2C4F','   3248861')
 insert into tver(fid,fbid,fver) Values(18,'FEEB012D-6832-4DC1-9726-9892C52E776D','    294008')
 insert into tver(fid,fbid,fver) Values(19,'19088CCF-2A09-401A-84ED-14986B4A050B','   3729309')
 insert into tver(fid,fbid,fver) Values(20,'5ADB77F1-8CC9-4A5F-B16F-46D8D5BB8170','   1816556')
 insert into tver(fid,fbid,fver) Values(21,'3C41D624-3FBC-4649-B41F-08B8038D5E24','   5550318')
 insert into tver(fid,fbid,fver) Values(22,'39B48CC9-6CC8-4A40-8AEF-A2A1409DFDC0','   2753961')
 insert into tver(fid,fbid,fver) Values(23,'679EDD0B-C06D-4414-ADE9-4EA93986AED3','   7264993')
 insert into tver(fid,fbid,fver) Values(24,'1F3C90D1-6AAC-4E4D-82D2-B966188D71C8','   8424496')
 insert into tver(fid,fbid,fver) Values(25,'F2380172-D7E0-4B7C-BEC8-68D36C82CF06','   5248083')
 insert into tver(fid,fbid,fver) Values(26,'FC7D0B8C-AE00-4835-A537-04F5FED20B48','    760302')
 insert into tver(fid,fbid,fver) Values(27,'ADAB96A5-5B81-45AF-8133-6A4259ED3577','     16199')
 insert into tver(fid,fbid,fver) Values(28,'C9867547-F7C1-4BE9-9C8E-6720520E2949','   4414405')
 insert into tver(fid,fbid,fver) Values(29,'5081C103-37D9-47A3-BCD9-CEE9A2AECA25','   4843483')
 insert into tver(fid,fbid,fver) Values(30,'4BA62E71-9729-40B2-9D99-47E5F161304C','   9744279')
 insert into tver(fid,fbid,fver) Values(31,'2FB5521B-4C77-4F4D-9DA0-A9B2E5843AF1','   8689058')
 insert into tver(fid,fbid,fver) Values(32,'E9CB961E-9E3C-4F9E-B9E4-EE0BF78D3B76','   1533752')
 insert into tver(fid,fbid,fver) Values(33,'F6364B50-5F39-430B-A8F8-04A5AD25B819','   5857323')
 insert into tver(fid,fbid,fver) Values(34,'3FC9069D-9E49-42A4-AE4E-83741F1136B4','   1200493')
 insert into tver(fid,fbid,fver) Values(35,'61512F23-EFAB-4659-86C6-B049B52E3B16','   5300968')
 insert into tver(fid,fbid,fver) Values(36,'8B5E893A-83B2-4239-80C8-4BE4EC87C2FC','   6974908')
 insert into tver(fid,fbid,fver) Values(37,'9BA7D4A4-2F10-42EF-9D95-B88494225FBB','   2450484')
 insert into tver(fid,fbid,fver) Values(38,'5B0D3776-7323-4C92-8F93-27FEE311DC55','   5933235')
 insert into tver(fid,fbid,fver) Values(39,'A8C4B0A6-130F-4DF5-B55D-65EEDFCE0F78','   6482380')
 insert into tver(fid,fbid,fver) Values(40,'F08A7092-BE70-47E0-A047-E46867F128F5','   9187209')
 insert into tver(fid,fbid,fver) Values(41,'CAA7F7D2-1B68-4E65-A67C-30AF44325A2C','   9958981')
 insert into tver(fid,fbid,fver) Values(42,'C35CD924-959D-487F-89B0-BCD339F970AC','   7459706')
 insert into tver(fid,fbid,fver) Values(43,'4954A104-CADF-4B01-AB18-223D555A9C6C','   3399841')
 insert into tver(fid,fbid,fver) Values(44,'A1144A1F-9306-4568-9658-586566547687','   6283607')
 insert into tver(fid,fbid,fver) Values(45,'1794C5C6-B3D6-4499-830C-32E668858EF2','   7106810')
 insert into tver(fid,fbid,fver) Values(46,'25E0FDF3-1FA5-447C-A437-88A504BB2992','   4995145')
 insert into tver(fid,fbid,fver) Values(47,'2FEC06A4-B6F4-45AB-9B09-8D8148A66D0C','   1495977')
 insert into tver(fid,fbid,fver) Values(48,'0DF1A511-5683-47C9-9732-2CA92B1B4F9D','   3152852')
 insert into tver(fid,fbid,fver) Values(49,'E63CD638-CD88-45FB-A3EA-17A034CCCDA3','   9552394')
 insert into tver(fid,fbid,fver) Values(50,'45E1CFA2-3672-41A0-A980-D87F90B54676','   8955776')
 insert into tver(fid,fbid,fver) Values(51,'3F4A8F98-1168-452F-9555-2C4F286209EE','   6319111')
 insert into tver(fid,fbid,fver) Values(52,'3C005C57-B2FC-41F6-B0EB-33693E4A780F','   6053745')
 insert into tver(fid,fbid,fver) Values(53,'A27982CF-2231-419A-A881-D6D3AB12C407','   2126985')
 insert into tver(fid,fbid,fver) Values(54,'3FF07E9E-8FF0-4205-B9A2-410997D1BCED','   5580235')
 insert into tver(fid,fbid,fver) Values(55,'35306915-B3CD-4D9D-9E61-D344577335E8','   5512475')
 insert into tver(fid,fbid,fver) Values(56,'44445E8E-3A5C-4067-BF21-8DC41FD21401','   4010577')
 insert into tver(fid,fbid,fver) Values(57,'C0555465-806B-4F2A-BBB4-C23000735EBF','   1147197')
 insert into tver(fid,fbid,fver) Values(58,'314C12C3-0386-402C-902A-21779E7C10CE','   1002934')
 insert into tver(fid,fbid,fver) Values(59,'6AFBC638-1239-42AD-B97B-277C14336849','   9745852')
 insert into tver(fid,fbid,fver) Values(60,'E4E96484-B6FE-422F-9028-D0F66C4197F1','   1024200')
 insert into tver(fid,fbid,fver) Values(61,'0F93BF81-6204-4021-AA69-E82AB73AF3F5','   5318651')
 insert into tver(fid,fbid,fver) Values(62,'2487270A-C407-4A33-9825-DC924C02E3E2','   5642585')
 insert into tver(fid,fbid,fver) Values(63,'56A7615D-7C22-484D-9E78-913CBB14336D','   2720400')
 insert into tver(fid,fbid,fver) Values(64,'E505C66B-DD7F-422D-89E4-7D0160BE53F7','   8142734')
 insert into tver(fid,fbid,fver) Values(65,'F6842B7F-88ED-4529-BA25-CC582459D486','    868314')
 insert into tver(fid,fbid,fver) Values(66,'0A19957D-8D1E-45EF-9BFE-5BE98CDA877A','   4247324')
 insert into tver(fid,fbid,fver) Values(67,'9D7AC9A1-5522-403F-BAC0-DD01CDA88D1A','   8638011')
 insert into tver(fid,fbid,fver) Values(68,'7C781866-7C0E-414E-A213-4CB529F22F42','   1527220')
 insert into tver(fid,fbid,fver) Values(69,'52128484-3D71-4E9B-8288-D6C27D70E922','   3442793')
 insert into tver(fid,fbid,fver) Values(70,'2AC74AFA-DC87-4565-B434-8948526EC0A8','   7897543')
 insert into tver(fid,fbid,fver) Values(71,'40E90795-B9DE-4EEF-AB20-5558FC685E53','   4576947')
 insert into tver(fid,fbid,fver) Values(72,'AEA7FAF4-EDD9-4DFA-8B1E-8774D4967832','    436838')
 insert into tver(fid,fbid,fver) Values(73,'F69CF02E-6C8C-4BA9-8B66-284C872E3E8E','   4857857')
 insert into tver(fid,fbid,fver) Values(74,'EEFB299A-1ED7-4841-B97A-13C1738536D5','   4926319')
 insert into tver(fid,fbid,fver) Values(75,'2D9F7CE4-16D6-49F2-8BCF-5451A8CAF41F','   8163016')
 insert into tver(fid,fbid,fver) Values(76,'9B91F398-D1C5-48A6-95B2-A9806D423ED5','   5590231')
 insert into tver(fid,fbid,fver) Values(77,'03AC96AB-F26D-43A7-B393-1919E0EA22D0','   3517560')
 insert into tver(fid,fbid,fver) Values(78,'F4A7D55C-756B-4FBC-A82E-BA7358699492','   7017215')
 insert into tver(fid,fbid,fver) Values(79,'E0CC4206-3FA6-48E0-BD29-501829F10721','   2741558')
 insert into tver(fid,fbid,fver) Values(80,'F47F4D88-8619-4D00-A828-BBCFC32C25E1','     59071')
 insert into tver(fid,fbid,fver) Values(81,'36EE05A8-31CA-46ED-BDCA-12E53C1C86DF','   9223572')
 insert into tver(fid,fbid,fver) Values(82,'4518ADAD-5152-49F5-98D1-A4676D4751AD','   7151083')
 insert into tver(fid,fbid,fver) Values(83,'D3323B54-F936-45BB-81F8-B5DE8371FF86','   4817338')
 insert into tver(fid,fbid,fver) Values(84,'D2221B50-3C91-4D8C-87A4-CB5E6F29F301','   5776992')
 insert into tver(fid,fbid,fver) Values(85,'FDB955DD-B6C8-41BE-98D0-87FBC997AF52','   7342304')
 insert into tver(fid,fbid,fver) Values(86,'000BB804-2557-4928-9903-526C5FD6EF21','   1407426')
 insert into tver(fid,fbid,fver) Values(87,'0632ADBA-458A-4698-A667-E66F35D8E98E','    507363')
 insert into tver(fid,fbid,fver) Values(88,'05A2C2C3-D5E4-472A-B1D1-9FE77A3CE8F0','   1137274')
 insert into tver(fid,fbid,fver) Values(89,'A31ADBDC-FC83-468C-9050-75B1D1331CC3','   7090254')
 insert into tver(fid,fbid,fver) Values(90,'034E9F89-31AC-4718-990B-C866439B9912','   7480998')
 insert into tver(fid,fbid,fver) Values(91,'E4CB824A-4DF0-4BFF-A43F-7F8023096349','   7947511')
 insert into tver(fid,fbid,fver) Values(92,'06D5C7BB-5968-4E5B-9517-37DAD9ABFBBD','     39075')
 insert into tver(fid,fbid,fver) Values(93,'2FA3625B-57C6-4D64-A8D8-F604807519BF','   8984992')
 insert into tver(fid,fbid,fver) Values(94,'ABBBBF4D-E464-4409-A885-129362B8F47D','    937722')
 insert into tver(fid,fbid,fver) Values(95,'649BFA6A-D69F-474B-908B-DC518E2B57BA','   7897271')
 insert into tver(fid,fbid,fver) Values(96,'13B7BC7A-828B-4B30-A9EA-8748B0F4AF52','   9124931')
 insert into tver(fid,fbid,fver) Values(97,'EDE3B82E-F1D9-4D09-BBF3-DD684994F24B','    184586')
 insert into tver(fid,fbid,fver) Values(98,'E951D2D8-B3A0-44E2-BE63-5824284423C5','   2025455')
 insert into tver(fid,fbid,fver) Values(99,'CCC1EA40-4F76-4D9B-ABD9-3A67FD0418BB','   4087225')
  SET IDENTITY_INSERT tver OFF

--表 tver 的索引
 CREATE  INDEX [fbid_index] ON [tver]([fbid]) ON [PRIMARY]
GO

