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

EXECUTE - Executing Stored Procedures in SQL Server
How To Execute a Stored Procedure in SQL Server Transact-SQL? If you want execute a stored procedure created previously, you can use the EXECUTE statement in the following formats: EXEC procedure_name; EXECUTE procedure_name; The key word EXEC is actually optional. So you can execute a stored proced...
2017-01-05, 515👍, 0💬

Creating a View with Data from Multiple Tables in SQL Server
Can You Create a View with Data from Multiple Tables in SQL Server? Can You Create a View with Data from Multiple Tables? The answer is yes. A view can be created with a SELECT statement to join data from multiple tables. It is a common practice to normalize data into multiple tables. Then using a v...
2016-11-05, 515👍, 0💬

Using User Defined Functions in SQL Server Transact-SQL
Where to find answers to frequently asked questions on Using User Defined Functions in SQL Server Transact-SQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Using User Defined Functions in SQL Server Transact-SQL. Clear answers are provided wit...
2016-12-28, 506👍, 0💬

Passing Values to Stored Procedure Parameters in SQL Server
How To Provide Values to Stored Procedure Parameters in SQL Server Transact-SQL? If a stored procedure is created with parameters, you need pass values to those parameters when calling the stored procedure with one of two formats listed below: -- Passing values only EXEC procedure_name value_1, valu...
2016-12-28, 490👍, 0💬

Import One Table back from a Dump File in Oracle
How To Import One Table Back from a Dump File in Oracle? If you only want to import one table back to the database, you can use a dump file that was created by full export, schema export or a table export. The following tutorial exercise shows you how to import the "fyi_links" table from a dump file...
2016-10-15, 488👍, 0💬

Downloading and Installing SQL Server 2005 Express Edition
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Express Edition? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Downloading and Installing SQL Server 2005 Express Edition. Clear answers are provid...
2016-12-08, 486👍, 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, 484👍, 0💬

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

Creating Multi-Statement Table-Value Functions in SQL Server
How To Create an Multi-Statement Table-Valued Function in SQL Server Transact-SQL? To create a multi-statement table-valued function, you need to define a temporary table as the returning table in the function. INSERT statements should be used to insert data into the returning table. The tutorial ex...
2016-10-17, 479👍, 0💬

"CREATE PROCEDURE" - Creating Simple Stored Procedures in SQL Server
How To Create a Simple Stored Procedure in SQL Server Transact-SQL? If you want to create a simple stored procedure with no input and output parameters, you can use the "CREATE PROCEDURE" command with a statement batch in a simple format as shown in below: CREATE PROCEDURE procedure_name AS statemen...
2017-01-05, 475👍, 0💬

Downloading and Installing SQL Server Management Studio Express in SQL Server
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft SQL Server Management Studio Express (SSMSE) is a free, easy-to-use graphical management tool for managing SQL Server 2005 Express Edition and SQL Server 2005 Express Edition with Advanced Services. I...
2016-12-04, 475👍, 0💬

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

What Is SQL in MySQL
What Is SQL in MySQL? SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Relational Database Management Systems). SQL was developed by IBM Corporation.   ⇒Database Basics and Terminologies in MySQL ⇒⇒MySQL Database Tutorials
2017-07-15, 457👍, 0💬

What Are Logical/Boolean Operations in SQL Server
What Are Logical/Boolean Operations in SQL Server Transact-SQL? Logical (Boolean) operations are performed on Boolean values with logical operators like 'AND', 'OR', or 'NOT'. Logical operations return Boolean values. SQL Server 2005 supports the following logical operations: AND - Returns TRUE if b...
2017-01-11, 454👍, 0💬

Using SELECT Statements on Views in SQL Server
Can SELECT Statements Be Used on Views in SQL Server? Select (query) statements can be used on views in the same way as tables. The following tutorial exercise helps you creating a view and running a query statement on the view: CREATE VIEW myLinks AS SELECT * FROM fyi_links WHERE url LIKE '%fyi%' G...
2016-10-26, 449👍, 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, 444👍, 0💬

OUTPUT - Defining Output Parameters in Stored Procedures in SQL Server
How To Define Output Parameters in Stored Procedures in SQL Server Transact-SQL? Sometime a stored procedure not only want to take input values from the calling statement batch, but it also want to send output values back to the calling statement batch. This can be done by defining output parameters...
2016-12-28, 443👍, 0💬

Running Queries with 'sqlcmd' Tool in SQL Server
How to run Queries with "sqlcmd" tool in SQL Server? "sqlcmd" is a client tool that you can use to interact SQL server. You can follow the tutorial below to run queries on the local SQL Server 2005 Express. 1. Open a command window and enter the following command to start "sqlcmd" and run a simple q...
2016-12-04, 440👍, 0💬

Running Queries with SQL Server Management Studio Express in SQL Server
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQL Server Management Studio Express to the local SQL Server 2005 Express. 2. Click on the "New Query" button below the menu line. Enter the following SQL statement in the query window: SELECT 'Welcome ...
2016-12-04, 438👍, 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, 437👍, 0💬

What Causes Index Fragmentation in SQL Server
What Causes Index Fragmentation in SQL Server? Index fragmentation is usually caused by deleting of existing rows or updating existing values of the indexed column. Inserting new rows should not cause any index fragmentation. This tutorial exercise shows you how update statements of 50000 rows on th...
2016-11-08, 431👍, 0💬

Conditional Statements and Loops in SQL Server in SQL Server Transact-SQL
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Server Transact-SQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com team on Conditional Statements and Loops in SQL Server Transact-SQL. Clear answers are provided...
2017-01-11, 430👍, 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, 429👍, 0💬

Selecting Some Specific Columns from a Table in SQL Server
How To Select Some Specific Columns from a Table in a Query in SQL Server? If you want explicitly tell the query to return some specific columns, you can specify the column names in the SELECT clause. The following select statement returns only three columns, "id", "created" and "url" from the table...
2016-10-26, 428👍, 0💬

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