sql语句判断 SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Table_1]') AND type in (N'U')
我建的表名是lsxl,我笨呀,请以我的表名写一个SQL语句判断,我谢谢你.
sql语句判断 SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[lsxl]') AND type in (N'U')
我的临时表LSXL已经建立完后用你写sql语句判断可以吗? SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[lsxl]') AND type in (N'U')用IF THEN如何判断它的值.(最好写出语句)
再添加一个ADOQuery把sql语句添加进去,根据ADOQuery执行这个语句的结果来判断表lsxl是否存在再者,这条语句是SQL Server中的,如果是Access则不同 SELECT * FROM [MSysObjects] where Name = 'lsxl' and Type = 1具体判断语句你自己写吧
再添加一个ADOQuery把sql语句添加进去,根据ADOQuery执行这个语句的结果来判断表lsxl是否存在再者,这条语句是SQL Server中的,如果是Access则不同 SELECT * FROM [MSysObjects] where Name = 'lsxl' and Type = 1具体判断语句你自己写吧
我一天也没有搞明白,我用的是Access临时表名是LSXL,请最好写一个完整的例子包括判断
function TForm1.IsTableByName(const TableName: string): Boolean; var TBList: TStringList; Index: Integer; begin TBList := TStringList.Create; try AdoConnection1.GetTableNames(TBList, True); Result := TBList.Find(TableName, Index); finally TBList.Free; end; end;
SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Table_1]') AND type in (N'U')
SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[lsxl]') AND type in (N'U')
SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[lsxl]') AND type in (N'U')用IF THEN如何判断它的值.(最好写出语句)
SELECT * FROM [MSysObjects]
where Name = 'lsxl' and Type = 1具体判断语句你自己写吧
SELECT * FROM [MSysObjects]
where Name = 'lsxl' and Type = 1具体判断语句你自己写吧
我一天也没有搞明白,我用的是Access临时表名是LSXL,请最好写一个完整的例子包括判断
var
TBList: TStringList;
Index: Integer;
begin
TBList := TStringList.Create;
try
AdoConnection1.GetTableNames(TBList, True);
Result := TBList.Find(TableName, Index);
finally
TBList.Free;
end;
end;