<< < 20 21 22 23 24 25 26 27 28 29 30 > >>   Sort: Date

What Is a Table in SQL Server
What is a table in SQL Server? A table in database is a data object used to store data. Tables have the following features: Data is stored in a table with a structure of rows and columns. Columns must be pre-defined with names, types and constrains. A table object may have other associated data obje...
2016-11-20, 409👍, 0💬

"INSERTED" - New Record of an DML Event Instance in SQL Server
How To Access the Inserted Record of an Event in SQL Server? When a DML event occurs, SQL Server will prepare a temporary table called "INSERTED", which contains the new record of the affected row, which is: A copy of the inserted row for an INSERT statement. A copy of the updated row for an UPDATE ...
2016-10-24, 409👍, 0💬

Converting Character Strings to Dates in MySQL
How To Convert Character Strings to Dates in MySQL? If you have a character string that represents a date, and you want to convert it into a date value, you can use the STR_TO_DATE(string, format) function. STR_TO_DATE() shares the same formatting codes with DATE_FORMAT() function. The tutorial exer...
2017-12-26, 408👍, 0💬

Connect to MySQL Server with Port Number in MySQL
How To Connect to a MySQL Server with a Port Number in MySQL? If you want to connect a MySQL server with a non-default port number, you need to use the "mysql_connect($server)" function with $server in the format of "hostName:portNubmber". The tutorial exercise below shows you how to connect to loca...
2017-11-25, 408👍, 0💬

Close MySQL Connection Objects in MySQL
How To Close MySQL Connection Objects in MySQL? MySQL connection objects created with mysql_connect() calls should be closed as soon as you have finished all of your database access needs by calling mysql_close($con) function. This will reduce the consumption of connection resources on your MySQL se...
2017-11-11, 408👍, 0💬

