急问。SQL语句~
效果是这样的。2个窗体中有2个DBgril连接了2个表。我想从B窗体的B表中选中一条记录中的某些字段添加到A窗体的A表中。这些字段的数据类型是一样的。不知道SQL的语句应该怎么写呢。
Delphi(Pascal) code:
query3.sql.text:='insert a (f1,f3,f8,...) values ('+query1.fieldbyname('f1').asstring+','+query1.fieldbyname('f3').asstring+','+query1.fieldbyname('f8').asstring+','...+')';
想想还是上张图
[IMG]http://image215.poco.cn/mypoco/myphoto/20091220/16/4529300320091220163135065.jpg[/IMG]
[IMG]http://image215.poco.cn/mypoco/myphoto/20091220/16/4529300320091220163102033.jpg[/IMG]
想把第一张表的内容弄到第二张表上。。我用的是ADOtable..
图1那个窗体的半拉子代码
unit frmJSD;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, Grids, DBGrids, DB, StdCtrls;
type
TJSDfrm = class(TForm)
DBGrid1: TDBGrid;
btadd: TButton;
btexit: TButton;
DataSourcemenu: TDataSource;
procedure FormActivate(Sender: TObject);
procedure btexitClick(Sender: TObject);
procedure btaddClick(Sender: TObject);
private
{ Private de
相关问答：
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'亿'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
为什么上一个用varchar转换后就只保留了� ......
clientserial devseral chunnelnum devdata5
CZ0001 308001 5000 11.1
CZ0001 308001 5001 11.2
CZ0001 308001 5002 11.3
CZ0001 3080 ......
CREATE PROCEDURE [selectvipcompany]
@username varchar(50),
@companyname varchar(50),
@endtime varchar(1)
AS
declare @sql varchar(1000)
set @sql='' ......
<table style="width: 1000px"><tr>
<td style="height: 38px; width: 35px;">
姓名</td>
......
