´úÂ뻹ÔÚÍêÉÆÖÐ
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t]
GO
CREATE TABLE [dbo].[t] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[lid] [nvarchar] (50) ,
[name] [nvarchar] (50) ,
[type] [int] NOT NULL
)
GO
insert into t (lid,[name],[type])
select "11","³ÇÕ¾»ð³µÕ¾",0
union all select "11","¿ûÏィ¹ú·¿Ú",0
union all select "11","²ËÊÐÇÅ",0
union all select "11","³±ÃùËÂÏï",0
union all select "11","±¦ÉÆÇލ¹ú·¿Ú",0
union all select "11","±¦ÉÆÇÅ",0
union all select "11","ÊÐÌåÓý¹Ý",0
union all select "11","ÎäÁֹ㳡",0
union all select "11","ÎäÁÖÃÅ",0
union all select "11","ÎäÁÖÃÇñRëó·¿Ú",0
union all select "11","°Ë×ÖÇÅ",0
union all select "11","Õã´óÎ÷ÏªÐ£Çø",0
union all select "11","Çì·á´å",0
union all select "11","½Ì¹¤Â·¿Ú",0
union all select "11","»¨Ô°ÐÅ´å",0
union all select "11","Õã½¹¤ÉÌ´óѧ",0
union all select "11","µç×ӿƼ¼´óѧ",0
union all select "11","´äÔ·ÐÅ´å",0
union all select "57","´ó¹ØÐ¡Çø",0
union all select "57","ͨÐÅÊг¡",0
union all select "57","µÂʤÐÅ´å",0
union all select "57","³±Íõ·¿Ú",0
union all select "57","³¯êÍÎåÇø",0
union all select "57","³¯êÍÈýÇø",0
union all select "57","Î÷ºþÎÄ»¯¹ã³¡¶«",0
union all select "57","ÎäÁֹ㳡",0
union all select "57","ÎäÁÖС¹ã³¡",0
union all select "57","°ëµÀºì",0
union all select "57","ÎÄÈý·¿Ú",0
union all select "57","ÉÏÄþÇÅ",0
union all select "57","»¨Ô°ÐÅ´å",0
union all select "57","Õã½¹¤ÉÌ´óѧ",0
union all select "57","ÎÄһ·¿Ú",0
union all select "57","½Ì¹¤Â·±±¿Ú",0
union all select "57","´ó¹ØÇÅÎ÷",0
union all select "57","ÉÏÌÁ·¿Ú",0
union all select "57","´ó¹ØÎ÷ÁùÔ·",0
union all select "57","Ïã»ýË·¿Ú",0
union all select "57","´ó¹ØÐ¡Çø",0
union all select "14","ÎäÁÖС¹ã³¡",0
union all select "14","²ý»¯ÐÅ´å",0
union all select "14","³¤ÊÙÇÅ",0
union all select "14","ÑÓ°²Â·¿Ú",0
union all select "14","Öдó¹ã³¡",0
union all select "14","ÖÚ°²ÇÅ",0
union all select "14","ÕãÒ»Ò½Ôº",0
union all select "14","´óѧ·±±¿Ú",0
union all select "14","Çì´ºÃÅ",0
union all select "14","½ðÑÃׯ",0
union all select "14","×ܹÜÌÁ",0
union all select "14","»ª¶«¼Ò¾ßÊг¡",0
union all select "14","½ü½´å",0
union all select "14","Æû³µÄÏÕ¾",0
union all select "14","Æû³µÄÏÕ¾",1
union all select "14","½ü½´å",1
union all select "14","»ª¶«¼Ò¾ßÊг¡",1
union all select "14","×ܹÜÌÁ",1
union all select "14","½ðÑÃׯ",1
union all select "14","Çì´ºÃÅ",1
union all select "14","´óѧ·±±¿Ú",1
union all select "14","ÕãÒ»Ò½Ôº",1
union all select "14","ÖÚ°²ÇÅ",1
union all select "14","Öдó¹ã³¡",1
union all select "14","ÑÓ°²Â·¿Ú",1
union all select "14","³¤ÊÙÇÅ",1
union all select "14","²ý»¯ÐÅ´å",1
union all select "14","ÎäÁÖС¹ã³¡",1
union all select "K105","»ð³µ¶«Õ¾",0
union all select "K105","Æû³µ¶«Õ¾",0
union all select "K105","ÑϼÒŪ",0
union all select "K105","¾°·¼ÎåÇø",0
union all select "K105","¾°Óù·¿Ú",0
union all select "K105","Çì´º¶«Â·",0
union all select "K105","²ÉºÉÐÅ´å",0
union all select "K105","¹ÛÒôÌÁÐ¡Çø",0
union all select "K105","×ܹÜÌÁ",0
union all select "K105","Õ¼ÒÇÅ",0
union all select "K105","Õã¶þÒ½Ôº",0
union all select "K105","¹ÙÏï¿Ú",0
union all select "K105","ºþ±õ",0
union all select "K105","ʤÀû¾çÔº",0
union all select "K105","º¢¶ùÏï",0
union all select "K105","ÑÓ°²ÐÅ´å",0
union all select "K105","ÎäÁÖС¹ã³¡",0
union all select "K105","º¼ÖÝ´óÏÃ",0
union all select "K105","Öб±ÇÅ",0
union all select "K105","Ê©¼ÒÇÅ",0
union all select "K105","½¨¹ú±±Â·ÎÄêÍ·¿Ú",0
union all select "K105","ÎÄêÍ´óÇŶ«",0
union all select "K105","»úÉñ´å",0
union all select "K105","Ìì³Ç·¿Ú",0
union all select "K105","ÐÅÌÁ·¿Ú",0
union all select "K105","»ð³µ¶«Õ¾",0
union all select "39","Õ¢¿Ú",0
union all select "39","Ë®³ÎÇÅ",0
union all select "39","º£ÔÂÇÅ",0
union all select "39","ÃÀÕþÇÅ",0
union all select "39","¸´ÐË·±±¿Ú",0
union all select "39","ÈýÀÈÃí",0
union all select "39","ãå²ÄÐÅ´å",0
union all select "39","¶þÁ¹Í¤",0
union all select "39","Íû½ÃÅÍâ",0
union all select "39","Æû³µÄÏÕ¾",0
union all select "39","½ü½´å",0
union all select "39","»ª¶«¼Ò¾ßÊг¡",0
union all select "39","×ܹÜÌÁ",0
union all select "39","³ÇÕ¾»ð³µÕ¾",0
union all select "K101","³ÇÕ¾»ð³µÕ¾",0
union all select "K101","×ܹÜÌÁ",0
union all select "K101","¹ÛÒôÌÁÐ¡Çø",0
union all select "K101","²ÉºÉÐÅ´å",0
union all select "K101","ºìÁâÐÅ´å",0
union all select "K101","·ïÆð¶«Â·¿Ú",0
union all select "K101","Ë«Áâ·±±¿Ú",0
union all select "K101","Êкì»áÒ½Ôº",0
union all select "K101","½¨¹ú·¿Ú",0
union all select "K101","ÐÅ»ªÂ·¿Ú",0
union all select "K101","Öб±Â·¿Ú",0
union all select "K101","ÑÓ°²Â·¿Ú",0
union all select "K101","Õã´óºþ±õÐ£Çø",0
union all select "K101","²ý»¯ÐÅ´å",0
union all select "K101","Êи®´óÂ¥",0
[1] [2] ÏÂÒ»Ò³