General MySQL Oracle SQL Server

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

PHP ODBC - Creating a New Table
PHP ODBC - How To Create a New Table? If you want to create a table in the database connected through a ODBC DSN, you can run the CREATE TABLE SQL statement using the odbc_exec() function, as shown in the following sample script: &lt;?php $con = odbc_connect('FYI_SQL_SERVER', 'sa','FYIcenter');#... 2024-06-03, 2846🔥, 0💬

Requirements on SQL Server Network Connections
What Are the Requirements on SQL Server Network Connections? By default, SQL Server 2005 Express Edition is installed only one connection protocol enabled: Shared Memory - SQL Server connection protocol for applications that are running on the same machine where the SQL Server is running. For exampl... 2024-08-06, 2845🔥, 0💬

Assigning NULL Values to Variables or Columns in SQL Server
How To Assign NULL Values to Variables or Columns in SQL Server Transact-SQL? The rule for assigning NULL values to variables or table columns is simple: Use keyword "NULL" directly as normal values. "NULL" can be used in SET statements to assign NULL values to variables. "NULL" can be used in SET c... 2017-02-05, 2845🔥, 0💬

SQL Server FAQs - PHP ODBC Functions - Managing Tables and Data Rows
A collection of 14 FAQs on using PHP ODBC functions to connect to manage tables and data rows. Clear explanations and tutorial exercises are provided on creating tables; inserting multiple data rows; updating and deleting data rows; searching data from multiple tables; looping through result sets; w... 2024-06-03, 2844🔥, 0💬

Checking Your PHP Installation
How To Check Your PHP Installation? PHP provides two execution interfaces: Command Line Interface (CLI) and Common Gateway Interface (CGI). If PHP is installed in the \php directory on your system, you can try this to check your installation: Run "\php\php -v" command to check the Command Line Inter... 2024-04-29, 2844🔥, 0💬

Assign Values to Variables in Oracle
How To Assign Values to Variables in Oracle? You can use assignment statements to assign values to variables. An assignment statement contains an assignment operator ":=", which takes the value specified on the right to the variable on left. The script below show you some examples of assignment stat... 2018-08-06, 2843🔥, 0💬

NULL Values Involved in Datetime Operations in SQL Server
What Happens If NULL Values Are Involved in Datetime Operations in SQL Server Transact-SQL? If NULL values are involved in datetime operations, the result will be datetime NULL values. The following tutorial script shows you some good examples: USE FyiCenterData; GO SELECT GETDATE()+NULL; GO -------... 2017-02-05, 2842🔥, 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, 2838🔥, 0💬

What Are User Defined Functions in SQL Server
What Are User Defined Functions in SQL Server Transact-SQL? A user defined function is a collection of Transact-SQL statements that stored in the SQL Server. A user defined function will return data when executed. A user defined function works in the same way as a system function. It can be used as ... 2016-12-28, 2837🔥, 0💬

Using Subqueries with the IN Operators in SQL Server
How To Use Subqueries with the IN Operators in SQL Server? A subquery can be used with the IN operator as "expression IN (subquery)". The subquery should return a single column with one or more rows to form a list of values to be used by the IN operation. The following tutorial exercise shows you ho... 2016-10-29, 2833🔥, 0💬

Missing ntwdblib.dll for MSSQL connection
What Happens If ntwdblib.dll Is Missing on Your Machine? In order to install the proper version of ntwdblib.dll on your machine, you need to find out how many copies of ntwdblib.dll do you have on your machine and what are the version numbers on those copies. 1. Go to Start &gt; Search &gt; ... 2024-04-14, 2832🔥, 0💬

Show All Background Sessions in the Database in Oracle
How To Get a List of All Background Sessions in the Database in Oracle? If you don't like to use a SELECT statement to get a list of all background sessions in the current database, you can use the Reports view to do this as shown in the following tutorial example. You need to connect to the server ... 2019-01-26, 2829🔥, 0💬

Joining Two Tables in a Single Query in SQL Server
How To Join Two Tables in a Single Query in SQL Server? Two tables can be joined together in a query in 4 ways: Inner Join: Returns only rows from both tables that satisfy the join condition. Left Outer Join: Returns rows from both tables that satisfy the join condition, and the rest of rows from th... 2016-10-30, 2828🔥, 0💬

Writing Inner Joins with the WHERE Clause in SQL Server
How To Write an Inner Join with the WHERE Clause in SQL Server? If you don't want to use the INNER JOIN ... ON clause to write an inner join, you can put the join condition in the WHERE clause as shown in the following query example: SELECT l.id, l.url, r.comment FROM fyi_links l, fyi_rates r WHERE ... 2016-10-29, 2828🔥, 0💬

Retrieve Field Values from RECORD Variables in Oracle
How To Retrieve Values from Data Fields in RECORD Variables in Oracle? If a variable is a RECORD variable with data fields assigned values, you can retrieve those values out of its data fields by using fields names prefixed with variable name as "variable.field_name". Here is a sample script showing... 2018-09-01, 2827🔥, 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, 2826🔥, 0💬

Accessing a Schema Not Owned by You in SQL Server
What Happens If You Are Trying to Access a Schema Not Owned by You in SQL Server? In general, if you are trying to access an object in schema owned by another database user, you will get a "permission denied" error, unless that you have been granted access permission to that object explicitly. Here ... 2016-10-22, 2826🔥, 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, 2825🔥, 0💬

PHP ODBC - Including Text Values in SQL Statements
PHP ODBC - 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-05-05, 2823🔥, 0💬

Deleting a User Account in MySQL
How To Delete a User Account in MySQL? If you want to delete a user account, you can connect to the server as "root" and use the "DROP USER ..." command to delete a user account. The tutorial exercise below shows you a good example: &gt;cd \mysql\bin &gt;mysql -u root -pretneciyf mysql mysql... 2017-12-13, 2820🔥, 0💬

Define Variables before Procedures and Functions in Oracle
What Is the Order of Defining Local Variables and Sub Procedures/Functions in Oracle? In the declaration part, you must define all local variables before defining any sub procedures or sub functions. See the following sample script: SQL&gt; CREATE OR REPLACE PROCEDURE WELCOME AS 2 SITE CHAR(80) ... 2018-03-18, 2819🔥, 0💬

Deleting an Existing Row with DELETE Statements in SQL Server
How To Delete an Existing Row with DELETE Statements in SQL Server? If you want to delete an existing row from a table, you can use the DELETE statement with a WHERE clause to identify that row. Here is good sample of DELETE statements: -- insert a row for this test INSERT INTO fyi_links (url, id) V... 2016-10-30, 2819🔥, 0💬

Creating a New Database in MySQL
How To Create a New Database in MySQL? A database in a MySQL server is a logical container used to group tables and other data objects together as a unit. If you are the administrator of the server, you can create a new databases using the CREATE DATABASE statements with MySQL client interface progr... 2017-11-11, 2817🔥, 0💬

Returning Result from Query with ODBC Connection
How To Receive Returning Result from a Query? When you execute a SQL SELECT statement with the odbc_exec() function, you can capture the returning result with a result set object with the following syntax: $result_set = odbc_exec($sql_statement); #- The returning value could be a Boolean value FALSE... 2024-07-17, 2816🔥, 1💬

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

General MySQL Oracle SQL Server