一个数据表里面有N多字段，当硬编码写 插入、更新数据表的SQL语句时(例如以下的插入语句：string MySql = "insert into HeTongXinXi(HeTongBianHao,HeTongFenLei,HeTongFenLeiID,HeTongMingCheng,XiangMuMingChen,XiangMuMingChenID,JiaFangDanWei,JiaFangDanWeiQianZiRen,YiFangDanWei,YiFangDanWeiQianZiRen,BingFangDanWei,BingFangDanWeiQianZiRen,XingChengFangShi,JingBanBuMen,JingBanRen,HeTongZaoJia,QianYueRiQi,ZaoJiaXingZhi,HeTongXingZhi,CunDangRiQi,ZhuHeTongBianHao,HeTongJieSuanZhuangTai,ShiFouXuNiHeTong,YingDaiZiJinE,DaiZiBiLi,ZuiHouHuanKuanRiQi,KaiGongRiQi,HeTongYanShouRiQi,ShiJiYanShouRiQi,BaoXiuJinE,BaoXiuQiXian,LuYueBaoZhengJin,FuKuanFangShiTiaoKuan,YanShouJieSuanTiaoKuan,LuYueBeiZhu)"
+ " values (@HeTongBianHao,@HeTongFenLei,@HeTongFenLeiID,@HeTongMingCheng,@XiangMuMingChen,@XiangMuMingChenID,@JiaFangDanWei,@JiaFangDanWeiQianZiRen,@YiFangDanWei,@YiFangDanWeiQianZiRen,@BingFangDanWei,@BingFangDanWeiQianZiRen,@XingChengFangShi,@JingBanBuMen,@JingBanRen,@HeTongZaoJia,@QianYueRiQi,@ZaoJiaXingZhi,@HeTongXingZhi,@CunDangRiQi,@ZhuHeTongBianHao,@HeTongJieSuanZhuangTai,@ShiFouXuNiHeTong,@YingDaiZiJinE,@DaiZiBiLi,@ZuiHouHuanKuanRiQi,@KaiGongRiQi,@HeTongYanShouRiQi,@ShiJiYanShouRiQi,@BaoXiuJinE,@BaoXiuQiXian,@LuYueBaoZhengJin,@FuKuanFangShiTiaoKuan,@YanShouJieSuanTiaoKuan,@LuYueBeiZhu)";)
写起来很费劲，能不能有这样的可视化界面，勾选需要的数据表字段后，能自动生成插入、更新数据表的SQL语句？

SQL Server里面可以实现,你可以先设计好再用

具体如何操作吗？请老大截个图片出来让我们学习一下吧……

查询分析器中可以这样做,然后替换一下.我也不知道怎样实现了,不好意思啊

INSERT INTO [***].[***].[***]([HeTongID], [HeTongMingCheng], [HeTongBianHao], [XiangMuMingChenID], [XiangMuMingChen], [HeTongFenLeiID], [HeTongFenLei], [JiaFangDanWei], [JiaFangDanWeiQianZiRen], [YiFangDanWei], [YiFangDanWeiQianZiRen], [BingFangDanWei], [BingFangDanWeiQianZiRen], [XingChengFangShi], [JingBanBuMen], [JingBanRen], [HeTongZaoJia], [QianYueRiQi], [ZaoJiaXingZhi], [HeTongXingZhi], [CunDangRiQi], [HeTongJieSuanZhuangTai], [ZhuHeTongBianHao], [ShiFouXuNiHeTong], [YingDaiZiJinE], [DaiZiBiLi], [ZuiHouHuanKuanRiQi], [KaiGongRiQi], [HeTongYanShouRiQi], [ShiJiYanShouRiQi], [BaoXiuJinE], [BaoXiuQiXian], [LuYueBaoZhengJin], [FuKuanFangShiTiaoKuan], [YanShouJieSuanTiaoKuan], [LuYueBeiZhu], [jhsqrq], [sjsqrq], [bz1], [jhkcrq], [sjkcrq], [bz2], [sszj], [yjjszj], [ysrq], [jsyy], [bz4])
VALUES(<HeTongID,int,>, <HeTongMingCheng,nvarchar(255),>, <HeTongBianHao,nvarchar(150),>, <XiangMuMingChenID,nvarchar(50),>, <XiangMuMingChen,nvarchar(255),>, <HeTongFenLeiID,nvarchar(50),>, <HeTongFenLei,nvarchar(255),>, <JiaFangDanWei,nvarchar(100),>, <JiaFangDanWeiQianZiRen,nvarchar(50),>, <YiFangDanWei,varchar(100),>, <YiFangDanWeiQianZiRen,nvarchar(50),>, <BingFangDanWei,nvarchar(100),>, <BingFangDanWeiQianZiRen,nvarchar(50),>, <XingChengFangShi,nvarchar(20),>, <JingBanBuMen,nvarchar(50),>, <JingBanRen,nvarchar(50),>, <HeTongZaoJia,float,>, <QianYueRiQi,smalldatetime,>, <ZaoJiaXingZhi,nvarchar(50),>, <HeTongXingZhi,nvarchar(50),>, <CunDangRiQi,smalldatetime,>, <HeTongJieSuanZhuangTai,nvarchar(10),>, <ZhuHeTongBianHao,nvarchar(80),>, <ShiFouXuNiHeTong,bit,>, <YingDaiZiJinE,float,>, <DaiZiBiLi,float,>, <ZuiHouHuanKuanRiQi,smalldatetime,>, <KaiGongRiQi,smalldatetime,>, <HeTongYanShouRiQi,smalldatetime,>, <ShiJiYanShouRiQi,smalldatetime,>, <BaoXiuJinE,float,>, <BaoXiuQiXian,nvarchar(50),>, <LuYueBaoZhengJin,float,>, <FuKuanFangShiTiaoKuan,nvarchar(1024),>, <YanShouJieSuanTiaoKuan,nvarchar(1024),>, <LuYueBeiZhu,nvarchar(1024),>, <jhsqrq,nvarchar(100),>, <sjsqrq,nvarchar(255),>, <bz1,nvarchar(255),>, <jhkcrq,nvarchar(100),>, <sjkcrq,nvarchar(100),>, <bz2,nvarchar(255),>, <sszj,float,>, <yjjszj,float,>, <ysrq,nvarchar(50),>, <jsyy,nvarchar(50),>, <bz4,nvarchar(255),>)

谢谢 bygg!但这样的脚本并不是 INSERT INTO 数据表(字段1，字段2……) values (@字段1，@字段2……) 形式的……

我也不知道怎样实现了,不好意思

用进行插入操作呢？不是可以生成SQL语句吗？

具体是如何操作的啊？