全部博文(69)
发布时间:2014-08-27 05:07:11
--如需在表中添加列,请使用下列语法:ALTER TABLE table_nameADD column_name datatype --例如:ALTER TABLE PersonsADD Birthday date --要删除表中的列,请使用下列语法:ALTER TABLE table_name DROP .........【阅读全文】
发布时间:2014-08-26 08:41:03
Method one: using stored procedure:Use masterexec sp_dropserver 'DBServer'goexec sp_addlinkedserver @server='DBServer', @srvproduct='sqlexpress', @provider='SQLNCLI', @datasrc='dba.selfip.com' go EXEC sp_addlinkedsrvlogin'DBServer', --.........【阅读全文】
发布时间:2014-08-23 08:39:58
alter table dbo.Quotes add StatusID2 smallint goUPDATE dbo.Quotes SET StatusID2 = StatusID go alter table dbo.Quotes drop column StatusID go alter table dbo.Quotes drop constraint ck_quote go......【阅读全文】
发布时间:2014-08-21 06:36:41
use master go alter database Northwind set single_user with rollback immediate --将数据库回滚到原始配置状态 go drop database Northwind--删除数据库 go......【阅读全文】
发布时间:2014-08-19 06:17:44
SQL SERVER (TRANSACT-SQL): FOREIGN KEYSLearn how to use Foreign Keys in SQL Server with syntax and examples.WHAT IS A FOREIGN KEY IN SQL SERVER?A foreign key is a way to enforce referential integrity within your SQL Server database. A foreign key means.........【阅读全文】