SQL Server 7.0 Database ASP Scripting
SQL Server 7.0 Database ASP Scripting
Topics for this course
59 Lessons
SQL Server 7.0 Database ASP Scripting eBook
01 Why use SQL Server in ASP scripting
02 How do you activate SQL Server DTS packages from ASP
03 How do you setup your DNS in your Window NT
04 How do you use ASP access SQL Server through DNS(ODBC)
05 What is the difference between OLE DB and ODBC
06 How do you access the database through OLEDB
07 How to connect to the Analysis Server through the use of URL
08 What is the ODBC 80004005 Error
09 How to use ASP to issue the SELECT statement to SQL Server
10 How to setup a connection to a backup SQL server for ASP redirection
11 How to use ASP to redirect failed ADO connection to a backup SQL server
12 What is the use of Global.asa
13 How do you use Global.asa to access your SQLServer
14 How do you call a MSSQL stored procedure from ASP
15 How do you make your stored procedure run faster
16 How do you display images stored in BLOBS
17 How do display our result out from SQL Server
18 Adding new records into SQL Server
19 How efficient is the method shown above
20 Can you use begin transaction or rollback in ASP with SQL Server
21 How do access SQL Server from Integrated Security from ASP
22 How to determined the number of parameter in a stored procedures
23 How do you use ASP to query a ODBC datasource
24 How do you update or modify your data
25 How do you insert text string into SQL table
26 How do you search special character in the where clause
27 How do you delete a record in SQL Server
28 How do you enable basic authentication in MSSQL and IIS
29 How do you use javascript to return value from SQL Server database
30 What is the licensing requirement MS SQL Server
31 What is the basic data access component
32 What is the role of MTS (Microsoft Transaction Server )
33 How do you run a system stored procedure
34 Why use store procedure
35 What if you result is exceptionally slow
36 Using PivotTable Service
37 Embedding English Query in your ASP application
38 How do you need to know about ODBC connection pooling
39 How to set the connection pooling timeout
40 How to enable the connection pooling
41 How to get your data faster with data cache
42 How to use AND OR operator
43 What is the use of Pagesize properties
44 How to use PageSize Properties
45 What is an AbsolutePage property
46 What is the difference between Remote Server and Linked Server
47 How to create a downloadable file
48 How to issue Distributed query
49 How to Distributed Query on the fly
50 How to get the value of your @@IDENTITY from SQL Server
51 How to use ASP to retrieve System Objects in MSSQL Server
52 How to avoid getting the message Lock Time out
53 How to create database table with ASP
54 How to use set in MSSQL
55 How to read your system registry
56 How to use LCD to locate time
57 What do you get when open a recordset
58 How to use SELECT…MULTIPLE or a group of same-named checkboxes and turn it into a query
59 How to reduce duplicate data from a recordset
About the instructor
69 Courses
3 students
Free