SqlServer
chenxingbai
这个作者很懒,什么都没留下…
展开
-
全文索引语法
if (select DATABASEPROPERTY(DB_NAME(), NIsFullTextEnabled)) exec sp_fulltext_database Nenable GOif not exists (select * from dbo.sysfulltextcatalogs where name = Ndown91)exec sp_fulltext_catalog原创 2005-04-10 14:43:00 · 747 阅读 · 0 评论 -
级联更新mssql行
update Library_BookBaseInfoTBset Author = cxbsky from Library_BookBaseInfoTB a, Library_BookInfoTB b where a.BookBaseInfoID = b.BookBaseInfoID原创 2005-04-10 17:42:00 · 744 阅读 · 0 评论