Tutorials to .com

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

ASP Database Related Articles


181: Sql stored procedure using the dos command to achieve the asp program
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) <...

182: The use of stored procedures Guinness
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...

183: A generic database program
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 common ...

184: INSERT syntax case of the use of techniques
In SQL Server Books Online (SSBOL), requested the positioning sp_dbcmptlevel, and then find out the description of 6.0,6.5 and 7.0 version of the compatibility between the data tables . You may have noted the INSERT SQL statement syntax is as follo...

185: Universal Database display program
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...

186: Create a database using asp
Online to see a lot of code, but some are not, some code is too much garbage, I simply modified a bit to share with you now look. <% Option Explicit dim databasename 'definition database name databasename = "database.mdb" 'D...

187: asp data connection method
MS Access database connection DSN connection with and without a user name and password: <% set conn = Server.CreateObject ( "ADODB.Connection") conn.open "YourDSNName" %> DSN and connect with a username and password: ...

188: How to directly call the Excel data?
<% @ Language = vbscript%> <% Set exlApp = server.CreateObject ( "Excel.Application") strsource = "e: \ excel \ sample.xls" 'Database location Set exlstock = exlApp.Workstocks.Open (strsource) Set exlsheet = ex...

189: Microsoft's Data Access Technology Summary
Microsoft's data access technology in general have the following categories: A, UDA (UniversalDataAccess) This is the Microsoft Universal Data Access strategy. Including ADO, OLEDB and ODBC. It provides not only access the database for other d...

190: MySQL database function explain (1)
(1) int mysql_affected_rows ([int link_id]); In a given connection, the return from the most recent DELETE, INSERT, REPLACE, or UPDATE statement of the role of the number of rows. If there is no line Been modified, the mysql_affected_rows () retur...

191: MySQL database function explain (2)
5) int mysql_data_seek (int result_id, int row_num); By the SELECT query returns a result set for each line has a cursor, extract under the direction of a line function (mysql_fetch_array (), mysql_fetch_object () or mysql_fetch_row ()) call which ...

192: Database Connection 2
Vegetable ago, when not to write a post connected to a database, the view is very naive, friends not seen too, but boy tight ashamed ... ... to amend the amendment, it is another, I want to learn young girl read the database connection, simply write...

193: Pure ASP code and upload pictures into the database (a)
Website by ASP application to prepare a long time, and will inevitably meet a wide range of issues, including on how to upload files to the server is probably the most encountered problem, especially upload a picture, for example, you want to in the...

194: Pure ASP code and upload pictures into the database (b)
* GetChunk grammar The return of large text or binary data Field object in whole or in part. variable = field.GetChunk (Size) Return value Return to change the size. Parameters Size long integer expressions to be equal to retrieve the number o...

195: No upload component, a function to get
This function is "Transformation ASP free components Uploader 2.0" upload files. Core functions: <% '''''============================== 'Function name: upfile 'Role: the use of "Transformation From ...

196: No components to upload text and image database solutions gztiger
<! - Solemn declaration This is a free code, from the "ultra-free components upload pictures 2.0" modified from the sole purpose of having a troubled friend help, And "ultra-free components upload pictures 2.0" the authors s...

197: I finally aspSmartUpload.dll components used files uploaded!
Finally aspSmartUpload.dll with the site files uploaded components, simple operation, my system is Windows98se + Pws4.0. I am on the site "Resources Download-ASP source code download - File Transfer" to download a resource aspsmartupload.z...

198: asp will table data table excel successful introduction into the practice of
I recently made a project, the requirements of the project is to asp page books, according to Treasury data extracted directly excel as a form of preservation, the beginning of this end I would like a good finally done on it, and everyone in this to...

199: ACCESS database to prevent the download
How to prevent download mdb database access has been a programmer with a big disease. Effective way to sum it up as follows: 1. To amend the database name. This is a commonly used method of the database into a strange name or long name, in order to...

200: SQL-defined functions of the application
Function name: GetClassName (@ ClassID, @ ClassType) Parameters: @ ClassID types of ID No., @ ClassType, categories of types 0: Language 1: Classification, 2: major categories, 3: sub-category, 4: National 5: 6 provinces: the cities and counties R...


Page 10 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]