General MySQL Oracle SQL Server

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

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, 3037🔥, 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, 3034🔥, 0💬

SQL Server TCP/IP Connection Info
What information is needed for a client tool or application to connect to a SQL Server database using the TCP/IP protocol? In order to connect to a SQL Server database using the TCP/IP protocol, you need to know the following information: 1. Host Name - The name of the hosting computer where the SQL... 2024-08-14, 3031🔥, 0💬

SCHEMABINDING - Binding Views to Underlying Tables in SQL Server
How To Bind a View to the Schema of the Underlying Tables in SQL Server? By default, views are not bound to the schema of the underlying tables. This means that SQL Server will allow you to change underlying table's schema any time. For example, you can drop the underlying table while keep the view.... 2016-11-03, 3028🔥, 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, 3012🔥, 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, 3006🔥, 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, 3002🔥, 0💬

Configuring ODBC Connection and DSN for SQL Servers
A collection of 13 FAQs on connecting SQL Server via an ODBC DSN setting. Clear explanations and tutorial exercises are provided on creating new DSN with the SQL Server ODBC driver; starting SQL Server Browser Service; enabling TCP/IP protocol on SQL Server; verifying TCP/IP port numbers; testing OD... 2024-08-14, 2993🔥, 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, 2979🔥, 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, 2978🔥, 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, 2971🔥, 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, 2968🔥, 0💬

Entering Binary String Literals in SQL Server Transact-SQL
How To Enter Binary String Literals in SQL Server Transact-SQL? Binary string long values are normally generated by client applications by reading input channels, like image files. But sometimes, you may need to enter some short binary strings as literals. Binary string literals are entered as a str... 2017-04-22, 2966🔥, 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, 2965🔥, 0💬

System Requirements for SQL Server 2005 Express Edition in SQL Server
What are the requirements to install SQL Server 2005 Express Edition in SQL Server? The following system requirements cover the SQL Server 2005 Express Edition: Processor 32-bit Processor of 600-megahertz (MHz) or faster Operating System Windows XP with Service Pack 2 or later Windows 2000 Professio... 2016-12-08, 2965🔥, 0💬

"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, 2953🔥, 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, 2922🔥, 0💬

Getting Started with Transact-SQL Statements in SQL Server
Where to find answers to frequently asked questions on Getting Started with Transact-SQL Statements in SQL Server? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Getting Started with Transact-SQL Statements in SQL Server. Clear examples are provi... 2016-12-02, 2921🔥, 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, 2914🔥, 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, 2909🔥, 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, 2905🔥, 0💬

Determining Data Types of View Columns in SQL Server
How Column Data Types Are Determined in a View in SQL Server? When you define a view, its columns are defined through a list of expressions in the underlying SELECT statement. Their data types will be determined implicitly by the expressions. For example, if the column expression is a column name of... 2016-11-03, 2902🔥, 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, 2901🔥, 0💬

Configuring ODBC DSN with Different Port Numbers
How To Configure ODBC DSN with Different Port Numbers? If your SQL Server is not using the default port number, like 1269, you need to set the port number to the correct value during the ODBC DSN creation process, as show in this tutorial: 1. Start ODBC Data Source Administrator and click System DSN... 2024-07-25, 2889🔥, 0💬

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

General MySQL Oracle SQL Server