General MySQL Oracle SQL Server

<< < … 13 14 15 16 17 18 19 20 > >>   ∑:464  Sort:Date

PHP MSSQL - Deleting Existing Rows in a Table
PHP MSSQL - How To Delete Existing Rows in a Table? If you want to remove a row from a table, you can use the DELETE statement with a WHERE clause to identify the row. The following sample script deletes one row: &lt;?php $con = mssql_connect('LOCALHOST','sa' ,'FYIcenter');mssql_select_db('FyiCe... 2024-02-18, 1255🔥, 0💬

PHP MSSQL - Searching Records by Keywords
PHP MSSQL - How To Perform Key Word Search in Tables? The simplest way to perform key word search is to use the SELECT statement with a LIKE operator in the WHERE clause. The LIKE operator allows you to match a text field with a keyword pattern specified as '%keyword%', where (%) represents any numb... 2024-02-09, 1255🔥, 0💬

Using User Defined Functions in Expressions in SQL Server
How To Use User Defined Functions in Expressions in SQL Server Transact-SQL? An user defined function must return a value, which can be used in any expression as long as the return value data type matches the expression. To execute a user defined function and use its return value in an expression, y... 2016-12-24, 1255🔥, 0💬

Requirements to Use ODBC Connections in PHP
What Are the Requirements to Use ODBC Connections in PHP Scripts? If you are planning to use ODBC connections to access SQL Server databases in PHP scripts, you need to check the following requirements: The PHP engine must support ODBC functions. If you install PHP 5.2.2 from The PHP Group, the ODBC... 2024-03-17, 1254🔥, 0💬

Basic Features of a Trigger in SQL Server
What Are the Basic Features of a Trigger in SQL Server? Since a SQL Server trigger is a really an event handler, it has the following basic features similar to event handlers in other programming languages: Event Type - It must be declared to handle a specific event, like a DELETE event. Object Scop... 2016-10-25, 1251🔥, 0💬

"CREATE SCHEMA" - Creating a New Schema in a Database in SQL Server
How To Create a New Schema in a Database in SQL Server? If you want to create a new schema in an existing database, you can use the "CREATE SCHEMA" statement as shown in the tutorial example below: USE FyiCenterData; GO CREATE SCHEMA fyi; GO Command(s) completed successfully. A new schema called "fy... 2016-10-22, 1251🔥, 0💬

Connecting MS Access to SQL Servers through ODBC
How To Connect MS Access to SQL Servers through ODBC? Once you got a DSN defined in the ODBC manager that connects to your SQL Server, you can connect a normal MS Access document to the Oracle server, and link an Access table to a SQL Server table. The tutorial below gives you a good example: Start ... 2024-03-17, 1248🔥, 0💬

PHP MSSQL - Inserting Data into an Existing Table
PHP MSSQL - How To Insert Data into an Existing Table? If you want to insert a row of data into an existing table, you can use the INSERT INTO statement as shown in the following sample script: &lt;?php $con = mssql_connect('LOCALHOST','sa' ,'FYIcenter');mssql_select_db('FyiCenterData ',$con); $... 2024-03-07, 1247🔥, 0💬

Preparing Data in Text Files for DTS to Import
How To Prepare Data in Text Files for DTS to Import? Sometimes you have data organized in rows and columns and stored in text files. You can import data from text files to SQL Server database tables using the DTS wizard. But you need to prepare data text files with the following questions in mind: W... 2024-01-19, 1247🔥, 0💬

"AS" - Naming Query Output Columns in SQL Server
How To Name Query Output Columns in SQL Server? Each column in the query output has a default name. If you don't like the default name, you can specify a new name for any column in the query output by using the AS clause. The following statement shows you a good example: SELECT tag AS Category, YEAR... 2016-10-29, 1246🔥, 0💬

PHP MSSQL - mssql_rows_affected() - Number of Affected Rows
PHP MSSQL - How To Get the Number of Affected Rows? If you insert multiple rows with a single INSERT statement, you can use the mssql_rows_affected() function to find out how many rows were inserted. mssql_rows_affected($connectio n)returns the number of affected rows of the last INSET, UPDATE or DE... 2024-02-28, 1245🔥, 0💬

PHP MSSQL - Including Date and Time Values in SQL Statements
PHP MSSQL - How To Include Date and Time Values in SQL Statements? If you want to provide date and time values in a SQL statement, you should write them in the format of "yyyy-mm-dd hh:mm:ss", and quoted with single quotes ('). The tutorial exercise below shows you two INSERT statements. The first o... 2024-02-18, 1245🔥, 0💬

PHP MSSQL - Query Multiple Tables Jointly
PHP MSSQL - 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, a... 2024-02-09, 1244🔥, 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, 1244🔥, 0💬

Defining SQL Server 2005 as the DTS Data Source
How To Define SQL Server 2005 as the DTS Data Source? If you want to transform (export) data out of a SQL Server 2005 database table, you need to configure the DTS data source to connect the SQL Server 2005 server. The tutorial exercise below shows you how to connect to the local SQL Server 2005 ser... 2024-01-31, 1242🔥, 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, 1241🔥, 0💬

Creating an Index on a View in SQL Server
How To Create an Index on a View in SQL Server? If you need to search and sort data in a view with a large number of row, you may want to create an index on the view to speed up your search process. The tutorial exercise below shows you how to create a unique clustered index on a view. DROP VIEW fyi... 2016-11-03, 1241🔥, 0💬

Copying a Table from Source to Destination
How To Copy a Table from Source to Destination? If the DTS data source is set to a SQL Server, you have two options to transform data from source to destination: Copy all rows and columns of a table or view. Generating data by a SELECT query statement. This tutorial continues from previous tutorials... 2024-01-31, 1240🔥, 0💬

Defining Text Files as the DTS Data Source
How To Define Text Files as the DTS Data Source? If your data text file is ready to import, you can start the DTS wizard and define the text file as the data source following this tutorial: 1. Start the DTS wizard and click Next. The data source window shows up. 2. Select "Text File" as the Data Sou... 2024-01-19, 1239🔥, 0💬

SQL Server FAQs - PHP ODBC Functions - Connection and Query Execution
A collection of 14 FAQs on using PHP ODBC functions to connect to SQL Server databases. Clear explanations and tutorial exercises are provided on testing ODBC DSN settings; creating connection to a SQL Server through a DSN; executing SQL statements; looping through result set; Executing prepared sta... 2024-03-17, 1238🔥, 0💬

Commonly Used ODBC Functions in PHP
What Are Commonly Used ODBC Functions in PHP? If you look at the PHP 5 manual, you will see a group of functions listed under the ODBC Functions (Unified) section. The commonly used ODBC functions are: odbc_connect � Establish an OBDC connection. odbc_data_source � Returns information about a curren... 2024-03-17, 1237🔥, 0💬

PHP MSSQL - Including Text Values in SQL Statements
PHP MSSQL - How To Include Text Values in SQL Statements? Text values in SQL statements should be quoted with single quotes ('). If the text value contains a single quote ('), it should be protected by replacing it with two single quotes (''). In SQL language syntax, two single quotes represents one... 2024-02-18, 1237🔥, 0💬

"ALTER TRIGGER" - Modifying Existing Triggers in SQL Server
How To Modify Existing Triggers using "ALTER TRIGGER" in SQL Server? If you want to make changes to an existing trigger, you could use the "ALTER TRIGGER" statements to refine the trigger again. The tutorial exercise below shows you how to modify the trigger defined in a previous tutorial: USE FyiCe... 2016-10-24, 1237🔥, 0💬

Connecting Windows Applications to SQL Servers via ODBC
How Can Windows Applications Connect to SQL Servers via ODBC? One way of connecting a windows application to a SQL Server is to use ODBC drivers. The requirements to do this is summarized here: The SQL Server must have TCP/IP protocol enabled with a specific port number. The SQL Server Browser Servi... 2024-03-17, 1235🔥, 0💬

<< < … 13 14 15 16 17 18 19 20 > >>   ∑:464  Sort:Date

General MySQL Oracle SQL Server