General MySQL Oracle SQL Server

<< < 1 2 3 4 5 6 7 8 … > >>   ∑:469  Sort:Rank

Defining Excel Files as the DTS Data Destination
How To Define Excel Files as the DTS Data Destination? Microsoft Excel is a nice tool to view and manage data in rows and columns. If you have a small database table, you may want to export its data to an Excel file so that you can make changes easily. This tutorial is a continuation of the previous... 2024-01-31, 1235🔥, 0💬

Starting DTS Wizard
How To Start DTS Wizard? If you have installed DTS as part of the SQL Server 2000 Enterprise Manager tool properly, you should be able to start the DTS Wizard from the start menu: Click Start &gt; All Programs &gt; SQL Server &gt; Import and Export Data. The DST Wizard window will show u... 2024-01-31, 1231🔥, 0💬

Preparing Data in Text Files for DTS to Import
How To Prepare Data in Text Files for DTS to Import? Sometimes you have data organized in rows and columns and stored in text files. You can import data from text files to SQL Server database tables using the DTS wizard. But you need to prepare data text files with the following questions in mind: W... 2024-01-19, 1259🔥, 0💬

Defining SQL Server 2005 as the DTS Data Destination
How To Define SQL Server 2005 as the DTS Data Destination? If you are importing data from text files to SQL Server 2005 database tables, you need to define SQL Server 2005 as the DTS data destination. This tutorial continues from the previous tutorial to show you how to tell DTS to create a new tabl... 2024-01-19, 1250🔥, 0💬

Defining Text Files as the DTS Data Source
How To Define Text Files as the DTS Data Source? If your data text file is ready to import, you can start the DTS wizard and define the text file as the data source following this tutorial: 1. Start the DTS wizard and click Next. The data source window shows up. 2. Select "Text File" as the Data Sou... 2024-01-19, 1247🔥, 0💬

Data Formats Supported by DTS
What Are the Data Formats Supported by DTS? As mentioned in the DTS manual, DTS wizard support many popular data source formats: dBase - *.dbf files created by dBase, a popular database application for PCs. ODBC drivers - Any data source that configured through ODBC drivers. Microsoft Access - *.mdb... 2024-01-19, 1235🔥, 0💬

PHP ODBC - Query Multiple Tables Jointly
PHP ODBC - How To Query Multiple Tables Jointly? If you want to query information stored in multiple tables, you can use the SELECT statement with a WHERE condition to make an inner join. Assuming that you have 3 tables in a forum system: "users" for user profile, "forums" for forums information, an... 2023-12-30, 1292🔥, 0💬

SQL Server Connection Tutorials
Where to find SQL Server Connection tutorials? I am having trouble to connect to my SQL Server. Here is a collection of tutorials, tips and FAQs on how to connect your client tools and client application programs to SQL server. SQL Server Connection Concepts SQL Server Connection Protocols SQL Serve... 2023-12-30, 1341🔥, 0💬

SQL Server Transact-SQL Tutorials
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-SQL? I want to know how to write database scripts to run on SQL Server. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team about Microsoft SQL Server Tran... 2023-11-18, 6053🔥, 0💬

DEFAULT - Providing Default Values to Function Parameters in SQL Server
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parameter when creating a stored procedure, you can provide a default value so that the execution statement is not required to pass input value to this parameter: To define a default value to a parameter wh... 2023-03-03, 29470🔥, 1💬

💬 2023-03-03 yk: ok

Inserting New Line Characters into Strings in SQL Server
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a string into multiple lines, you need to insert new line characters into the string. With some client tools like SQL Server Management Studio, it is not so easy to insert a new line character. One work a... 2022-05-12, 5746🔥, 1💬

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... 2022-04-30, 5127🔥, 5💬

💬 2022-04-30 sarot: for using

"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... 2022-01-24, 4342🔥, 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... 2022-01-24, 1995🔥, 0💬

MS SQL Server DBA Checklist - General DBA Best Practices
-- Join (or start) a local SQL Server users group -- Attend at least one professional conference each year. -- Attend at least one training session each year. -- Read at least four books on SQL Server each year. -- Read the free e-book, How to Become an Exceptional DBA -- Learn everything you can ab... 2022-01-24, 1227🔥, 0💬

Unicode Character String Literals in SQL Server Transact-SQL
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are multi-byte characters. They are very hard to be entered as string literals, because it requires: The SQL client tool to support Unicode characters. The command line tool 'sqlcmd' does not support Unicod... 2019-12-05, 6387🔥, 1💬

💬 2019-12-05 gopala krishna: gopala krishna

Downloading and Installing SQL Server Sample Scripts in SQL Server
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from sample scripts provided by Microsoft, you should follow this tutorial to download and install them: 1. Go to the SQL Server 2005 Samples and Sample Databases download page . 2. Go to the x86 section i... 2019-11-08, 3464🔥, 2💬

💬 2019-11-08 FYIcenter.com: @Nana, please follow AdventureWorksLT - Downloading and Installing the Sample Database in SQL Server tutorial.

💬 2019-10-31 Nana Jacob: Please i need to download AdventureWorksLT

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, 12725🔥, 1💬

💬 2019-08-04 Marc: many thanks

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, 6914🔥, 1💬

💬 2018-06-19 ramesh adhikari: sdafdffddf

"sys.tables" - Getting a List of All Tables in SQL Server
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table you have just created, you can use the "sys.tables" system view to get a list of all tables in the current database. The tutorial script gives you a good example: SELECT name, type_desc, create_date FR... 2018-03-29, 3196🔥, 1💬

💬 2018-03-29 Eric: That works. Thanks!

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, 5048🔥, 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, 3429🔥, 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, 1685🔥, 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, 3208🔥, 0💬

<< < 1 2 3 4 5 6 7 8 … > >>   ∑:469  Sort:Rank

General MySQL Oracle SQL Server