摘要： use DataBaseNamegoif not OBJECT_ID('[Employees]') is Null Drop Table [Employees]goCreate Table [Employees](ID int Primary Key Identity(1,1), [Name] Nvarchar(50) Not Null, [Title] Nvarchar(50) Null, [Phone] int Null, [City] Nvarchar(20)) go Insert Into [Employees] select '张三', '采购 阅读全文

摘要： 使用SQL Server 081. Create DatabaseCreate Database database_name2. Create TableCreate Table table_name(column1_name Type, column2_name Type, …)Tips:(1). 选择database 并判断表如果已存在，删除原有表Use Database_nameGoIf exists (select * from sys.objects where object_id=OBJECT_ID(N'table_name') and type in (N' 阅读全文

摘要： 打开word前先启动Word， false visible 则不单独打开一个空白word$word=New-Object-ComObject Word.Application$word.Visible = $false 阅读全文