General MySQL Oracle SQL Server

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

Passing Values to User Defined Function Parameters in SQL Server
How To Provide Values to User Defined Function Parameters in SQL Server Transact-SQL? If a user defined function is created with parameters, you need pass values to those parameters when calling the function with one of two formats listed below: expression... function_name(value_1, value_2, ... valu... 2016-12-18, 3206🔥, 0💬

odbc_prepare() - Creating Prepared Statements
How To Create Prepared Statements using odbc_prepare()? If you have a SQL statement that need to executed repeatedly many times with small changes, you can create a prepared statement object with parameters so it can be executed more efficiently. There are two functions you need to use prepare and e... 2024-06-03, 3200🔥, 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, 3198🔥, 0💬

"CREATE VIEW/PROCEDURE" Statements - Creating a View and a Stored Procedure in SQL Server
How to create a view and a stored procedure using "CREATE VIEW/PROCEDURE" statements in SQL Server? This is the third tutorial of a quick lesson on creating login and configure users for databases with Transact-SQL statements. Granting a user access to a database involves three steps. First, you cre... 2016-11-27, 3193🔥, 0💬

Understanding and Managing Indexes in SQL Server
Where to find answers to frequently asked questions on Understanding and Managing Indexes in SQL Server? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Understanding and Managing Indexes in SQL Server. Clear answers are provided with tutorial exe... 2016-11-15, 3192🔥, 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, 3192🔥, 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, 3192🔥, 0💬

List of Data Types in SQL Server Transact-SQL
How many data types supported in SQL Server Transact-SQL? I want a list of all data types. Here is a list of all Transact-SQL data types divided into 6 categories: 1. Exact Number - Used to hold numeric values truncated to a specific precision and scale. BIGINT - Used to hold big integers. INT (or I... 2017-04-22, 3182🔥, 0💬

Differences of CHAR and VARCHAR in SQL Server Transact-SQL
What Are the Differences between CHAR and VARCHAR in SQL Server Transact-SQL? CHAR and VARCHAR are both used to store code page based 1-byte character strings in Transact-SQL. But they have the following main differences: CHAR(n) stores character strings with a fixed length, n bytes, storage format.... 2017-04-04, 3182🔥, 0💬

Working with NULL Values in SQL Server Transact-SQL
Where to find answers to frequently asked questions on Working with NULL Values in SQL Server Transact-SQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Working with NULL Values in SQL Server Transact-SQL. Clear explanations and tutorial exerci... 2017-02-08, 3178🔥, 0💬

Triggers with Multiple Affected Rows in SQL Server
What Happens to a Trigger with Multiple Affected Rows in SQL Server? If there is only one row affected by a DML statement, we know that the DML trigger will be executed once. But how many times the DML trigger will be executed if the DML statement resulted multiple affected rows? The answer is still... 2016-10-24, 3176🔥, 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, 3175🔥, 0💬

Renaming an Existing Column with Management Studio in SQL Server
How to rename an existing column with SQL Server Management Studio in SQL Server? If you are using SQL Server Management Studio, you can rename almost any data objects through the Object Explorer window. The tutorial example below shows you how to rename a column: 1. Run SQL Server Management Studio... 2016-11-15, 3174🔥, 0💬

Creating User Defined Functions with Parameters in SQL Server
How To Create User Defined Functions with Parameters in SQL Server Transact-SQL? Very often, you need to create a function with one or more parameters so that the function can be more generic. You only supply values to those parameters at the time of executing the function. User defined functions wi... 2016-12-18, 3169🔥, 0💬

"CREATE TABLE" Statement - Creating New Tables in SQL Server
How to create new table with "CREATE TABLE" statements in SQL Server? This is the second 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 ta... 2016-12-02, 3165🔥, 0💬

What Are NULL Values in SQL Server
What Are NULL Values in SQL Server Transact-SQL? A NULL value is a special value that represents an unknown value. SQL Server supports NULL values with the following features: All data types used for table columns support NULL values. In another word, NULL values can be stored in database tables. In... 2017-02-05, 3164🔥, 0💬

Database in Use When Dropping a Database in SQL Server
Why I am getting this error when dropping a database in SQL Server? If you are trying to drop a database that is in use, you will get an error message like this: 'Cannot drop database "FyiCenterData" because it is currently in use.' Before dropping a database, you must stop all client sessions using... 2016-11-24, 3164🔥, 0💬

"CREATE LOGIN" - Creating a New Login Name in SQL Server
How To Create a New Login Name in SQL Server in SQL Server? In previous tutorials, it is assumed that you use the "sa" (System Administrator) login name to connect to your SQL Server. But that is not what a normal developer uses to connect to the server, since "sa" has the ALL permissions granted. Y... 2016-10-20, 3159🔥, 0💬

SP_HELP - Viewing Existing Indexes on an Given Table in SQL Server
How To View Existing Indexes on an Given Table using SP_HELP in SQL Server? If you want to know how many indexes have been defined for a given table, you can use the SP_HELP built-in stored procedure in the following syntax: EXEC SP_HELP table_name -- Returns all database objects related the given t... 2016-11-15, 3158🔥, 0💬

Installing SQL Server 2005 Express Edition in SQL Server
How to install SQL Server 2005 Express Edition in SQL Server? Once you have downloaded SQL Server 2005 Express Edition, you should follow this tutorial to install it on your system: 1. Double click SQLEXPR.EXE. The setup window shows up. 2. Click Next to let the setup program to unpack all files fro... 2016-12-08, 3148🔥, 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, 3148🔥, 0💬

Character String Functions Supported by SQL Server 2005 in SQL Server
What Are the Character String Functions Supported by SQL Server 2005 in SQL Server Transact-SQL? SQL Server 2005 supports 23 character string functions: ASCII(char) - Returning the code value of a non-Unicode character. CHAR(int) - Returning the non-Unicode character of a code value. CHARINDEX(word,... 2017-03-07, 3147🔥, 0💬

odbc_exec() - Executing SQL Statements
How To Execute a SQL Statement using odbc_exec()? Once you have created an ODBC connection object, you can use the odbc_exec() function to send a SQL statement to the SQL Server linked to the connection object for execution. Here is a simple PHP script that creates a new schema and a new table: &... 2024-06-30, 3145🔥, 0💬

Date-Only DATETIME Values in SQL Server Transact-SQL
What Happens If Date-Only Values Are Provided for DATETIME in SQL Server Transact-SQL? If only date value is provided in a DATETIME variable, the SQL Server will pad the time value with a zero, or '00:00:00.000', representing the midnight time of the day. The tutorial exercise below gives you some g... 2017-04-08, 3140🔥, 0💬

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

General MySQL Oracle SQL Server