General MySQL Oracle SQL Server

<< < … 38 39 40 41 42 43 44 45 46 47 48 … > >>   ∑:1354  Sort:Date

"CREATE SCHEMA" - Creating a New Schema in a Database in SQL Server
How To Create a New Schema in a Database in SQL Server? If you want to create a new schema in an existing database, you can use the "CREATE SCHEMA" statement as shown in the tutorial example below: USE FyiCenterData; GO CREATE SCHEMA fyi; GO Command(s) completed successfully. A new schema called "fy... 2016-10-22, 2385🔥, 0💬

Use Existing Column Values in SET Clause in Oracle
How To Use Existing Values in UPDATE Statements in Oracle? If a row matches the WHERE clause in a UPDATE statement, existing values in this row can be used in expressions to provide new values in the SET clause. Existing values are represented by columns in the expressions. The tutorial exercise bel... 2020-01-21, 2384🔥, 0💬

Updating Values with UPDATE Statements in SQL Server
How To Update Values in a Table with UPDATE Statements in SQL Server? 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: SELECT * FROM fyi_links WHERE id = 101 GO id url notes counts created 101 ... 2016-11-02, 2384🔥, 0💬

What Is a Database in SQL Server
What is a database in SQL Server? A database is a logical container that contains a set of related database objects: Tables - Storages of structured data. Views - Queries to present data from tables. Indexes - Sorting indexes to speed up searches. Stored Procedures - Predefined SQL program units. Us... 2016-11-24, 2383🔥, 0💬

Adding a New Index to a Large Table in SQL Server
What Happens If You Add a New Index to Large Table in SQL Server? An index can be added when you create a new table. New rows will be indexed as they are inserted into the table. But you can also add a new index to an existing table with the same CREATE INDEX statement. The existing rows will be ind... 2016-11-13, 2383🔥, 0💬

What Do You Think about PL/SQL in Oracle
What Do You Think about PL/SQL in Oracle? After following through the tutorials in the FAQ collection, you probably agree that PL/SQL is indeed a general purpose database programming language. PL/SQL is a natural extension of SQL. It is very useful for DBA to automate specific administration tasks o... 2019-02-18, 2382🔥, 0💬

What Is Foreign Key in MySQL
What Is Foreign Key in MySQL? A foreign key is a single column or multiple columns defined to have values that can be mapped to a primary key in another table.   ⇒ What Is Index in MySQL ⇐ What Is Primary key in MySQL ⇑ Database Basics and Terminologies in MySQL ⇑⇑ MySQL Database Tutorials 2017-07-07, 2382🔥, 0💬

Selecting Other User's Database in MySQL
Can You Select Someone Else Database in MySQL? If your MySQL server is provided by an Internet service company, they will provide you one database for your use only. There are many other databases on the server for other users. But your user account will have no privilege to select other databases. ... 2017-10-23, 2381🔥, 0💬

Invoke Original Export/Import Utiities in Oracle
How To Invoke Original Export/Import Utilities in Oracle? If you really want to run the original export import utilities, you can still go to "bin" directory of the Oracle server path and run the "exp" or "imp" command. The tutorial exercise below tells you how to run the export and import utilities... 2016-10-15, 2381🔥, 0💬

"SELECT" Statements - Reading the Data In a Table in SQL Server
How to read data in a table with "SELECT" statements in SQL Server? This is the fourth tutorial of a quick lesson on creating database objects with Transact-SQL statements. This lesson shows you how to create a database, create a table in the database, and then access and change the data in the tabl... 2016-12-02, 2380🔥, 0💬

Deleting a Table That Is Used by a View in SQL Server
What Happens If You Delete a Table That Is Used by a View in SQL Server? Assuming that you have a table which is used by a view, and you try to delete that table. SQL Server will let you delete the table without any trouble. But that view will become invalid. The tutorial exercise below shows you wh... 2016-11-04, 2379🔥, 0💬

