<< < 1 2 3 4 5 6 7 8 9 10 11 > >>   Sort: Date

Single-Byte Character Data Types in SQL Server Transact-SQL
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte character string data types are used to hold single-byte character strings. There are 3 single-byte character string data types supported in SQL Server Transact-SQL: 1. CHAR (or CHARACTER) - Used to ho...
2017-04-08, 599👍, 0💬

Using Stored Procedures in SQL Server Transact-SQL
Where to find answers to frequently asked questions on Using Stored Procedures in SQL Server Transact-SQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Using Stored Procedures in SQL Server Transact-SQL. Clear answers are provided with tutorial...
2017-01-11, 599👍, 0💬

sys.sql_modules - Getting Trigger Definitions Back in SQL Server
How To Get the Definition of a Trigger Back in SQL Server? If you want get the definition of an existing trigger back from the SQL Server, you can use the catalog view called sys.sql_modules, which stores definitions of views, stored procedures, and triggers. The sys.sql_modules holds trigger defini...
2016-10-24, 599👍, 0💬

Statement Batch in SQL Server Transact-SQL
What is statement batch in SQL Server Transact-SQL? A statement batch is a group of one or more Transact-SQL statements sent at the same time from an application to SQL Server for execution. SQL Server compiles the statements of a batch into a single executable unit, called an execution plan. The st...
2017-05-29, 598👍, 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, 597👍, 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, 594👍, 0💬

Types of Data Literals in SQL Server Transact-SQL
What are different types of data literals supported in SQL Server Transact-SQL? There are 8 types of data literals supported in SQL Server Transact-SQL: 1. Integer Number Literals - Sequences of numbers prefixed with +/- sign if needed. Integer number literals are used to represent integer values. F...
2017-05-20, 592👍, 0💬

Unicode String Literals in SQL Server Transact-SQL
What are Unicode string literals supported in SQL Server Transact-SQL? Unicode string literals in Transact-SQL are sequences of characters enclosed in single quotes and prefixed with (N) as N'...'. String literals are used to provide values to string variables or table columns like NCHAR(40), NVARCH...
2017-05-05, 591👍, 0💬

Comments in SQL Server Transact-SQL Statements
How to enter comments in SQL Server Transact-SQL statements? There are 2 ways to enter comments within Transact-SQL statements: Starting comments with two dashes "--": Everything between "--" and the end of the line is treated as a comment. Entering comments between "/*" and "*/": Everything between...
2017-05-29, 589👍, 0💬

"sp_rename ... 'OBJECT'" - Renaming Existing Tables in SQL Server
How to rename an existing table with the "sp_rename" stored procedure in SQL Server? If you have an existing table and you want to change the table name, you can use the "sp_rename ... 'OBJECT'" stored procedure. "sp_rename" allows you to change names of COLUMN, DATABASE, INDEX, USERDATATYPE, and OB...
2016-11-15, 586👍, 0💬

Starting mysqld to Support BDB Storage Engine in MySQL
How To Start mysqld to Support the BDB Storage Engine in MySQL? The default "mysqld" program does not support the BDB storage engine. If you want to use the BDB storage engine, you can start MySQL server with the "mysqld-max" program. The tutorial exercise below shows you how to start "mysqld-max" a...
2017-08-13, 584👍, 0💬

What Is Join in MySQL
What Is Join in MySQL? Join is data retrieval operation that combines rows from multiple tables under certain matching conditions to form a single row.   ⇒Database Basics and Terminologies in MySQL ⇒⇒MySQL Database Tutorials
2017-07-07, 584👍, 0💬

Date/Time Data Type Comparison in SQL Server Transact-SQL
What are differences between date and time data types in SQL Server Transact-SQL? I want to compare of date and time data types? Here is a comparison table of all date and time data types supported in SQL Server Transact-SQL: Data type Storage size Precision Default Format / (bytes) Value range ----...
2017-02-25, 584👍, 0💬

