--
--
--生成生成主菜单的插入SQL语句
--
--
use ECRM
go
declare @i int,
@strLevelMenu varchar(10),
@StrSuperMenu varchar(10),
@StrshowText varchar(30),
@BitEndMenu bit,
@IntShowSign int,
@StrRemarkMenu varchar(50)
1.定义游标,如下所示
DECLARE Insert_Cursor10 CURSOR FOR
SELECT LevelMenu,SuperMenu,showText,EndMenu,ShowSign,RemarkMenu FROM MainMenu ---换成你的表,对应的字段和变量也换成你的
OPEN Insert_Cursor10
set @i = 0
FETCH NEXT FROM Insert_Cursor10 into @StrLevelMenu,@StrSuperMenu,@StrshowText,@BitEndMenu,@IntShowSign,@StrRemarkMenu
WHILE @@FETCH_STATUS = 0
BEGIN
IF (@strLevelMenu IS NULL)
SET @strLevelMenu = 'NULL'
IF @StrSuperMenu IS NULL
SET @StrSuperMenu = 'NULL'
IF @StrshowText IS NULL
SET @StrshowText = 'NULL'
IF @BitEndMenu IS NULL
SET @BitEndMenu = 0
IF @IntShowSign IS NULL
SET @IntShowSign = 0
IF @StrRemarkMenu IS NULL
SET @StrRemarkMenu = 'NULL'
Print'INSERT INTO MainMenu(MenuID, LevelMenu, SuperMenu, showText, EndMenu, ShowSign, RemarkMenu)'+
' VALUES('+Str(@i,4)+','''+@StrLevelMenu+''','''+ @StrSuperMenu +''','''+@StrshowText+''','+Str( @BitEndMenu,1)+','+Str(@IntShowSign,4)+','''+@StrRemarkMenu+''')'
set @i = @i+1
FETCH NEXT FROM Insert_Cursor10 into @StrLevelMenu,@StrSuperMenu,@StrshowText,@BitEndMenu,@IntShowSign,@StrRemarkMenu
END
3.执行这个存储过程
4.把生成的结果保存成.sql文件(全是insert into ....)
5.接下来就不说了