<< < 31 32 33 34 35 36 37 38 39 40 41 > >>   Sort: Date

Show the Current Transaction Mode in MySQL
How To Find Out the Current Transaction Mode in MySQL? If you are not sure about your current transaction mode, you can use the "SELECT @@AUTOCOMMIT FROM DUAL" statement to find out as shown in the following tutorial exercise: &gt;\mysql\bin\mysql -u dev -piyf fyi mysql&gt; SELECT @@AUTOCOMM...
2016-10-17, 541👍, 0💬

Updating Values in a Table in MySQL
How To Update Values in a Table in MySQL? If you want to update some values in one row or multiple rows in a table, you can use the UPDATE statement. The tutorial script below shows a good example: mysql&gt; UPDATE fyi_links SET counts = 999, notes = 'Good.' WHERE id = 101; Query OK, 1 row affec...
2018-01-13, 540👍, 0💬

"DROP" Statements - Deleting database objects in SQL Server
How to delete database objects with "DROP" statements in SQL Server? To remove all database objects created by previous tutorials, you could just delete the database. However, in this tutorial, you will go through the steps to reverse every action you took doing the tutorial. Removing permissions an...
2016-11-27, 540👍, 0💬

Measuring Performance of INSERT Statements in SQL Server
How To Measure Performance of INSERT Statements in SQL Server? When indexes are defined for a table, each time a new row is inserted to the table, all the indexes must be updated. This extra update work could slow down the insert statement. To find out how much slower the INSERT statements will be o...
2016-11-13, 540👍, 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, 540👍, 0💬

"ALTER LOGIN" - Changing a Login Name in SQL Server
How To Change a Login Name in SQL Server? If you want to change a login name, you can use the "ALTER LOGIN" statement as shown in this tutorial example: -- Login with "sa" -- Change login name ALTER LOGIN Fyi_Login WITH NAME = Dba_Login; GO -- View login names SELECT name, sid, type, type_desc FROM ...
2016-10-19, 540👍, 0💬

Use "FOR" Loop Statements in Oracle
How To Use "FOR" Loop Statements in Oracle? If you have a block of codes to be executed repeatedly over a range of values, you can use the "FOR ... LOOP" statement. Here is a sample script on FOR statements: DECLARE total NUMBER := 0; BEGIN FOR i IN 1..10 LOOP total := total + i; END LOOP; DBMS_OUTP...
2018-07-13, 539👍, 0💬

Creating a Test Table in MySQL
How To Create a Testing Table in MySQL? If you want to practice DML statements, like INSERT, UPDATE and DELETE, you should create a testing table. The tutorial exercise shows you a good example: mysql&gt; CREATE TABLE fyi_links (id INTEGER PRIMARY KEY, url VARCHAR(80) NOT NULL, notes VARCHAR(102...
2018-01-24, 539👍, 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, 539👍, 0💬

Determining Data Types of View Columns in SQL Server
How Column Data Types Are Determined in a View in SQL Server? When you define a view, its columns are defined through a list of expressions in the underlying SELECT statement. Their data types will be determined implicitly by the expressions. For example, if the column expression is a column name of...
2016-11-03, 539👍, 0💬

"ALTER LOGIN" - Disabling a Login Name in SQL Server
How To Disable a Login Name in SQL Server? If you want temporarily disable a login name, you can use the "ALTER LOGIN" statement with a DISABLE keyword. If you want to enable it later on, you can use the ENABLE keyword. The tutorial exercise below shows how to disable and enable login name "Dba_Logi...
2016-10-19, 539👍, 0💬

Downloading and Installing MySQL on Windows
Where to find answers to frequently asked questions on Downloading and Installing MySQL on Windows? I want to learn how to install MySQL database. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Downloading and Installing MySQL on Windows. Clear a...
2018-06-12, 538👍, 0💬

Differences between Functions and Stored Procedures in SQL Server
What Are the Differences between User Defined Functions and Stored Procedures in SQL Server Transact-SQL? Differences between user defined functions and stored procedures are: Stored procedures does not return any data and they can not be used in expressions. User defined functions does return data ...
2016-12-24, 538👍, 0💬

Create Tables for ODBC Connection Testing in Oracle
How To Create Tables for ODBC Connection Testing in Oracle? If you want to follow the tutorial exercises in the sections below, you need to create a user account and a table for ODBC connection testing as shown here: SQL&gt; CONNECT system/retneciyf Connected. SQL&gt; CREATE USER fyi IDENTIF...
2016-10-15, 538👍, 0💬

Show All Tables in the Database in Oracle
How To Get a List of All Tables in the Database in Oracle? If you don't like to use a SELECT statement to get a list of all tables in the current database, you can use the Reports view to do this as shown in the following tutorial example: Click menu View. Selects Reports from the menu. Open Reports...
2018-10-08, 537👍, 0💬

"CREATE TRIGGER" - Creating a DML Trigger in SQL Server
How To Create a DML Trigger using CREATE TRIGGER Statements in SQL Server? A DML trigger is a trigger declared to handle a DML event, which occurs when an INSERT, UPDATE or DELETE statement is executed. If you want to create a DML trigger, you should use the "CREATE TRIGGER" statement in the followi...
2016-10-25, 537👍, 0💬

Enter a New Row Interactively in Oracle
How To Enter a New Row into a Table Interactively in Oracle? If you don't like to use the INSERT statement to enter a new row into a table, you can use the object view to enter it interactively. Follow the steps below to enter new row into table TIP: Double-click on the table name TIP. Click the Dat...
2018-10-08, 536👍, 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, 536👍, 0💬

Creating a Logon Trigger in Express Edition in SQL Server
Can You Create a Logon Trigger in SQL Server 2005 Express Edition in SQL Server? Can you create a logon trigger in SQL Server 2005 Express Edition? The answer is no. LOGON is not a supported event type in Express Edition. The script below shows you the error message when you try to create a logon tr...
2016-10-22, 536👍, 0💬

Inserting Data into an Existing Table in MySQL
How To Insert Data into an Existing Table in MySQL? 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 include "mysql_connection.php"; $sql = "INSERT INTO fyi_links (id, url) VALUES (" . " 101, 'dev....
2017-10-08, 535👍, 0💬

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, 535👍, 0💬

Testing Table for SELECT Statements in SQL Server
How To Create a Testing Table with Test Data to try with SELECT statements in SQL Server? If you want to follow the tutorial exercises presented in this collection, you need to create a testing table and insert some test data, as shown in the following sample script: CREATE TABLE fyi_links (id INTEG...
2016-10-26, 535👍, 0💬

Connect ASP Pages to Oracle Servers in Oracle
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and serving ASP Web pages, you can get data from Oracle servers into your ASP pages through ODBC drivers. To do this, you need to install the correct Oracle ODBC driver and define a DSN on the IIS Web ser...
2016-10-15, 535👍, 0💬

Define and Use Table Alias Names in Oracle
How To Define and Use Table Alias Names in Oracle? 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: SQL&gt; SELECT e.first_name, e.last_name, d.department_name FROM employees e ...
2019-10-27, 534👍, 0💬

<< < 31 32 33 34 35 36 37 38 39 40 41 > >>   Sort: Date