<< < 8 9 10 11 12 13 14 15 16 17 18 > >>   ∑:1354  Sort:Date

Generating CREATE PROCEDURE Scripts on Existing Stored Procedures in SQL Server
How To Generate CREATE PROCEDURE Script on an Existing Stored Procedure in SQL Server Transact-SQL? If you want to know how an existing stored procedure was created, you can use SQL Server Management Studio to automatically generate a "CREATE PROCEDURE" script The following tutorial shows you how to...
2017-01-05, 3143🔥, 0💬

EXECUTE - Executing Stored Procedures in SQL Server
How To Execute a Stored Procedure in SQL Server Transact-SQL? If you want execute a stored procedure created previously, you can use the EXECUTE statement in the following formats: EXEC procedure_name; EXECUTE procedure_name; The key word EXEC is actually optional. So you can execute a stored proced...
2017-01-05, 3141🔥, 0💬

sys.indexes - Viewing Existing Indexes on an Given Table in SQL Server
How To View Existing Indexes on an Given Table using sys.indexes in SQL Server? Another way to view existing indexes defined for a given table is to use the system view called "sys.indexes". The tutorial exercise shows you how many indexes were defined from the previous tutorial on table "fyi_links"...
2016-11-15, 3138🔥, 0💬

What Is a Server Parameter File in Oracle
What Is a Server Parameter File in Oracle? A server parameter file is a binary file that acts as a repository for initialization parameters. The server parameter file can reside on the machine where the Oracle database server executes. Initialization parameters stored in a server parameter file are ...
2020-07-07, 3127🔥, 0💬

What Is NULL Value in Oracle
What Is NULL Value in Oracle? NULL is a special value representing "no value" in all data types. NULL can be used on in operations like other values. But most operations has special rules when NULL is involved. The tutorial exercise below shows you some examples: SET NULL 'NULL'; -- Make sure NULL i...
2019-12-02, 3126🔥, 0💬

Set Up Breakpoints in Debug Mode in Oracle
How To Set Up Breakpoints in Debug Mode in Oracle? To debug a stored procedure, you need to set breakpoints at different statements in the code block, so that execution will be stopped at the statement marked with a breakpoint. When execution is stopped, you can then investigate different variables ...
2018-12-26, 3126🔥, 0💬

Connect to MySQL Server without Port Number in MySQL
How To Connect to a MySQL Server with Default Port Number in MySQL? If you want to connect a MySQL server with default port number, you can use the "mysql_connect($server)" function, where $server is the host name or IP address where the MySQL server is running. If successful, mysql_connect() will r...
2017-07-30, 3125🔥, 0💬

Difference between BINARY and VARBINARY in MySQL
What Are the Differences between BINARY and VARBINARY in MySQL? Both BINARY and VARBINARY are both binary byte data types. But they have the following major differences: BINARY stores values in fixed lengths. Values are padded with 0x00. VARBINARY stores values in variable lengths. Values are not pa...
2018-01-19, 3121🔥, 0💬

Versions of SQL Server Transact-SQL
How do I tell what version of Transact-SQL my SQL Server is using? The Transact-SQL version is the same as the SQL Server. You can determine the SQL Server version using the following Transact-SQL statement: SELECT @@version ------------------------------ ------------------------------ ------------Mi...
2017-06-16, 3121🔥, 0💬

Create a Test Table for Transaction Testing in Oracle
How To Create a Test Table for Transaction Testing in Oracle? If you want to practice DML statements, you should create a testing table as shown in the script below: &gt;cd (OracleXE home directory) &gt;.\bin\sqlplus /nolog SQL&gt; connect HR/fyicenter Connected. SQL&gt; CREATE TABLE...
2019-09-04, 3112🔥, 0💬

Limitations of Oracle Database 10g XE in Oracle
What Are the Limitations of Oracle Database 10g XE in Oracle? Oracle Database XE is free for runtime usage with the following limitations: Supports up to 4GB of user data (in addition to Oracle system data) Single instance only of Oracle Database XE on any server May be installed on a multiple CPU s...
2020-05-05, 3111🔥, 0💬

JSON_SET() - Inserting/updating JSON Child Members
How to insert or update child members of a JSON (JavaScript Object Notation) value using the JSON_SET() function? JSON_SET(json, path1, val1, path2, val2, ...) is a MySQL built-in function that inserts child members of a JSON value at given new locations, and replaces child numbers at given existing...
2025-03-12, 3109🔥, 0💬

