|
Reading Text Files Into Tables with line numbers.
|
Total Hit (2369) |
Some times we need to read text file line by line or read a specific line using T-SQL. This article will explain a simple technique using xp_CmdShell stored proc.
Let's first create a sample file which we will import into SQL Server table.
<b>test.txt</b>
«code LangId=999»<Pre>Hello this is a
....Read More |
Rating
|
|
|
|
|
|
|
|
|
|
|
|
|
Working with SQL Server Date/Time Variables
|
Total Hit (1905) |
This is the first article in a series of articles that I will discuss various aspects of working with SQL Server date/time columns. SQL Server has two different date/time columns. They are DATETIME and SMALLDATETIME. This article will define the difference between these two SQL Server date/time data
....Read More |
Rating
|
|
|
|
Scanning the network for SQL Server for a range of IP addresses
|
Total Hit (936) |
In a large IT department, it can be difficult to locate where new SQL Server installations were made and how many of those SQL Servers were patched, etc. This article explains how to scan the entire network for a range of IP addresses to find which boxes have SQL Server instances installed. The OSQL
....Read More |
Rating
|
|
|
Linked Severs on MS SQL Part 3
|
Total Hit (1016) |
In Parts 1 and 2, we introduced the Linked Server. Starting with what a Linked Server is, the benefits to using them, as well as when to avoid them. The Distributed Transaction Coordinator, DTC, was touched on. In addition, our first examples were to create links to an Excel spreadsheet, during whic
....Read More |
Rating
|
|
|
XML and SQL 2000 (Part 2)
|
Total Hit (1746) |
In the first article of the series, I explained the ways of presenting relational data in XML format using the FOR XML clause of the T-SQL SELECT statement. Now it is time to look into the reverse process of inserting XML formatted data into SQL databases using OpenXML function.
....Read More |
Rating
|
|
|
Data Warehousing Framework
|
Total Hit (1615) |
Making better business decisions quickly is the key to succeeding in today's competitive marketplace. Organizations seeking to improve their decision-making ability can be overwhelmed by the sheer volume and complexity of data available from their varied operational and production systems. In respon
....Read More |
Rating
|
|
|
Using xp_fixeddrives to Monitor Free Space
|
Total Hit (787) |
As a DBA one of your responsibilities is to monitor disk space. You always need to make sure you have enough for your databases, database backups and any other types of files you plan to store on your server. If you don't monitor your disk space and make sure you have enough space, eventually one of
....Read More |
Rating
|
|
|
|
SQL Server API Server Cursors
|
Total Hit (815) |
Defines the attributes of an API server cursor, such as its scrolling behavior and the statement used to build the result set on which the cursor operates, then populates the cursor. The statement can contain embedded parameters.
|
Rating
|
|
|
|
Getting the Wrong Identity in Microsoft SQL Server identity Columns?
|
Total Hit (571) |
An Identity column is used in SQL server to create a surrogate key value for a table. This will be a unique identifier usually in sequential order. Starting at some predefined number, the Identity column increments every time a new record is added to the table. For MS Access users, this is comparabl
....Read More |
Rating
|
|
|
|
Brief Tutorial on Text, Ntext, and Image
|
Total Hit (1127) |
Databases are growing in size and complexity, in part because today's hardware and software allow us to store mind-boggling amounts of data—including multimedia and document data. JPG, PNG, MP3, DOC/RTF, HTML, Unicode, and XML data can all be stored as image, text, or ntext in SQL Server databases.
....Read More |
Rating
|
|
|
|
|
DTS Errors
|
Total Hit (1041) |
«LI»"Could not create component categories manager" Or "Could not create an instance of the DTS package"
«LI»"DTS WIZARD ERROR: CoCreateInstance - Class not Registered"
«LI»"The parameter is incorrect" Or "Invalid class string" Or "The system cannot find the file specified"
«LI»"The license fo
....Read More |
Rating
|
|
|
|
Programming Conditional Split Transformation
|
Total Hit (1410) |
There may be some circumstances in a sanctuary where it becomes necessary to keep a leash of foxes and a pack of wolves separate so that they must not fight with each other and make things a mess. Similarly, in the database jungle we do the same things by using some conditional statements in order t
....Read More |
Rating
|
|
|