Oracle Database Tutorials
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for Oracle DBAs and Oracle database application developers. Clear explanations and simple examples provided can be used as learning tutorials or interview preparation guides. It doesn't matter whether yo... 2017-07-10, 2975👍, 2💬
"ALTER USER" - Changing the Name of a Database User in SQL Server
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existing database user, you can use the "ALTER USER" statement as shown in the tutorial exercise below: -- Login with "sa" USE FyiCenterData; GO ALTER USER Fyi_User WITH NAME = Dba_User; GO -- List all user... 2017-08-25, 648👍, 0💬
sys.database_principals - Listing All User Names in SQL Server
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names defined in a database, you can use the system view, sys.database_principals as shown in this tutorial exercise: -- Login with sa -- Select a database USE FyiCenterData; GO -- List all user names SELEC... 2017-08-25, 569👍, 0💬
Verifying a User Name with SQLCMD Tool in SQL Server
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in a database is probably to use the SQLCMD tool. You can connect to the server, select the database, and check which user name is linked the current login name as shown below. Start a command window and... 2017-08-25, 443👍, 0💬
Finding the Login Name Linked to a Given User Name in SQL Server
How To Find the Login Name Linked to a Given User Name in SQL Server? If you know a user name in a database and you want to find out which login name is linked this user name, you need to check the Security ID (SID) of the user name based on the following rules: Each login name is associated a uniqu... 2017-08-25, 417👍, 0💬
"DROP USER" - Deleting a Database User in SQL Server
How To Delete an Existing Database User in SQL Server? If you don't want to keep a database user any more, you should delete the user by using the "DROP USER" statement. This tutorial exercise shows how to delete "Dba_User": -- Login with "sa" USE FyiCenterData; GO DROP USER Dba_User; GO -- List all... 2017-08-25, 376👍, 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, 444👍, 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, 408👍, 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, 403👍, 0💬
What Is SQL Server Transact-SQL (T-SQL)?
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension of the standard SQL (Structured Query Language). Transact-SQL was developed by Microsoft and Sybase. Microsoft's implementation ships in the Microsoft SQL Server product. Sybase uses the language in ... 2017-06-16, 399👍, 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, 388👍, 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, 430👍, 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, 419👍, 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, 398👍, 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, 394👍, 0💬
Compilation Error in a Statement Batch in SQL Server
What happens to a Transact-SQL statement batch if there is a compilation error? If a Transact-SQL statement batch has multiple statements, and one of them has compilation error, none of the statements in the batch will be executed. The tutorial exercise below gives you some good examples: SELECT get... 2017-05-29, 383👍, 0💬
Constant or Data Literal in SQL Server Transact-SQL
What Is a Constant or Literal in SQL Server Transact-SQL? A constant, or data literal, is a symbolic expression that represents a specific value of a specific data type in SQL Server Transact-SQL. Constants or literals are used commonly as the default values for table columns, variables, and paramet... 2017-05-20, 459👍, 0💬
SQL Server Transact-SQL Language References
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL language references on Microsoft Website: Transact-SQL Reference for SQL Server 2016 Transact-SQL Reference for SQL Server 2014 Transact-SQL Reference for SQL Server 2012 Transact-SQL Reference for SQL Se... 2017-05-20, 446👍, 0💬
Data Literals in SQL Server Transact-SQL
Where to find answers to frequently asked questions on data literals 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 data literals in Microsoft SQL Server Transact-SQL: Con... 2017-05-20, 444👍, 0💬
Single-byte String Literals in SQL Server Transact-SQL
What are single-byte string literals supported in SQL Server Transact-SQL? Single-byte string literals in Transact-SQL are sequences of characters enclosed in single quotes. String literals are used to provide values to string variables or table columns like CHAR(40), VARCHAR(40), etc. String litera... 2017-05-20, 434👍, 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, 412👍, 0💬
CHAR(n) - Truncating/Padding Strings in SQL Server Transact-SQL
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the input string does not match the storage size of the fixed length string data type CHAR(n). SQL Server will: If the input string of CHAR(n) has less than n bytes, it will be padded with space characte... 2017-05-13, 631👍, 0💬
Default Collation in SQL Server Transact-SQL
How To Find Out What Is the Default Collation in SQL Server Transact-SQL? The default collation of a database comes from the server if you are not using the COLLATE clause in the CREATE DATABASE statement. If you are not using the COLLATE clause for character string column, it will use the default c... 2017-05-13, 450👍, 0💬
Collation - Character Code Page in SQL Server Transact-SQL
What Is a Collation in SQL Server Transact-SQL? A collation in Transact-SQL is a set of specifications defining a character set and its sorting rules. SQL Server support a large number of built-in collations. For example: Albanian_CI_AI_KS_WS - Albanian, case-insensitive (CI), accent-insensitive (AI... 2017-05-13, 448👍, 0💬
COLLATE Clause in SQL Server Transact-SQL
How To Specify the Collation for a Character Data Type in SQL Server Transact-SQL? If you do not want to use the default collation provided by the SQL Server, you can use the "COLLATE collation_name" clause to specify a different collation to be used at different levels: Database Level - Used in CRE... 2017-05-13, 440👍, 0💬
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
How To Create a Simple Stored Procedure in SQL Server Transact-SQL? If you want to create a simple s...
How To Select Some Specific Columns from a Table in a Query in SQL Server? If you want explicitly te...
How To Recreate an Existing Index in SQL Server? If you want to change the definition of an existing...