<< < 17 18 19 20 21 22   ∑:509  Sort:Date

PHP MSSQL - Dropping an Existing Table
PHP MSSQL - How To Drop an Existing Table? If you need to delete a table created before, you can run the DROP TABLE SQL statement using the mssql_query() function, as shown in the following sample script: &lt;?php $con = mssql_connect('LOCALHOST','sa' ,'FYIcenter');mssql_select_db('FyiCenterData ...
2024-03-07, 2143🔥, 0💬

PHP MSSQL - Making Columns to Take NULL
PHP MSSQL - How To Make a Column Nullable? Based on the testing result from the previous tutorial you can find out that there is a big difference in the column definition when running CREATE TABLE statement with mssql_query(): If CREATE TABLE is executed through mssql_query() and "NULL/NOT NULL" key...
2024-03-07, 2136🔥, 0💬

SQL Server FAQs - Introduction to DTS (Data Transformation Services)
A collection of 10 FAQs on DTS (Data Transformation Services). Clear explanations and tutorial exercises are provided on using DTS to import data to SQL Server and export data from SQL Server; exporting tables to MS Excel files; importing tables from text files. Topics included in this collections: ...
2024-02-09, 2133🔥, 0💬

PHP ODBC - Query Multiple Tables Jointly
PHP ODBC - How To Query Multiple Tables Jointly? If you want to query information stored in multiple tables, you can use the SELECT statement with a WHERE condition to make an inner join. Assuming that you have 3 tables in a forum system: "users" for user profile, "forums" for forums information, an...
2023-12-30, 2121🔥, 0💬

Defining SQL Server 2005 as the DTS Data Destination
How To Define SQL Server 2005 as the DTS Data Destination? If you are importing data from text files to SQL Server 2005 database tables, you need to define SQL Server 2005 as the DTS data destination. This tutorial continues from the previous tutorial to show you how to tell DTS to create a new tabl...
2024-01-19, 2111🔥, 0💬

<< < 17 18 19 20 21 22   ∑:509  Sort:Date