摘要: update JL_SC_SM_SalesOrderDetail set JContractPrice = b.JTaxPrice,JContractAmount=b.JTaxAmountfrom JL_SC_SM_SalesOrderDetail a , JL_SC_SMSalesContraEn... 阅读全文
posted @ 2015-04-10 15:54 YyuTtian 阅读(99) 评论(0) 推荐(0) 编辑
摘要: 想查询某个字段属于哪个表select * from INFORMATION_SCHEMA.COLUMNS where column_name like '%字段名%' and table_catalog like '%数据库名%'格式化输出一个存储过程的详细内容sp_helptext 存储过程名称清... 阅读全文
posted @ 2015-04-10 15:50 YyuTtian 阅读(79) 评论(0) 推荐(0) 编辑