<script type="text/javascript">function StorePage(){d=document;t=d.selection?(d.selection.type!='None'?d.selection.createRange().text:''):(d.getSelection?d.getSelection():'');void(keyit=window.open('http://www.365key.com/storeit.aspx?t='+escape(d.title)+'&u='+escape(d.location.href)+'&c='+escape(t),'keyit','scrollbars=no,width=475,height=575,left=75,top=20,status=no,resizable=yes'));keyit.focus();}</script>
declare @str varchar(8000)
declare @i int
set @i=1
while(@i<124)
begin
SELECT @str= 'INSERT INTO Menu(MenuName,MenuIds,ParentId,LinkUrl,Value) VALUES
( '+MenuName+', '' ' + MenuIds+ ' '', '' ' + cast(ParentId as varchar(50))+ ' '', '' ' +LinkUrl+ ' '', '' ' + Value+ ' '') ' FROM Menu where MenuId=@i
set @i=@i+1
print @str
end
里面的表 字段 自己可以替换。
declare @i int
set @i=1
while(@i<124)
begin
SELECT @str= 'INSERT INTO Menu(MenuName,MenuIds,ParentId,LinkUrl,Value) VALUES
( '+MenuName+', '' ' + MenuIds+ ' '', '' ' + cast(ParentId as varchar(50))+ ' '', '' ' +LinkUrl+ ' '', '' ' + Value+ ' '') ' FROM Menu where MenuId=@i
set @i=@i+1
print @str
end