摘要：1. JoinTips:(1). Inner Join 同 JoinSelect alias_name1.column_name, alias_name2.column_nameFrom table_name1 as alias_name1Inner join table_name2 as alias_name2On alias_name1.column3 = alias_name2.column4Order by alias_name1.column_name1(2). Left Join, 即使右表没有匹配，也返回左表所有行Select alias_name1.column_name, a 阅读全文

摘要：数据库重命名Alter Database database_oldName Modify Name = database_newNameEXEC sp_renamedb 'database_oldName', 'database_newName'表重命名EXEC sp_rename 'table_oldName', 'table_newName'列重命名EXEC sp_rename 'tablename.columnOldName','columnNewName','COLUMN' 阅读全文

摘要：SQL Server: List schema name and table nameSelect quotename(SCHEMA_NAME(SCHEMA_ID)) + '.' + QUOTENAME(name)AS SchemaTableFrom sys.tables 阅读全文

摘要：1. UpdateUpdate table_name Set column_name = value_new Where ...Tips: 更新多个值，用逗号分隔2. DeleteDelete From table_name where ...Tips: 删除全部数据Delete From table_name3. TopSelect top 3 * from table_nameSelect top 30 percent * from table_name4.通配符'%' - 一个或多个字符'_' - 一个字符'[abc]' - abc 中任意 阅读全文

摘要：备份Web Application 和 SQL Server遇到的几个问题。1. Default Web Site 和 SharePoint 冲突(待解决)准备了一台Server 2K8 R2 机器，先配置TFS2010，再装IIS 发布Web Application, 遇到web page 不能显示, localhost也无法显示。按照网上各种解决无效。重装机器先装IIS, Localhost 一切正常，成功发布Web Application. 再配置TFS2010， 装sharepoint时提示将修改Default Web Site, 然后Web Application 不能显示了。还没找 阅读全文

摘要：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 '张三', '采购 阅读全文