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

Sorting Query Output in Descending Order in SQL Server
How To Sort Query Output in Descending Order in SQL Server? 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: SELECT tag, cou...
2016-10-26, 438👍, 0💬

DROP VIEW - Deleting Existing Views in SQL Server
How To Drop Existing Views from a Database in SQL Server? If you don't need a specific view any more, you can use the DROP VIEW statement to delete it from the database. The following tutorial exercise shows you how to delete the view, fyi_links_view: USE FyiCenterData; GO SELECT * FROM sys.views; G...
2016-11-05, 437👍, 0💬

Deleting Multiple Rows with One DELETE Statement in SQL Server
How To Delete Multiple Rows with One DELETE Statement in SQL Server? You can delete multiple rows from a table in the same way as deleting a single row, except that the WHERE clause will match multiple rows. The tutorial exercise below deletes 3 rows from the fyi_links table: -- view rows to be dele...
2016-10-30, 437👍, 0💬

Oracle Tablespace - Unit of Logical Storage in Oracle
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an Oracle database. It is managed and used by the Oracle server to store structures data objects, like tables and indexes.   ⇒Managing Oracle Tablespaces and Data Files ⇒⇒Oracle Database Tutorials
2019-04-17, 436👍, 0💬

SINGLE_USER/MULTI_USER - Database User Access Options in SQL Server
How to set database to be SINGLE_USER in SQL Server? Databases in SQL Server have three user access options: MULTI_USER - All users that have the appropriate permissions to connect to the database are allowed. This is the default. SINGLE_USER - One user at a time is allowed to connect to the databas...
2016-11-20, 436👍, 0💬

"GROUP BY" - Dividing Query Output into Multiple Groups in SQL Server
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, you want to divide the query output into multiple groups, and apply group functions on each individual groups. Dividing query output into multiple groups can be done with the GROUP BY clause. Here is t...
2016-10-25, 436👍, 0💬

Security Principals Used in SQL Server 2005 in SQL Server
What Are Security Principals Used in SQL Server 2005 in SQL Server? SQL Server 2005 supports several basic security principals located at different levels: Windows-Level Principals: Windows Local Login and Windows Network Domain Login - Used to control accesses to SQL Server instances. SQL Server-Le...
2016-10-20, 436👍, 0💬

Retrieve the Count of Updated Rows in Oracle
How To Retrieve the Count of Updated Rows in Oracle? After running an UPDATE statement, the database server returns a count of updated rows. You can retrieve this count from a special predefined variable called SQL%ROWCOUT, as shown in the following tutorial: CREATE TABLE emp_temp AS SELECT * FROM e...
2018-09-13, 435👍, 0💬

Subtracting a DATETIME Value from Another DATETIME Value in SQL Server
Can a DATETIME Value Be Subtracted from Another DATETIME Value in SQL Server Transact-SQL? Can a datetime value be subtracted from another datetime value? The answer is yes. The subtract operation can be performed by the subtract operator (-) as: datetime1 - datetime2: Returning a DATETIME value cal...
2017-02-20, 435👍, 0💬

Assign Field Values into RECORD Variables in Oracle
How To Assign Values to Data Fields in RECORD Variables in Oracle? If a variable is a RECORD variable, you can assign values to its data fields by using fields names prefixed with variable name as "variable.field_name". Here is a sample script assigning values to data fields of RECORD variables: CRE...
2018-09-01, 434👍, 0💬

Running MySQL Server on a Specific Port in MySQL
How To Run MySQL Server on a Different Port in MySQL? By default, MySQL will listen at port number 3306 for any client connections. But you can change this by starting the server with "--port=portNumber" option. The tutorial exercise shows you how to start the server to listen to a different port nu...
2017-11-29, 434👍, 0💬

What Is Transaction in MySQL
What Is Transaction in MySQL? A transaction is a logical unit of work requested by a user to be applied to the database objects. MySQL server introduces the transaction concept to allow users to group one or more SQL statements into a single transaction, so that the effects of all the SQL statements...
2016-10-16, 434👍, 0💬

Default Schema of Your Login Session in SQL Server
What Is the Default Schema of Your Login Session in SQL Server? When you login to a SQL Server and select a database to use, SQL Server will assign your login session a default schema. The schema name can be omitted when you refer to objects in the default schema. Here is what you should remember ab...
2016-10-22, 432👍, 0💬

