with adoquery do begin close; sql.text:='CREATE TABLE jobs ( job_id smallint IDENTITY(1,1) PRIMARY KEY CLUSTERED, min_lvl tinyint NOT NULL, max_lvl tinyint NOT NULL)'; execsql end;
esu的语句本来就是在运行期创建呀
to esu: 1.为什么在begin后面有个close呢? 2.IDENTITY(1,1),execsql分别什么意思?谢谢!!!
begin
close;
sql.text:='CREATE TABLE jobs
(
job_id smallint
IDENTITY(1,1)
PRIMARY KEY CLUSTERED,
min_lvl tinyint NOT NULL, max_lvl tinyint NOT NULL)';
execsql
end;
1.为什么在begin后面有个close呢?
2.IDENTITY(1,1),execsql分别什么意思?谢谢!!!
然后再open
execsql就是执行上面所写的sql