General MySQL Oracle SQL Server

<< < … 4 5 6 7 8 9 10 11 12 13 14 … > >>   ∑:509  Sort:Date

"CREATE LOGIN" Statements - Creating a Login in SQL Server
How to create a login to access the database engine using "CREATE LOGIN" statements in SQL Server? This is the first tutorial of a quick lesson on creating login and configure users for databases with Transact-SQL statements. Granting a user access to a database involves three steps. First, you crea... 2016-12-02, 2751🔥, 0💬

"sp_help" - Getting a List of Columns in a View in SQL Server
How To Get a List of Columns in a View using the "sp_help" Stored Procedure in SQL Server? Another way to get a list of columns from a view is to use the "sp_help" stored procedure. "sp_help" returns more than just a list of columns. It returns: the view information, the column information, the iden... 2016-11-05, 2751🔥, 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, 2746🔥, 0💬

Database in Use When Renaming a Database in SQL Server
Why I am getting this error when renaming a database in SQL Server? If you are trying to rename a database that is in use, you will get an error message like this: "The database could not be exclusively locked to perform the operation." Before renaming a database, you must stop all client sessions u... 2016-11-20, 2734🔥, 0💬

Truncating DATETIME Values to Dates without Time in SQL Server
How To Truncate DATETIME Values to Dates without Time in SQL Server Transact-SQL? Assuming that you have some date and time, DATETIME, values, and you want to work with dates only. You want to truncate them to dates without time, or with time of 00:00:00.000. Again, SQL Server offers no simple solut... 2017-02-08, 2716🔥, 0💬

What Is a Boolean Value in SQL Server
What Is a Boolean Value in SQL Server Transact-SQL? A Boolean value indicates a condition in a state of TRUE or FALSE. In Transact-SQL language, there is not storage data type defined to store a Boolean value. So Boolean values can only exist temporarily as part of the execution of Transact-SQL expr... 2017-01-29, 2716🔥, 0💬

Passing Expressions to Function Parameters in SQL Server
Can You Pass Expressions to Function Parameters in SQL Server Transact-SQL? Can you pass expressions to stored procedure parameters? The answer is yes. When executing functions, input values can be written as expressions. But the resulting value data type must match the parameter. The tutorial exerc... 2016-12-18, 2714🔥, 0💬

"DROP" Statements - Deleting database objects in SQL Server
How to delete database objects with "DROP" statements in SQL Server? To remove all database objects created by previous tutorials, you could just delete the database. However, in this tutorial, you will go through the steps to reverse every action you took doing the tutorial. Removing permissions an... 2016-11-27, 2713🔥, 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, 2712🔥, 0💬

odbc_errormsg() - Retrieving ODBC Error Messages
How To Retrieve Error Messages using odbc_errormsg()? When you call odbc_exec() to execute a SQL statement, and the execution failed on the SQL Server, you can use odbc_error() and odbc_errormsg() to retrieve the error code and error messages. The tutorial script below shows you a good example: &... 2024-06-30, 2708🔥, 0💬

"CREATE FUNCTION" - Creating User Defined Functions in SQL Server
How To Create a Simple User Defined Function in SQL Server Transact-SQL? If you want to create a simple user defined function, you can use the "CREATE FUNCTION" command with a statement block in a simple format as shown in below: CREATE FUNCTION function_name() RETURNS data_type AS BEGIN statement_1... 2016-12-24, 2701🔥, 0💬

Passing Expressions to Stored Procedure Parameters in SQL Server
Can You Pass Expressions to Stored Procedure Parameters in SQL Server Transact-SQL? Can you pass expressions to stored procedure parameters? The answer is no. When executing stored procedures, all input values must be entered as data literals, which can be specified within single quotes ('), or with... 2016-12-28, 2687🔥, 0💬

Performing Comparison on Date and Time Values in SQL Server
How To Perform Comparison on Date and Time Values in SQL Server Transact-SQL? Comparison operations on date and time values can be performed in the same way as numeric values. The comparison rule is simple: a date and time value in the future has a greater value than a date and time value in the pas... 2017-01-21, 2686🔥, 0💬

Generating CREATE FUNCTION Scripts on Existing Functions in SQL Server
How To Generate CREATE FUNCTION Script on an Existing Function in SQL Server Transact-SQL? If you want to know how an existing user defined function was created, you can use SQL Server Management Studio to automatically generate a "CREATE FUNCTION" script The following tutorial shows you how to do t... 2016-12-18, 2682🔥, 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, 2681🔥, 0💬

Boolean Values and Logical Operations in SQL Server Transact-SQL
Where to find answers to frequently asked questions on Boolean Values and Logical Operations in SQL Server Transact-SQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Boolean Values and Logical Operations in SQL Server Transact-SQL. Clear answer... 2017-01-29, 2678🔥, 0💬

Date and Time Data Types in SQL Server Transact-SQL
What are date and time data types supported in SQL Server Transact-SQL? Date and time data types are used to hold dates and times. There are 6 date and time data types supported in SQL Server Transact-SQL: 1. DATETIME - Use to hold date and times with a large precision using 8-byte storages: 4 bytes... 2017-04-15, 2675🔥, 0💬

Attaching AdventureWorksLT Physical Files to the Server in SQL Server
How to attach AdventureWorksLT physical files to the server in SQL Server? After installed the sample database AdventureWorksLT, you need to attach it to your SQL server to make it available by follow this tutorial: EXEC sp_attach_db @dbname=N'AdventureWorksLT', @filename1=N'C:\Program Files\Microso... 2016-12-02, 2664🔥, 0💬

Downloading and Installing SQL Server 2005 Books Online in SQL Server
How to download and install SQL Server 2005 Books Online in SQL Server? 1. Go to the SQL Server 2005 Books Online download page . 2. Click the download button, the File Download box shows up. Save the download file to c:\temp. 3. Double click on the downloaded file: c:\temp\SqlServer2K5_BOL_Feb20 07.... 2016-12-04, 2663🔥, 0💬

"ALTER PROCEDURE" - Modifying Existing Stored Procedures in SQL Server
How To Modify an Existing Stored Procedure in SQL Server Transact-SQL? If you find a mistake in an existing stored procedure previously created, you can drop (delete) it and create it again correctly. But dropping a stored procedure may affect other database objects who are depending on this stored ... 2017-01-05, 2661🔥, 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, 2656🔥, 0💬

What Is ODBC (Open Database Communication)?
What Is Open Database Communication (ODBC)? ODBC, Open Database Communication, a standard API (application program interface) developed by Microsoft for Windows applications to communicate with database management servers. If you want to access a database server through an ODBC driver from an applic... 2024-08-14, 2652🔥, 0💬

String Type Conversion During Concatenation in SQL Server
What Happens When Unicode Strings Concatenate with Non-Unicode Strings in SQL Server Transact-SQL? If a Unicode string NVARCHAR is concatenated with a non-Unicode string VARCHAR, SQL Server will implicitly convert the non-Unicode string to Unicode string for concatenation. DECLARE @regcode VARCHAR(4... 2017-03-11, 2652🔥, 0💬

Verifying a Login Name with SQLCMD Tool in SQL Server
How To Verify a Login name with SQLCMD Tool in SQL Server? The quickest way to verify a login name on a SQL Server is probably to use the SQLCMD tool, which takes the server name, login name and password in a single command line. Here is how to try it yourself: Start a command window and enter the f... 2016-10-20, 2648🔥, 0💬

<< < … 4 5 6 7 8 9 10 11 12 13 14 … > >>   ∑:509  Sort:Date

General MySQL Oracle SQL Server