Drop an Existing Index in MySQL
How To Drop an Existing Index in MySQL? If you don't need an existing index any more, you should delete it with the "DROP INDEX indexName ON tableName" statement. Here is an example SQL script: mysql&gt; DROP INDEX tip_subject ON tip; Query OK, 0 rows affected (0.13 sec) Records: 0 Duplicates: 0... 2018-02-14, 2378🔥, 0💬

Number of Rows Selected or Affected in MySQL
How To Get the Number of Rows Selected or Affected by a SQL Statement in MySQL? There are two functions you can use the get the number of rows selected or affected by a SQL statement: mysql_num_rows($res) - Returns the number of rows selected in a result set object returned from SELECT statement. my... 2017-10-08, 2377🔥, 0💬

Duplicate Key Error on Primary Key Columns in SQL Server
What Happens If You Insert a Duplicate Key for the Primary Key Column in SQL Server? If your table has a primary key column, and you are trying to insert a new row with duplicate key value on the primary key column, you will get an error. The reason is simple - Primary key column does not allow dupl... 2016-11-02, 2377🔥, 0💬

MS SQL Server DBA Checklist - General DBA Best Practices
-- Join (or start) a local SQL Server users group -- Attend at least one professional conference each year. -- Attend at least one training session each year. -- Read at least four books on SQL Server each year. -- Read the free e-book, How to Become an Exceptional DBA -- Learn everything you can ab... 2022-01-24, 2375🔥, 0💬

Rebuilding All Indexes on One Table in SQL Server
How To Rebuild All Indexes on a Single Table in SQL Server? If you have several indexes on a single table and want to rebuild all of them, you may use the "ALTER INDEX ALL ON table_name REBUILD" statement as shown in the tutorial exercise below: USE FyiCenterData; GO UPDATE fyi_links_indexed SET url... 2016-11-08, 2375🔥, 0💬

Starting SQL Server Browser Service
How To Start SQL Server Browser Service? SQL Server Browser Service is installed as part of the SQL Server. But it is turned off by default to reduce the security risk. If you want start SQL Server Browser Service to allow the SQL Server to accept network connections, you need to follow the steps be... 2024-07-25, 2374🔥, 0💬

Turning Off PHP Warning Messages for ODBC Connection
How To Turn Off Warning Messages during PHP Execution? If don't want see warning messages generated from the PHP engine when executing PHP scripts, you can change the error_reporting setting in the php.ini configuration file. Open php.ini and change the following lines: ;error_reporting = E_ALL &... 2024-06-30, 2374🔥, 0💬

PHP MSSQL - mssql_rows_affected() - Number of Affected Rows
PHP MSSQL - How To Get the Number of Affected Rows? If you insert multiple rows with a single INSERT statement, you can use the mssql_rows_affected() function to find out how many rows were inserted. mssql_rows_affected($connectio n)returns the number of affected rows of the last INSET, UPDATE or DE... 2024-02-28, 2374🔥, 0💬

List All Tables with "mysql" Command in MySQL
How To Show All Tables with "mysql" in MySQL? If you want to see all the tables in a database, you run the non-SQL command "SHOW TABLES" at the "mysql" prompt. See the following tutorial exercise for example: &gt;cd \mysql\bin &gt;mysql -u root test Welcome to the MySQL monitor. Commands end... 2018-02-28, 2374🔥, 0💬

Performing Comparison on Floating Point Numbers in SQL Server
How To Perform Comparison on Floating Point Numbers in SQL Server Transact-SQL? Comparison operations on approximate (floating point) numbers are also easy to understand. Just watch out rounding operations performed during conversions. Here are two examples of floating point number comparisons: -- R... 2017-01-21, 2374🔥, 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, 2373🔥, 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, 2372🔥, 0💬

What Is Oracle SQL Developer in Oracle
What Is Oracle SQL Developer in Oracle? Oracle SQL Developer is a new, free graphical tool that enhances productivity and simplifies database development tasks. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also... 2019-02-18, 2371🔥, 0💬

<< < … 38 39 40 41 42 43 44 45 46 47 48 … > >>   ∑:1354  Sort:Date

General MySQL Oracle SQL Server