2020-02-16 标签:select,data,excel,sheet,mssql,openrowset,microsoft,jet,oledb,hdr,yes,imex,database,d,folder,xls

select *from openrowset('Microsoft.Jet.OLEDB.4.0' ,'Excel 8.0;HDR=YES;IMEX=1;DATABASE=d:\folder\excel.xls',Sheet1$) -------NOTE------ Setting IMEX=1 t

2020-02-16 标签:stop,sql,server,set,sqldmo,sqlserver,loginsecure,true,connect,shutdown

strDBServerName = "." Set objSQLServer = CreateObject("SQLDMO.SQLServer") objSQLServer.LoginSecure = True objSQLServer.Connect strDBServerName objSQLS

2020-02-16 标签:list,databases,a,sql,server,supported,platforms,2000,yes,script,code,set,sqldmo,sqlserver,loginsecure,true,connect

List all the Databases on a SQL Server. Supported Platforms SQL Server 2000Yes Script Code strDBServerName = "." Set objSQLServer = CreateObject("SQLD

2020-02-16 标签:display,sql,server,version,information,description,supported,platforms,2000,yes,script,code,set,sqldmo,sqlserver,loginsecure,true

Display SQL Server Version Information Description Display SQL Server Version Information. Supported Platforms SQL Server 2000Yes Script Code strDBSer

2020-02-16 标签:display,sql,server,login,mode,supported,platforms,2000,yes,script,code,integrated,mixed,normal,unknown

Display SQL Server Login Mode. Supported Platforms SQL Server 2000Yes Script Code SQLDMOSecurity_Integrated= 1SQLDMOSecurity_Mixed= 2SQLDMOSecurity_No

2020-02-16 标签:list,stored,procedures,a,sql,server,database,supported,platforms,2000,yes,script,code,strdbname,northwind,set,sqldmo

List the Stored Procedures in a SQL Server database. Supported Platforms SQL Server 2000Yes Script Code strDBServerName = "." strDBName = "Northwind"

2020-02-16 标签:sample,script,displays,users,a,given,sql,server,db,supported,platforms,2000,yes,code,实现,代码,如下,strdbname

Sample script that displays all of the users in a given SQL Server DB. Supported Platforms SQL Server 2000Yes Script Code 实现代码如下：strDBServerName = "."

2020-02-16 标签:sample,script,deletes,a,sql,server,database,supported,platforms,2000,yes,code,实现,代码,如下,set

Sample script that deletes a SQL Server database. Supported Platforms SQL Server 2000Yes Script Code 实现代码如下：strDBServerName = "."strDBToDelete= "Scrip

2020-02-16 标签:use,jscript,create,a,sql,server,database,实现,代码,如下,db,size,megabytes,set,sqldmo,sqlserver

Create a SQL Server database.实现代码如下：DB_SIZE_IN_MEGABYTES = 5 strDBServerName = "." Set objSQLServer = CreateObject("SQLDMO.SQLServer") objSQLServer.Lo

2020-02-16 标签:sql,server,数据库,性能,优化,技术,设计,应用,系统,似乎,并不,要想,达到,最优,并不是,一件

设计1个应用系统似乎并不难，但是要想使系统达到最优化的性能并不是一件容易的事。在开发工具、数据库设计、应用程序的结构、查询设计、接口选择等方面有多种选择，这取决于特定的应用需求以及开发队伍的技能。本文以SQLServer为例，从后台数据库的角度讨论应用程序性能优化技巧，并且给出了一些有益的建议。1