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

"@@FETCH_STATUS" - Looping through Result Set in SQL Server
How To Loop through the Result Set with @@FETCH_STATUS in SQL Server Transact-SQL? The FETCH statement only returns one row from the result set. If you want to return all rows, you need to put the FETCH statement in a loop. A simple way to stop the loop to check the system variable @@FETCH_STATUS, w...
2016-10-17, 337👍, 0💬

Start and End of Statement in SQL Server Transact-SQL
How to start and end a statement in SQL Server Transact-SQL? Here are some simple rules about writing statements in SQL Server Transact-SQL: A Transact-SQL statement must be started with a pre-defined statement keyword. A Transact-SQL statement must be ended with a new line (/n) or a semicolon (;) c...
2017-05-29, 336👍, 0💬

Casting Strings to Wrong Code Pages in SQL Server Transact-SQL
What Happens If Strings Are Casted into Wrong Code Pages in SQL Server Transact-SQL? In SQL Server, different collations may use different code pages. For example: Albanian_CI_AI_KS_WS - Albanian, Code page 1250. Arabic_CI_AS_KS_WS - Arabic, Code page 1256. French_CI_AI - French, Code page 1252. Kor...
2017-05-13, 336👍, 0💬

Variables and Data Types in SQL Server Transact-SQL
Where to find answers to frequently asked questions on variables and data types in Microsoft SQL Server Transact-SQL? I am new to Transact-SQL and SQL Server. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com team on variables and data types in Microsoft SQL Se...
2017-04-22, 336👍, 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, 336👍, 0💬

sqlservr.exe - Process - SQL Server (SQLEXPRESS) in SQL Server
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the Microsoft SQL Server system service installed as part of the Microsoft SQL Server 2005 Express Edition. mscorsvw.exe process and program file info: CPU usage: 00% Memory usage: 1,316K Launching metho...
2016-12-08, 336👍, 0💬

Entering 0.001 Second in DATETIME in SQL Server Transact-SQL
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter milliseconds in data and time values, they will be rounded up to 10/3 millisecond increments, because DATETIME data type uses 4 bytes to store the time of the day. A 4-byte integer can only give an accuracy ...
2017-04-15, 335👍, 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.   ⇒Database Basics and Terminologies in MySQL ⇒⇒MySQL Database Tutorials
2017-07-07, 334👍, 0💬

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, 334👍, 0💬

Character Strings and Binary Strings in SQL Server Transact-SQL
Where to find answers to frequently asked questions on Character Strings and Binary Strings in SQL Server Transact-SQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Character Strings and Binary Strings in SQL Server Transact-SQL. Clear answers ...
2017-03-11, 334👍, 0💬

Where Is the Export Dump File Located in Oracle
Where Is the Export Dump File Located in Oracle? If you are not specifying the dump directory and file name, the dump file will be stored in the default dump directory with the default file name. The tutorial exercise below tells you find what is your default dump directory and locate the dump file....
2016-10-15, 334👍, 0💬

Database Basics and Terminologies in MySQL
Where to find answers to frequently asked questions on Database Basics and Terminologies in MySQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Database Basics and Terminologies in MySQL to help you review your knowledge. A short answer is prov...
2017-07-21, 333👍, 0💬

Quoting Text Values in MySQL
How To Quote Text Values in SQL Statements in MySQL? Text values in SQL statements should be quoted with single quotes ('). If the text value contains a single quote ('), it should be protected by replacing it with two single quotes (''). In SQL language syntax, two single quotes represents one sing...
2017-06-28, 333👍, 0💬

What Is a Statement in SQL Server Transact-SQL
What is a statement in SQL Server Transact-SQL? A statement in SQL Server Transact-SQL is a single smallest execution unit. Here are some examples of Transact-SQL statements: "PRINT 'Hello World!';" - An output statement that print a character string to the console. "SELECT GETDATE();" - A query sta...
2017-05-29, 333👍, 0💬

Verify Time Precision in SQL Server Transact-SQL
How to verify the precession of the server system time in SQL Server Transact-SQL? You can run a WHILE loop to check the precision of server system time in Transact-SQL as shown below: DECLARE @var DATETIME2(7); DECLARE @count INT = 0; WHILE @count&lt;100 BEGIN SET @count = @count + 1; SET @var ...
2017-02-22, 333👍, 0💬

What Is Index in MySQL
What Is Index in MySQL? An index is a single column or multiple columns defined to have values pre-sorted to speed up data retrieval speed.   ⇒Database Basics and Terminologies in MySQL ⇒⇒MySQL Database Tutorials
2017-07-07, 331👍, 0💬

What Is ISAM in MySQL
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and retrieve data on secondary storage systems like tapes.   ⇒Database Basics and Terminologies in MySQL ⇒⇒MySQL Database Tutorials
2017-07-03, 331👍, 0💬

General Questions on Microsoft SQL Server Transact-SQL
Where to find answers to frequently asked questions in general areas of Microsoft SQL Server Transact-SQL? I am new to Transact-SQL. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com team in general areas of Microsoft SQL Server Transact-SQL: What Is SQL Langua...
2017-06-16, 331👍, 0💬

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, 331👍, 0💬

What Is MyISAM in MySQL
What Is MyISAM in MySQL? MyISAM is a storage engine used as the default storage engine for MySQL database. MyISAM is based on the ISAM (Indexed Sequential Access Method) concept and offers fast data storage and retrieval. But it is not transaction safe.   ⇒Database Basics and Terminologies in MySQL ...
2017-07-03, 330👍, 0💬

Build WHERE Criteria with Web Form Data in MySQL
How To Build WHERE Criteria with Web Form Search Fields in MySQL? If your PHP script is linked to a Web form which takes search key words for multiple data fields. For example, your Web form asks your visitor to search for Website links with a URL search field, a Website title search field, a descri...
2017-06-23, 330👍, 0💬

Is SQL Server Transact-SQL Case Sensitive?
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard SQL, you can type in your Transact-SQL statement in upper case or lower case. However, you should use upper case for all key words in Transact-SQL statements as a best practice. The following example...
2017-06-16, 330👍, 0💬

What Is SQL Language
What Is SQL Language? SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Relational Database Management Systems). During the 1970s, a group at IBM's San Jose research center developed a database system "System R" based upon Codd's model. Structured English Query Language ("SEQ...
2017-06-16, 328👍, 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, 328👍, 0💬

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