摘要:
1.创建存储过程的基本语法模板: 1 if (exists (select * from sys.objects where name = 'pro_name')) 2 drop proc pro_name 3 go 4 create proc pro_name 5 @param_name para 阅读全文
摘要:
SQL SERVER查看所有表名:select name from sysobjects where type='U'查询表的所有字段名:Select name from syscolumns Where ID=OBJECT_ID('表名')select * from information_sch 阅读全文