摘要： --表联合修改UPDATE payuser SET kid=bu.KID FROM dbo.Pay_UserTB AS payuser inner JOIN dbo.Pay_UserTempTB AS bu ON payuser.ID=bu.ID --付费率ALTER TABLE dbo.TempT 阅读全文

摘要： 查询数据库里所有表名和字段名的语句SQL 查询所有表名：SELECT NAME FROM SYSOBJECTS WHERE TYPE='U'SELECT * FROM INFORMATION_SCHEMA.TABLES查询表的所有字段名：SELECT NAME FROM SYSCOLUMNS WHE 阅读全文