|
SAVE TRAN and Save Points.
|
Total Hit (2527) |
Savepoints offer a mechanism to roll back portions of transactions. A user can set a savepoint, or marker, within a transaction. The savepoint defines a location to which a transaction can return if part of the transaction is conditionally canceled. SQL Server allows you to use savepoints via the SA
....Read More |
Rating
|
|
|
|
|
Displaying RTF formatted text in SQL 2005 Reporting services
|
Total Hit (43892) |
I haven't tried this but it may be helpful to someone who is trying to display RTF formatted text on their report. Crystal Report Support RTF/HTML format but RS 2005 doesnt support. May be MS will add in the next release.
Just follow these steps:
Compile the code below it into a class
Firs
....Read More |
Rating
|
|
|
|
|
Some useful UDF for SQL Server 2000
|
Total Hit (2904) |
Introduction
UDF examples
Database creation date
Date the object was created
Get date part of datetime value
Get time part of datetime value
Get the number of working days between two dates
«B»Introduction«/B»
SQL Server 2000 supports User-Defined Functions (UDFs) - one or more Tr
....Read More |
Rating
|
|
|
Create Excel XLS from T-SQL
|
Total Hit (3987) |
This is a T-SQL script that uses OLE, ADO, Jet4 ISAM, and Linked Server to create and populate an Excel Workbook (XLS) file from T-SQL query. If the Excel Worksheet exists, the query will append to the "table".
The code is designed to be used by SQL Agent and to append to the step output with verb
....Read More |
Rating
|
|
|
|
|
|
Generate sequence numbers within a group of values.
|
Total Hit (1455) |
This example shows how to generate sequence numbers within a group of values in a SELECT statement. With proper indexes & search conditions, the example using the SELECT statement with GROUP BY will be very efficient.
|
Rating
|
|
|
|
|
T-SQL Programming Part 2 - Building a T-SQL Loop
|
Total Hit (974) |
This is the second article in my T-SQL programming series. This article will discuss building a program loop using T-SQL. In addition to talking about building a loop, I will also discuss ways of controlling the loop processing, and different methods to break out of a loop.
....Read More |
Rating
|
|
|
|
Introducing the SQL Server 'MDX in Analysis Services' Series
|
Total Hit (624) |
This is the first tutorial of a new series, MDX in Analysis Services, that I hope will help new users get up to speed quickly with multidimensional expressions (MDX). The series is designed to provide hands-on application of the fundamentals of MDX from the perspective of MS SQL Server 2000 Analysis
....Read More |
Rating
|
|
|
DTS Global Variables and Visual Basic .Net
|
Total Hit (704) |
1. In order to change the value of a DTS Global Variable of type String from VB.Net code, the variable must be programmatically removed from the collection and added back with its new value.
2. In order to change the value of a DTS Global Variable of type Date, the new value must be explictly cas
....Read More |
Rating
|
|
|
|
xp_regex: Regular Expressions in SQL Server 2000
|
Total Hit (616) |
Regular Expressions are probably the best tool for text parsing. Using Regular Expressions GREATLY simplifies anything for which you would normally use CHARINDEX, PATINDEX, SUBSTRING, STUFF, REPLACE, etc.
|
Rating
|
|
|
An Introduction to SQL Server Clustering
|
Total Hit (533) |
If your mission-critical SQL Server should experience a motherboard failure, how long will it be down? One hour, four hours, a day, or longer? How much will this cost your business in lost sales or productivity? And perhaps even more important to you, what will it do to your stress level?
....Read More |
Rating
|
|
|
Tutorial : Introduction To Global Variables
|
Total Hit (734) |
Global Variables allow you to make your DTS packages more flexible. Some of their uses include.
1. Storing Values passed around within a package.
2. Accepting values from outside the package to be used inside it.
3. Holding not only single values but multiple values in a recordset.
....Read More |
Rating
|
|
|
|
|
Choosing SQL Server 2000 Data Types
|
Total Hit (995) |
Choosing an appropriate data type is very important, because the errors made in a table design can result in large performance degradation. These problems often surface later, when a large amount of data is inserted. In this article, I want to tell you about built-in and user-defined data types, how
....Read More |
Rating
|
|
|
|
Using DTS to Detect and Process a File
|
Total Hit (1071) |
There is nothing better than when a new technology lends itself to solving an old problem; well, there may be some things better, but this will have to do for now. One of the classic problems in computing -- classic being defined as a problem I have seen before -- is processing files that were uploa
....Read More |
Rating
|
|
|
Textual Searches on File Data
|
Total Hit (1900) |
This chapter introduces the types of textual searches supported by SQL Server and illustrates the roles performed by both the IIS and Index Services technologies. It also introduces SQL Server distributed queries and describes their use in the processing of textual searches. It then addresses the qu
....Read More |
Rating
|
|
|
|
Dealing with MS SQL Tables that contain Duplicate Rows
|
Total Hit (702) |
Every so often, you might have to deal with tables that contain duplicate rows. In one case, you might only need to identify the duplicate rows. In other cases, you might need to remove the duplicate rows. This article will show you some different techniques for dealing with duplicate rows.
....Read More |
Rating
|
|