General MySQL Oracle SQL Server

<< < … 9 10 11 12 13 14 15 16 17 18 19 … > >>   ∑:509  Sort:Date

DECLARE Statements in SQL Server Transact-SQL
How to declare a variable in SQL Server Transact-SQL? How to use the DECLARE statements? In Transact-SQL, you must use DECLARE statements to declare variables. Declaring a variable is to define the variable name and the variable data type. In Transact-SQL, you can: Declare a single variable in a sin... 2017-04-04, 3093🔥, 0💬

Creating Triggers for INSERT Statements Only in SQL Server
How To Create a Trigger for INSERT Only in SQL Server? The trigger, dml_message, provided in previous tutorials was defined to handle all 3 types of DML statements, INSERT, UPDATE, and DELETE. If you do not want the trigger to handle all 3 types of DML statements, you can list only 1 or 2 of the sta... 2016-10-24, 3091🔥, 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, 3090🔥, 0💬

Adding Address Records into AdventureWorksLT in SQL Server
How to add an address record into AdventureWorksLT in SQL Server? To find out if we can add data into AdventureWorksLT or not, you can try to add an address record into the "SalesLT.Address" in AdventureWorksLT: USE AdventureWorksLT GO INSERT SalesLT.Address (AddressLine1, City, StateProvince, Count... 2016-12-02, 3089🔥, 0💬

"CREATE TRIGGER" - Creating a DDL Trigger in SQL Server
How To Create a DDL Trigger using "CREATE TRIGGER" Statements in SQL Server? A DDL trigger is defined to handle a DDL statement event, like create, alter and drop tables, views, indexes, etc. DDL triggers can be used to generate warning messages on database object changes. The format of creating a D... 2016-10-22, 3087🔥, 0💬

Defining and Using Table Alias Names in SQL Server
How To Define and Use Table Alias Names in SQL Server? When column names need to be prefixed with table names, you can define table alias name and use them to prefix column names. To define an alias for a table name, just enter the alias name right after the original table name in the FROM clause as... 2016-10-30, 3084🔥, 0💬

"DROP DATABASE" - Deleting Databases in SQL Server
How to delete a database in SQL Server? If you created a database incorrectly, or you have a database that is not needed any more, you can delete it with the "DROP DATABASE" statement with this syntax: DROP DATABASE database_name For example, execute this statement: DROP DATABASE FyiCenterData GO Th... 2016-11-24, 3083🔥, 0💬

Importance of Column Order in the SET Clause in Update Statements in SQL Server
Is the Order of Columns in the SET Clause Important in SQL Server? The answer is NO. The order of columns in the SET clause of the UPDATE statement is NOT important. You probably already noticed from the previous tutorial. There is a BIG DIFFERENCE among SQL Server, MySQL and Oracle on update multip... 2016-11-02, 3079🔥, 0💬

Using Cursors in SQL Server Transact-SQL
Where to find answers to frequently asked questions on Using Cursors in SQL Server Transact-SQL? I want to loop through rows in a result set. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Using Cursors in SQL Server Transact-SQL. Clear explanati... 2016-10-17, 3073🔥, 0💬

Primary Key - Default Indexes of Tables in SQL Server
Is the PRIMARY KEY Column of a Table an Index in SQL Server? If you define a primary key on a table, an index for the primary key column will be created by default. The tutorial exercise below shows you the index created as part of the primary key column of "fyi_links": USE FyiCenterData; GO -- Drop... 2016-11-13, 3072🔥, 0💬

PHP ODBC - Including Date and Time Values in SQL Statements
PHP ODBC - How To Include Date and Time Values in SQL Statements? If you want to provide date and time values in a SQL statement, you should write them in the format of "yyyy-mm-dd hh:mm:ss", and quoted with single quotes ('). The tutorial exercise below shows you two INSERT statements. The first on... 2024-05-05, 3067🔥, 0💬

Returning the Second 5 Rows from a Query in SQL Server
How To Return the Second 5 Rows in SQL Server? If you want to display query output in multiple pages with 5 rows per page, and the visitor wants to see the output for the second page, you need to display query output from row 6 to row 10. If you are using MySQL server, you can use the "LIMIT startRo... 2016-10-29, 3067🔥, 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, 3064🔥, 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, 3059🔥, 0💬

Index Speeding Up SELECT Statements in SQL Server
Does Index Speed Up SELECT Statements in SQL Server? If you want to see the impact of indexes on SELECT statements, you can run the same SELECT statement on "fyi_links" and "fyi_links_indexed" tables. See the tutorial exercise below: USE FyiCenterData; GO -- Run SELECT on the table without indexes D... 2016-11-13, 3056🔥, 0💬

Differences of CHAR and NCHAR in SQL Server Transact-SQL
What Are the Differences between CHAR and NCHAR in SQL Server Transact-SQL? Both CHAR and NCHAR are fixed length data types in Transact-SQL. But they have the following main differences: CHAR stores characters based on the code page with 1 byte per character most of the time. NCHAR stores characters... 2017-04-04, 3054🔥, 0💬

Performing Comparison on Exact Numbers in SQL Server
How To Perform Comparison on Exact Numbers in SQL Server Transact-SQL? Comparison operations on exact numbers of data types: BIT, INT, NUMERIC, etc., are very easy to understand. Here are some simple examples: -- BIT value comparison DECLARE @x BIT, @y BIT; SET @x = 0; SET @y = 1; SELECT CASE WHEN @... 2017-01-21, 3053🔥, 0💬

Creating Databases with Specified Physical Files in SQL Server
How to create database with physical files specified in SQL Server? If you don't like the default behavior of the CREATE DATABASE statement, you can specify the physical database files with a longer statement: CREATE DATABASE database_name ON (NAME = logical_data_name, FILENAME = physical_data_name,... 2016-11-24, 3052🔥, 0💬

odbc_tables() - Listing All Tables in the Database
How To List All Tables in the Database using odbc_tables()? If you want to get a list of all tables in the database, you can use the odbc_tables() function, which can actually be used to list all tables and views in the database. The syntax of odbc_tables() is: $result_set = odbc_tables($connection_... 2024-07-11, 3048🔥, 0💬

Renaming Database Names in SQL Server
How to rename databases in SQL Server? If don't like the name of a database, you can change it by using the "ALTER DATABASE" statement with the following syntax: ALTER DATABASE database_name MODIFY NAME = new_database_name The tutorial example below shows you how change the database name from "FyiCe... 2016-11-24, 3030🔥, 0💬

Deleting All Rows with TRUNCATE TABLE Statement in SQL Server
How To Delete All Rows with TRUNCATE TABLE Statement in SQL Server? 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... 2016-10-30, 3024🔥, 0💬

Testing DML Triggers in SQL Server
How To Test a DML Trigger in SQL Server? To test a DML trigger defined on a table, you just need to execute several INSERT, UPDATE and DELETE statements on that table as shown in this tutorial example: USE FyiCenterData; GO INSERT INTO fyi_users (name) VALUES ('FYI Admin'); GO Records are inserted, ... 2016-10-25, 3024🔥, 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, 3023🔥, 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, 3020🔥, 0💬

<< < … 9 10 11 12 13 14 15 16 17 18 19 … > >>   ∑:509  Sort:Date

General MySQL Oracle SQL Server