Getting Parts of DATETIME Values as Integers in SQL Server
How To Get Parts of DATETIME Values as Integers in SQL Server Transact-SQL? Sometimes, you want to one specific part of a DATETIME value as an integer to be used in your own date and time calculations. This can be done by using the DATEPART() function in the following format: DATENAME(datepart, date...
2017-02-14, 408👍, 0💬

Using Subqueries in the FROM Clause in SQL Server
How To Use Subqueries in the FROM Clause in SQL Server? If you have a query returning many rows of data, and you want to perform another query on those rows, you can put the first query as a subquery in the FROM clause of the second query. A subquery used in this way become a temporary table, and yo...
2016-10-29, 408👍, 0💬

Using Subqueries in the FROM Clause in MySQL
How To Use Subqueries in the FROM clause in MySQL? If you have a query returning many rows of data, and you want to perform another query on those rows, you can put the first query as a subquery in the FROM clause of the second query. A subquery used in this way become a temporary table, and you mus...
2017-12-21, 407👍, 0💬

CREATE CLUSTERED INDEX - Adding Clustered Indexes in SQL Server
How To Create a Clustered Index in SQL Server? If there is no primary key in a table, you can add one clustered index to that table with CREATE CLUSTERED INDEX statement. The tutorial exercise below shows you how to create a clustered index: USE FyiCenterData; GO -- Drop the old table, if needed DRO...
2016-11-13, 407👍, 0💬

"DISABLE TRIGGER" - Disabling Triggers in SQL Server
How To Disable Triggers using "DISABLE TRIGGER" in SQL Server? If want to stop the execution of an existing trigger temporarily, you can use the "DISABLE TRIGGER" statement to disable it. The disabled trigger will be kept in the database. If you want to resume the execution of a disabled trigger, yo...
2016-10-24, 407👍, 0💬

Using Table Alias Names in MySQL
How To Define and Use Table Alias Names in MySQL? When column names need to be prefixed with table names, you can define table alias name and use them to prefix column names as shown in the following select statement: mysql&gt; SELECT l.id, l.url, r.comment FROM fyi_links l INNER JOIN fyi_rates ...
2017-12-31, 406👍, 0💬

Merge Outputs from Two Queries in MySQL
How To Use UNION to Merge Outputs from Two Queries Together in MySQL? If you have two queries that returns the same row fields, you can merge their outputs together with the UNION operator. The following tutorial exercise shows you how to return all links that were created since year 2006 plus the o...
2017-12-21, 406👍, 0💬

Installing PHP on Windows in MySQL
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems is to: Go to http://www.php.net, which is the official Web site for PHP. Download PHP binary version for Windows in ZIP format. Unzip the downloaded file into a directory. You are done. No need to run...
2017-07-30, 406👍, 0💬

"USE" - Setting the Current Database in SQL Server
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should select a database to work with and set it as the current database using the "USE" statement with this syntax: USE database_name The following tutorial example shows you how to set "FyiCenterData" as t...
2016-11-24, 406👍, 0💬

ALTER VIEW - Modifying Existing Views in SQL Server
How To Modify the Underlying Query of an Existing View in SQL Server? If you have an existing view, and want to change the underlying SELECT statement, you can use the "ALTER VIEW ..." statement to redefine the view. The tutorial exercise below shows you how modify an existing view: USE FyiCenterDat...
2016-11-04, 406👍, 0💬

Sorting Query Output by Multiple Columns in SQL Server
Can the Query Output Be Sorted by Multiple Columns in SQL Server? You can specifying multiple columns in the ORDER BY clause as shown in the following example statement, which returns rows sorted by "tag" and "counts" values: SELECT tag, counts, url, created FROM fyi_links ORDER BY tag, counts GO ta...
2016-10-26, 406👍, 0💬

List Table Names with "mysqlshow" Command in MySQL
How To Show Table Names with "mysqlshow" in MySQL? If you want to show table names with "mysqlshow", you need to specify a database name. The followings tutorial exercise shows you how to get all table names that match a pattern: If you want analyze tables with "mysqlcheck", you need to use the "--a...
2018-05-19, 405👍, 0💬

Run-Away Recursive Calls in Oracle
What Happens If Recursive Calls Get Out of Control in Oracle? What happens if your code has bug on recursive procedure calls, which causes an infinite number nested procedure calls? The answer is not so good. Oracle server seems to offer no protection calling stack limit. The script below shows you ...
2018-03-18, 405👍, 0💬

Using SELECT Statements in Views in MySQL
Can SELECT Statements Be Used on Views in MySQL? Select (query) statements can be used on views in the same way as tables. The following tutorial exercise helps you creating a view and running a query statement on the view: mysql&gt; CREATE VIEW myLinks AS SELECT * FROM fyi_links WHERE url LIKE ...
2018-01-06, 405👍, 0💬

Sorting Output in Descending Order in MySQL
How To Sort Output in Descending Order in MySQL? If you want to sort a column in descending order, you can specify the DESC keyword in the ORDER BY clause. The following SELECT statement first sorts the "tag" in descending order, then sorts the "counts" in ascending order: mysql&gt; SELECT tag, ...
2017-11-02, 405👍, 0💬

Running SQL Server 2005 Books Online on Your Local System in SQL Server
How to run SQL Server 2005 Books Online on your local system in SQL Server? SQL Server 2005 Books Online can be accessed by a Web browser over the Internet. But you can also download it and read it on your local system. If you have downloaded and installed SQL Server 2005 Books Online package, you f...
2016-12-04, 405👍, 0💬

Database Engine Tutorials from SQL Server 2005 Books Online
How to use Transact-SQL statements to access the database engine in SQL Server? Transact-SQL statements can be used to access the database engine directly. Here are some good tutorials provided by the SQL Server 2005 Books Online. See the SQL Server 2005 Tutorials &gt; Database Engine Tutorials ...
2016-11-27, 405👍, 0💬

Ways to Start a New Transaction in MySQL
How To Start a New Transaction in MySQL? MySQL server offers two modes to manage transactions: Autocommit On - Default mode. Can be started with "SET AUTOCOMMIT = 1" command. In this mode, every single SQL statement is a new transaction. All changes will be committed at the end of the statement exec...
2016-10-17, 405👍, 0💬

Deleting All Rows in a Table in MySQL
How To Delete All Rows in a Table in MySQL? If you want to delete all rows from a table, you have two options: Use the DELETE statement with no WHERE clause. Use the TRUNCATE TABLE statement. The TRUNCATE statement is more efficient the DELETE statement. The tutorial exercise shows you a good exampl...
2018-01-08, 404👍, 0💬

<< < 20 21 22 23 24 25 26 27 28 29 30 > >>   Sort: Date