如何才能实现通过可视化界面操作将自动生成插入、更新数据表的SQL语句？ - 编程论坛

#2

bygg2007-09-24 10:57

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

#3

foshan2007-09-24 12:49

以下是引用bygg在2007-9-24 10:57:30的发言：
SQL Server里面可以实现,你可以先设计好再用

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

#4

bygg2007-09-24 13:27

只有本站会员才能查看附件，请登录

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

#5

foshan2007-09-24 17:16

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),>)

#6

foshan2007-09-24 17:18

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

#7

bygg2007-09-24 19:48

以下是引用foshan在2007-9-24 17:18:37的发言：

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

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

#8

yms1232007-09-24 19:53

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

#9

foshan2007-09-25 08:25

以下是引用yms123在2007-9-24 19:53:18的发言：
用ADO.NET进行插入操作呢？ADO.NET不是可以生成SQL语句吗？

具体是如何操作的啊？