General MySQL Oracle SQL Server

<< < … 47 48 49 50 51 52 53 54 55 > >>   ∑:1318  Sort:Date

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, 1411🔥, 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, 1411🔥, 0💬

odbc_columns() - Listing All Columns in a Table
How To List All Columns in a Table using odbc_columns()? If you want to get a list of all columns in a table, you can use the odbc_columns() function, which can actually be used to list all columns in all tables and views in the database. The syntax of odbc_columns() is: $result_set = odbc_columns($... 2024-06-03, 1410🔥, 0💬

PHP MSSQL - Creating an Identity Column
PHP MSSQL - How To Create an Identity Column? Many tables require an ID column to assign a unique ID number for each row in the table. For example, if you have a table to hold forum member profiles, you need an ID number to identify each member. To allow SQL Server to automatically assign a new ID n... 2024-02-09, 1410🔥, 0💬

MS SQL Server DBA Checklist - General DBA Best Practices
-- Join (or start) a local SQL Server users group -- Attend at least one professional conference each year. -- Attend at least one training session each year. -- Read at least four books on SQL Server each year. -- Read the free e-book, How to Become an Exceptional DBA -- Learn everything you can ab... 2022-01-24, 1410🔥, 0💬

odbc_connect() - Connecting to a SQL Server through an ODBC DSN
How To Connect to a SQL Server using odbc_connect()? If you have an ODBC DSN (Data Source Name) created linking to a SQL Server, you are ready to connect to the SQL Server through the DSN with ODBC functions. There is no changes needed in the php.ini configuration file. The tutorial script below sho... 2024-07-11, 1409🔥, 0💬

Downloading and Installing PHP on Windows
How To Download and Install PHP on Windows? PHP is one of the most popular languages to develop dynamic Web pages. It supports all major database servers, including: MySQL, MS SQL Server, Oracle, mSQL, Sybase, etc. If you are developing a Web application that uses PHP and needs to access MS SQL Serv... 2024-04-29, 1408🔥, 0💬

Simplest Way To Create New Databases in SQL Server
What is the simplest way to create a new database in SQL Server? The simplest way to create a new database is to use the "CREATE DATABASE" statement with this syntax: CREATE DATABASE database_name For example, run this statement: CREATE DATABASE FyiCenterData GO A new database called "FyiCenterData"... 2016-11-24, 1408🔥, 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, 1408🔥, 0💬

PHP ODBC - Searching Records by Keywords
PHP ODBC - 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 numbe... 2024-05-05, 1407🔥, 0💬

PHP MSSQL - Computing Date and Time Differences
PHP MSSQL - How To Display a Past Time in Days, Hours and Minutes? You have seen a lots of Websites are displaying past times in days, hours and minutes. If you want to do this yourself, you can use the DATEDIFF() SQL function The following tutorial exercise shows you how to use DATEDIFF() to presen... 2024-02-18, 1407🔥, 0💬

HAVING - Apply Filtering Criteria at Group Level in SQL Server
How To Apply Filtering Criteria at Group Level with The HAVING Clause in SQL Server? Let's say you have divided the query output into multiple groups with the GROUP BY clause. Now you are only interested in some of the groups, not all the groups. If you want to filter out some groups from the query,... 2016-10-25, 1407🔥, 0💬

PHP MSSQL - Creating a New Table
PHP MSSQL - How To Create a New Table? If you want to create a table in the SQL Server database, you can run the CREATE 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('Fyi... 2024-03-07, 1405🔥, 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, 1405🔥, 0💬

Turning Off PHP Warning Messages for MSSQL Connection
How To Turn Off Warning Messages during PHP Execution? If don't want see warning messages generated from the PHP engine when executing PHP scripts, you can change the error_reporting setting in the php.ini configuration file. Open php.ini and change the following lines: ;error_reporting = E_ALL &... 2024-03-23, 1403🔥, 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, 1402🔥, 0💬

Selecting Columns in a Query in MySQL
How To Select Some Columns from a Table in MySQL? If you want explicitly tell the query to return some columns, you can specify the column names in the SELECT clause. The following select statement returns only two columns, "id" and "url" from the table "fyi_links": mysql&gt; SELECT id, url FROM... 2017-11-05, 1401🔥, 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, 1401🔥, 0💬

Defining Excel Files as the DTS Data Destination
How To Define Excel Files as the DTS Data Destination? Microsoft Excel is a nice tool to view and manage data in rows and columns. If you have a small database table, you may want to export its data to an Excel file so that you can make changes easily. This tutorial is a continuation of the previous... 2024-01-31, 1400🔥, 0💬

Data Formats Supported by DTS
What Are the Data Formats Supported by DTS? As mentioned in the DTS manual, DTS wizard support many popular data source formats: dBase - *.dbf files created by dBase, a popular database application for PCs. ODBC drivers - Any data source that configured through ODBC drivers. Microsoft Access - *.mdb... 2024-01-19, 1400🔥, 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, 1400🔥, 0💬

Verifying the Port Number of the SQL Server
How To Verify the Port Number of the SQL Server? When applications use TCP/IP for network communication, you need to know the port number where the server is listening for connect request from the client. If you want to connect to the SQL Server through the TCP/IP, you must know on which port number... 2024-07-25, 1398🔥, 0💬

CURRENT_ROLE() - Current Role of Logged-In User
How to obtain the current role of the logged-in user using the CURRENT_ROLE() function? CURRENT_ROLE() is a MySQL built-in function that returns the current role of the logged-in user. For example: SELECT CURRENT_ROLE(); -- +----------------+ -- | CURRENT_ROLE() | -- +----------------+ -- | NONE | -... 2024-07-15, 1395🔥, 0💬

mssql_fetch_array() - Looping through Result Set Objects
How To Loop through Result Set Objects using mssql_fetch_array()? If the returning output of a query statement is captured in a result set object, you can use mssql_fetch_array() to loop through each row in the output. The tutorial PHP script below shows you how to list tables in the database: &... 2024-03-23, 1395🔥, 0💬

<< < … 47 48 49 50 51 52 53 54 55 > >>   ∑:1318  Sort:Date

General MySQL Oracle SQL Server