Revoking User Privileges in MySQL
How To Revoke User Privileges in MySQL? If your want remove some granted user privileges, you can use the "REVOKE privilegeName ..." command. You can only revoke privileges in the same way as they were granted. For example, you can not revoke a privilege on a specific database, if that privilege was...
2017-08-21, 583👍, 0💬

Converting DATETIME and NUMERIC Values in SQL Server
Are DATETIME and NUMERIC Values Convertible in SQL Server Transact-SQL? Are datetime and numeric value convertible? The answer is yes. Here are the main rules on DATATIME and NUMERIC value conversions: During the conversion a DATETIME value will be treated as a NUMERIC value with the number of days ...
2017-02-22, 583👍, 0💬

Testing New User Account and Password in MySQL
How To Test a New User Account and Password in MySQL? If you have new user created with a password, you test it using "mysql" program with the "-u" and "-p" options. The following tutorial exercise shows you some interesting use cases of connecting to the server with user names and passwords: &g...
2017-09-08, 581👍, 0💬

Show Storage Engines Supported in MySQL in MySQL
How To See Which Storage Engines Are Supported in Your MySQL Server in MySQL? If you want to know exactly which storage engines are supported in your MySQL server, you can run the "SHOW ENGINES" command as shown in the tutorial example below: mysql&gt; SHOW ENGINES; +------------+---------+-----. ..
2017-08-08, 579👍, 0💬

Analyze Tables with "mysqlcheck" Command in MySQL
How To Analyze Tables with "mysqlcheck" in MySQL? If you want analyze tables with "mysqlcheck", you need to use the "--analyze" option. The following tutorial exercise shows you how to analyze all tables in "mysql" database: &gt;cd \mysql\bin &gt;mysqlcheck -u root --analyze mysql mysql.colu...
2018-02-28, 578👍, 0💬

Tables Using MEMORY Storage Engine in MySQL
How To Create a New Table Using the MEMORY Storage Engine in MySQL? MEMORY storage engine stores table data in computer system memory. This is good for creating temporary tables. MEMORY is not the default storage engine. You need to specify "ENGINE = MEMORY" at the end of the "CREATE TABLE" statemen...
2017-08-08, 578👍, 0💬

Converting Numeric Data Types by Assignment Operations in SQL Server
How To Convert Numeric Expression Data Types by Assignment Operations in SQL Server Transact-SQL? An assignment operation is used to assign an expression to a variable, a column, or a parameter. If the data type of the expression does not match the data type of the receiving variable, column, or par...
2017-03-27, 577👍, 0💬

Binary String Data Types in SQL Server Transact-SQL
What are binary string data types supported in SQL Server Transact-SQL? Binary string data types are used to hold binary character strings. There are 3 binary string data types supported in SQL Server Transact-SQL: 1. BINARY - Used to hold binary strings of a fixed length, specified in the format of...
2017-04-04, 576👍, 0💬

Approximate Numeric Literals in SQL Server Transact-SQL
What are approximate numeric literals supported in SQL Server Transact-SQL? Approximate numeric literals in Transact-SQL are numbers written in scientific notation formats. Approximate numeric literals are used to provide values to approximate numeric variables or table columns like LOAT(24), DOUBLE...
2017-05-05, 575👍, 0💬

Giving Privileges at Server Level in MySQL
How To Grant User Privileges at the Global Level in MySQL? If you want to grant a user privilege at the global level, you can use the "GRANT privilegeName ON *.* TO userName" command. The argument "*.*" in the command stands for all database and all tables. The following tutorial exercise shows you ...
2017-08-21, 574👍, 0💬

PRINT Statements in SQL Server Transact-SQL
How to print value on console in SQL Server Transact-SQL? How to use the PRINT statements? In Transact-SQL, you can use PRINT statements to print values on the console of the client tool, in the syntax of: PRINT &lt;value&gt; When a PRINT statement is executed, the system will: Print the val...
2017-04-01, 573👍, 0💬

<< < 1 2 3 4 5 6 7 8 9 10 11 > >>   Sort: Date