Shulou(Shulou.com)06/01 Report--

The following is a brief description of SQL querying whether a table exists and returning the ID value of the new data.

1. Query whether the table exists:

Table name: "t_Demo", type ='u'to check whether it is a user table

Select * from sysobjects where id = object_id ('tweedemo') and type = 'u'select * from sys.tables where name='t_Demo' and type =' u'

two。 Query whether the field exists:

Table name: "t_Demo", field name "DemoID"

Select * from syscolumns where name='DemoID' and objectproperty (id,'IsUserTable') = 1 andobject_name (id) = 'tasking Demo'

3. Returns the maximum value of a self-increasing field, which can be used to return the ID value of the data you just added.

Field name: NdsID table name: tb_Nds

Select max (NdsID) from tb_Nds

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.