"mysql" Command Line Arguments in MySQL
What Are the "mysql" Command Line Arguments in MySQL? "mysql" supports only one optional command line argument, "database". But "mysql" allows the operating system to redirect input and output streams at the command line level. Here are some good examples: "mysql databaseName" - Starts "mysql" in in...
2018-04-28, 3108🔥, 0💬

Create an Array in PL/SQL in Oracle
How To Create an Array in PL/SQL in Oracle? If you want create an array data structure, you can use the collection type VARRAY. VARRAY stands for Variable Array. Here is a sample script on how to use VARRAY: SQL&gt; set serveroutput on; SQL&gt; DECLARE 2 TYPE list IS VARRAY(3) OF VARCHAR(16)...
2019-03-08, 3106🔥, 0💬

What Is mSQL in MySQL
What Is mSQL in MySQL? Mini SQL (mSQL) is a light weight relational database management system capable of providing rapid access to your data with very little overhead. mSQL is developed by Hughes Technologies Pty Ltd. MySQL was started from mSQL and shared the same API.   ⇒ What Is SQL in MySQL ⇐ ...
2017-07-15, 3106🔥, 0💬

Differences between INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND in Oracle
What Are the Differences between INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND in Oracle? The main differences between INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND are: INTERVAL YEAR TO MONTH stores values as time intervals at the month level. INTERVAL DAY TO SECOND stores values as time in...
2020-04-25, 3104🔥, 0💬

Load Data with SQL*Loader in Oracle
How To Load Data with SQL*Loader in Oracle? Let's say you have a table defined as: CREATE TABLE student (id NUMBER(5) PRIMARY KEY, first_name VARCHAR(80) NOT NULL, last_name VARCHAR(80) NOT NULL, birth_date DATE NOT NULL, social_number VARCHAR(80) UNIQUE NOT NULL); There is an input data file stored...
2016-11-27, 3092🔥, 0💬

sys.views - List of Existing Views in SQL Server
How To See Existing Views in SQL Server? If you want to know how many views you have created in a database, you use the system view called sys.views to get a list of views defined in the current database. The tutorial exercise shows you how many views in database FyiCenterData: USE FyiCenterData; GO...
2016-11-05, 3092🔥, 0💬

How do I call MySQL SP from oracle using HS link ?
How do I call MySQL Stored Procedure from oracle using HS link ? HS link is correct and I can get the tables data just by adding '@' at the end of the table name ,but I can't call the SP same way ! Help please.
2022-01-24, 3086🔥, 0💬

List All Existing Databases in MySQL
How To Get a List of Databases from MySQL Servers in MySQL? Once you got a MySQL server connection object successfully, you need to know what databases are available on the server and which database you should use to manage your tables and data. To get a list of all available databases on your MySQL...
2017-11-11, 3085🔥, 0💬

What Are Named Parameters in Oracle
What Are Named Parameters in Oracle? Named parameters are actual parameters specified not by position but by providing formal parameter names when calling the procedure or function. The main advantage of named parameters is that the caller don't have to remember the position of each parameter. But t...
2018-10-13, 3083🔥, 0💬

Selecting Some Specific Columns from a Table in SQL Server
How To Select Some Specific Columns from a Table in a Query in SQL Server? If you want explicitly tell the query to return some specific columns, you can specify the column names in the SELECT clause. The following select statement returns only three columns, "id", "created" and "url" from the table...
2016-10-26, 3081🔥, 0💬

"ALTER INDEX ... REBUILD" - Defragmenting Indexes in SQL Server
How To Rebuild Indexes with ALTER INDEX ... REBUILD in SQL Server? When an index is defragmented to a large percentage, like &gt; 30%, you can use the "ALTER INDEX ... REBUILD" statement to rebuild the index. Here is a tutorial exercise on rebuilding indexes: USE FyiCenterData; GO UPDATE fyi_lin...
2016-11-08, 3080🔥, 0💬

Approximate Numeric Data Types in SQL Server Transact-SQL
What are approximate numeric data types supported in SQL Server Transact-SQL? Approximate numeric data types are used to hold numeric values with floating scales. There are 3 different approximate numeric data types supported in SQL Server Transact-SQL: 1. FLOAT - Used to hold values with different ...
2017-04-19, 3078🔥, 0💬

<< < 8 9 10 11 12 13 14 15 16 17 18 > >>   ∑:1354  Sort:Date