General MySQL Oracle SQL Server

1 2 3 4 5 6 … > >>   Sort: Date

CONTINUE to Next Loop Iteration in SQL Server Transact-SQL
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINUE statements? You can use the CONTINUE statement to continue to the next iteration of a WHILE loop by skipping the rest of statement block of the current iteration using this syntax: WHILE condition B... 2017-01-11, 3736👍, 0💬

AdventureWorksLT - Downloading and Installing the Sample Database in SQL Server
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to practice you DBA skills with the scaled-down version of the sample database AdventureWorksLT provided by Microsoft, you should follow this tutorial to download and install it first: 1. Go to the SQL S... 2019-08-04, 3140👍, 1💬

💬 2019-08-04 Marc: many thanks

RAND() - Generating Random Numbers in SQL Server
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers are very useful for generating test data, passwords, or other security related data. SQL Server 2005 offers you the random number generator function RAND in two format: RAND(seed) - Starting a new sequ... 2017-03-11, 2237👍, 0💬

bin2hex - Converting Binary Strings into Hexadecimal Character Strings in SQL Server
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns a binary string value to the client tool, it will be displayed by the client tool as hexadecimal digits in a character string format. But they are hexadecimal digits on the display window, not in the... 2018-06-19, 2065👍, 1💬

💬 2018-06-19 ramesh adhikari: sdafdffddf

sys.server_principals - Listing All Login Names in SQL Server
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login names defined on the server, you can use the system view, sys.server_principals as shown in this tutorial exercise: -- Login with sa SELECT name, sid, type, type_desc FROM sys.server_principals WHERE type... 2016-10-20, 1955👍, 0💬

DATEADD() Function Usage Examples in SQL Server
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for manipulating date and time values. The following tutorial exercise shows you some good DATEADD() usage examples: -- Incrementing 1 year on a leap date DECLARE @birth_date DATETIME; SET @birth_date = '20... 2017-02-20, 1809👍, 0💬

Binary Literals in SQL Server Transact-SQL
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are sequences of bytes written in hexadecimal digits with 0x prefixes. Binary literals are used to provide values to binary variables or table columns like BINARY, VARBINARY, IMAGE, etc. Here are some simp... 2017-05-05, 1656👍, 0💬

Underflow and Overflow of FLOAT Values in SQL Server Transact-SQL
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you enter a floating number that is too big or too small for the FLOAT data type, Transact-SQL will behave as: FLOAT(24) Underflow: If a floating number is too small for FLOAT(24), it will be stored as 0 w... 2017-04-19, 1608👍, 0💬

DDL (Data Definition Language) Statements for Tables? in SQL Server
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition Language) statements are statements to create and manage data objects in the database. The are three primary DDL statements to create and manage tables: CREATE TABLE - Creating a new table. ALTER TABLE ... 2016-11-20, 1544👍, 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, 1534👍, 0💬

WHILE ... Loops in SQL Server Transact-SQL
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can use WHILE ... statements to execute statements in loops in Transact-SQL using these syntaxes: -- Loop with a single statement WHILE condition statement -- Loop with a statement block WHILE condition --... 2017-01-11, 1526👍, 0💬

Connecting SQL Server Management Studio Express To a SQL Server in SQL Server
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once you have SQL Server 2005 Express installed and running on your local machine, you are ready to connect SQL Server Management Studio Express to the server: Click Start > Programs > Microso... 2016-12-04, 1498👍, 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, 1488👍, 0💬

Counting Rows with the COUNT(*) Function in SQL Server
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows, you can use the COUNT(*) function in the SELECT clause. The following tutorial exercise shows you some good examples: SELECT COUNT(*) FROM fyi_links GO 7 SELECT COUNT(*) FROM fyi_links WHERE url LIKE... 2016-10-26, 1484👍, 0💬

sys.procedures - Listing All Stored Procedures in SQL Server
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to see a list of stored procedures in your current database, you can use the system view, sys.procedures as shown in this tutorial exercise: USE FyiCenterData; GO SELECT * FROM sys.procedures; GO Name o... 2017-01-05, 1475👍, 0💬

IF ... ELSE Statement in SQL Server Transact-SQL
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE statements? You can use IF ... ELSE statements to execute statements under given conditions in Transact-SQL using these syntaxes: IF condition statement_1 IF condition statement_1 ELSE statement_2 IF ... 2017-01-11, 1462👍, 0💬

FLOOR, CEILING, ROUND - Converting Values to Integers in SQL Server
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a numeric value into an integer. SQL Server 2005 offers you a number of ways to do this: FLOOR(value) - Returning the largest integer less than or equal to the input value. The returning data type is th... 2017-03-22, 1461👍, 0💬

Managing Security, Login and User in SQL Server
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Server? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Managing Security, Login and User in SQL Server. Clear answers are provided with tutorial exerc... 2016-10-20, 1440👍, 0💬

GO - Sending a Statement Batch from "sqlcmd" in SQL Server
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to run Transact-SQL statements on a target SQL Server. When "sqlcmd" is started and connected to a SQL Server, it will start a new batch and prompt you to enter the first statement of the batch. You can en... 2016-12-04, 1411👍, 0💬

Generating CREATE VIEW Scripts on Existing Views in SQL Server
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an existing view was created, you can use SQL Server Management Studio to automatically generate a "CREATE VIEW" script The following tutorial shows you how to do this: 1. Run SQL Server Management Studio a... 2016-11-05, 1391👍, 0💬

CONVERT() - Converting Character Strings to Numeric Values in SQL Server
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need to convert numeric values enclosed in character strings back to numeric values by using the CONVERT() function. When converting character strings to values with CONVERT(), you need to remember two rul... 2017-03-22, 1389👍, 0💬

CAST() - Converting Numeric Expression Data Types in SQL Server
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? If you want to convert the data type of a numeric expression to a new data type, you can use the CAST(expression AS data_type) function. The tutorial exercise below shows you how to use the CAST() func... 2017-03-27, 1377👍, 0💬

CONVERT() - Formatting DATETIME Values to Strings in SQL Server
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL Server 2005 offers no functions to format DATETIME values in your own format patterns. But it does provide you a number of pre-defined format patterns that you can use with the CONVERT(char_type, dat... 2017-02-08, 1366👍, 0💬

READ_ONLY/READ_WRITE - Database Update Options in SQL Server
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: READ_WRITE - Data objects are allowed to be queried and modified. This is the default. READ_ONLY - Data objects are allowed to be queried, but not allowed to be modified. You can use the "ALTER DATABA... 2016-11-20, 1366👍, 0💬

1 2 3 4 5 6 … > >>   Sort: Date

General MySQL Oracle SQL Server