摘要:
使用 SqlDataAdapter的Update实现更新添加数据代码Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--StringBuilderobjSB=newStringBuilder();objSB.Append("select*From");ob... 阅读全文
摘要:
摘自:http://www.vbdotnetheaven.com/UploadFile/hima_.net/WebPageExecutioninIIS11262006235902PM/WebPageExecutioninIIS.aspxASP.Net Page Life CycleHow the simple web page execution happens? As all of us kn... 阅读全文
摘要:
代码Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--withtas(select1id,'Child1'childunionselect1id,'Child2'unionselect1id,'Child3'unionselect2id,'Child1'... 阅读全文
摘要:
1. 使数据库支持全文检索exec sp_fulltext_database 'Enable'2.定义表的全文检索目录和索引字段。CREATE FULLTEXT INDEX ON TableName KEY INDEX PK_IndexName ON DB WITH CHANGE_TRACKING AUTOALTER FULLTEXT INDEX ON TableName ADD ColumnNa... 阅读全文
摘要:
代码Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--createtable#TempTable(PersonIDint,KeChengvarchar(20),FenShufloat)insertinto#TempTableselect1,'Math',... 阅读全文
摘要:
代码Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--declare@atable(idint,namevarchar(50))insertinto@a(id,name)select'1','a'unionallselect'1','a'unionall... 阅读全文
摘要:
添加/删除程序中没有sql server 2000项目,我使用安装程序进行删除提示缺少文件。但是我的sql server 2000是可以使用的。 后来我试着打sp4补丁。结果在添加/删除程序中出现了sql server 2000项目。并可以成功的卸载了sql server 2000。 阅读全文