Tutorials to .com

Tutorials to .com » Asp » Database » ASP Database Related

ASP Database Related Articles


261: Several stored procedure call (original import)
1, call the stored procedure without parameters <% set conn = server.CreateObject ( "adodb.connection") set cmd = server.CreateObject ( "adodb.command") strconn = "dsn = pubs; uid = sa; pwd" conn.Open strconn s...

262: Digest finishing 1 - common databases collated
01. How to solve the database query in the implementation of special characters in the issue of 02. Pocket Manual database connection query 03. ADO error code corresponds to the meaning of 04. Recordset object Detailed 05. "Unable to point ...

263: Asp how to avoid the inefficient implementation of SQL (reprint)
Method I, to make full use of complex SQL to replace a bunch of simple SQL. The same services, the completion of a complex SQL more efficient than the pile of the efficiency of the completion of a simple SQL. There are a number of inquiries, we sho...

264: Today, finally could not take long to write SQL statements, and wrote this paragraph, changed SQL statement can be a generating function
<!--# include file = "conn.asp" -> <html> <head> <title> Untitled Document </ title> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> </ head> <body...

265: Through the ASP, would like to ACCESS database table corresponding
At certain times, we need to create Access database tables, do not necessarily need to change the database to re-upload, I briefly introduce the method. <% 'First of all, the establishment of a database file set conn = server.createobject ...

266: Chinese Arabic numerals the amount of storage into a process (to)
Create Procedure AtoC @ ChangeMoney Money as Set Nocount ON Declare @ String1 char (20) Declare @ String2 char (30) Declare @ String4 Varchar (100) Declare @ String3 Varchar (100) - from the original A value out of the value of Declare @ i i...

267: Access database table name on the section of code, in the hope that useful
<% Call RenameTable ( "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = c: \ example.mdb "," test "," changed ") Sub RenameTable (conStr, oldName, newName) 'Has to be OLE DB connection 'Create object an...

268: Filter and mix updatebatch batch update (original)
Part code /******* *******/ /******* idArr () and codeArr () into two arrays, which, idArr () to filter the data filter conditions, codeArr () to update data as **********/ ....... dim CRs, sql, FStr sql = "" conn.begintrans set CRs ...

269: ASP and SQL combined with the processing time for applications (to)
In the development of database applications, the processing time will always be issues, such as records of inquiries, such as a specified period of time. The following frequently asked questions on these, combined with some of their own experience, ...

270: asp to call a number of examples of the storage process. (1)
Return Values how-to Execute a Stored Proc's This demo It's called ReturnValue.asp and shows you how to execute a stored procedure that has input params, output params, a returned recordset and a return value. <! - Author: John Bailey -...

271: Stored procedure (from BOL):
In the use of Microsoft ® SQL Server ™ 2000 to create applications, Transact-SQL programming language applications, and SQL Server database programming interface between the main. The use of Transact-SQL procedures, two methods can be use...

272: dbf database query of the date of this writing, if used please come take a look at the!
sql = "select * from 163yhzl where dtoc (ktrq1 )>='"& ksrq &" 'and dtoc (ktrq1 )<='"& jzrq & "' order by id desc" ...

273: Sql stored procedure using the dos command to achieve the asp program (original ^ _ ^)
1, first of all in sql which you can access the database stored procedures to establish, for example: ddy As follows: CREATE PROCEDURE ddy @ cmd varchar (50) AS exec master .. xp_cmdshell @ cmd 2, asp program are as follows: (hacksql.asp) <...

274: From a foreign Web site to find a (used to improve the ASP's GetString speed) I had it tested, it is a lot faster
ASP programmers have had many of the implementation of database query, the query results and then use the form of HTML tables show the experience of it. Usually we do: <% "Create connection / recordset "Populate data into recordset o...

275: SQL database attacks (to)
SQL database attacks Specific elements: For a lot of news at home and abroad, BBS and e-commerce sites using ASP + SQL design, and ASP programmers to write a lot (there are many recently graduated), so, ASP + SQL attack success rate Also relative...

276: The use of stored procedures Guinness (full review when their own review)
1, call the stored procedure without parameters <% set conn = server.CreateObject ( "adodb.connection") set cmd = server.CreateObject ( "adodb.command") strconn = "dsn = pubs; uid = sa; pwd" conn.Open strconn s...

277: Pure coding to achieve the establishment of the Access database or compressed!!
Pure coding to achieve the establishment of the Access database or compressed!! <% The following is a'####### types of documents, the following types of comments is to call the method ############################ #################### '...

278: A generic database program that can transfer any database, any field, multi-keyword searches, automatic paging
. Arab-Israeli than the regular written procedures related to a number of databases, of course, can not display the data in the database, I can honestly say this program is so boring ah, so, more than on the Arab-Israeli to write a function, a comm...

279: The implementation of the use of ASP and SP Services DTS.
Following the establishment of the SP: CREATE PROCEDURE doPublish ASexec master .. xp_cmdshell 'dtsrun / Ssql1 / NPublish / E' Of which: / S = SQL Server host name / N = DTS package names You can also use the / E parameter to the use of...

280: Generic database program that can transfer any database, any field, multi-keyword searches, automatic paging GM
Database program that can transfer any database, any field, multi-keyword searches, automatic paging. Arab-Israeli than the regular written procedures related to a number of databases, of course, can not display the data in the database, I can hone...


Page 14 of 32
[1]   [2]   [3]   [4]   [5]   [6]   [7]   [8]   [9]   [10]   [11]   [12]   [13]   [14]   [15]   [16]   [17]   [18]   [19]   [20]   [21]   [22]   [23]   [24]   [25]   [26]   [27]   [28]   [29]   [30]   [31]   [32]