"DROP SCHEMA" - Dropping an Existing Schema in SQL Server
How To Drop an Existing Schema in SQL Server? If you want to delete a schema, you need to move all objects out of that schema, then use the "DROP SCHEMA" statement to delete the schema. The tutorial exercise below shows you how to drop schema "fyi": -- Login with "sa" USE FyiCenterData; GO -- Drop f...
2016-10-20, 432👍, 0💬

"OPEN" - Executing the Query of a Cursor in SQL Server
How To Execute the Cursor Queries with "OPEN" Statements in SQL Server Transact-SQL? Once a cursor is declared, you need to execute the query attached to the cursor so that the result set returned from the query can be accessed through the cursor. To execute the cursor query, you should use the OPEN...
2016-10-17, 431👍, 0💬

Call a Sub Procedure in Oracle
How To Call a Sub Procedure in Oracle? To call a sub procedure, just use the sub procedure name as a statement. Here is another example of calling a sub procedure: SQL&gt; CREATE OR REPLACE PROCEDURE WELCOME AS 2 PROCEDURE WELCOME_PRINT(S CHAR) AS 3 BEGIN 4 DBMS_OUTPUT.PUT_LINE('Welcome to ' || ...
2018-10-26, 430👍, 0💬

Entering Boolean Values in MySQL
How To Enter Boolean Values in SQL Statements in MySQL? If you want to enter Boolean values in SQL statements, you use (TRUE), (FALSE), (true), or (false). Here are some good examples: SELECT TRUE, true, FALSE, false FROM DUAL; +------+------+-------+------- +| TRUE | TRUE | FALSE | FALSE | +------+...
2018-03-31, 429👍, 0💬

Mixing Group Functions with Non-group Selection Fields in SQL Server
Can Group Functions Be Mixed with Non-group Selection Fields in SQL Server? If a group function is used in the SELECT clause, all other selection fields must be group level fields. Non-group fields can not be mixed with group fields in the SELECT clause. The script below gives you an example of inva...
2016-10-25, 429👍, 0💬

Work with Data Objects Interactively in Oracle
How To Work with Data Objects Interactively in Oracle? You can work with data objects through SQL statements in statement area. If you want to work with data objects interactively, you should use the object browser. The following tutorial steps help you to browse data objects: Click the Connetions t...
2018-10-08, 427👍, 0💬

What Is SQL Standard in MySQL
What Is SQL Standard in MySQL? SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Relational Database Management Systems). SQL was developed by IBM Corporation. SQL became an ANSI standard, called SQL-87, in 1986. ISO made a major revision, called SQL-92, in 1992. The latest r...
2018-04-21, 427👍, 0💬

Downloading SQL Server 2005 Express Edition in SQL Server
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 Express Edition is the free version of the Microsoft SQL Server 2005. If you are interested to try SQL Server 2005, you should follow this tutorial to download Microsoft SQL Server 2005 Express Edition...
2016-12-08, 427👍, 0💬

Getting a List of All Databases on the Server in SQL Server
How to get a list all databases on the SQL server in SQL Server? If you don't remember database names you have created, you can get a list of all databases on the server by query the "sys.databases" view as shown in this tutorial example: CREATE DATABASE FyiCenterData GO SELECT name, database_id, cr...
2016-11-24, 427👍, 0💬

UPDATE Subquery Returning No Rows in SQL Server
What Happens If the UPDATE Subquery Returns No Rows in SQL Server? If you use a subquery to assign new values in the SET clause in an UPDATE statement, and the subquery returns no rows for an outer row, SQL Server will provide a NULL value to the SET clause. The tutorial exercise below shows you a g...
2016-11-02, 426👍, 0💬

Create Additional Tablespaces in Oracle
How To Create Additional Tablespaces for an New Database in Oracle? This is Step 8. Creating additional tablespaces can be done by using the CREATE TABLESPACE statement as shown in the following sample script: SQL&gt; CREATE TABLESPACE users 2 DATAFILE '/oraclexe/oradata/FYI/users01 .dbf'SIZE 10...
2019-03-27, 425👍, 0💬

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