|
|
|
Serverside Paging using dynamic T-SQL
|
Total Hit (2024) |
This stored Procedure can page records for any specified query.
«code LangId=6»
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
/*
Description: Page a query. Query can have order by clause or it can pass separate orderby parameter
Examples:
=========================
[1] Defau
....Read More |
Rating
|
|
|
Backup and Restore of SQL Server database using easy script.
|
Total Hit (2757) |
In this article I will show you the most common backup/restore commands.
- How to take full backup of a SQL Server database.
- How to resore full backup over the existing/new database.
- How to restore full backup at different path over existing/new database.
<b>How to take full backup of a
....Read More |
Rating
|
|
|
|
|
Mathematical User-Defined Functions
|
Total Hit (2606) |
Introduction
Mathematical UDFs
Factorial
PercentFrom
PercentValue
Degree
Allocation
Combination
--------------------------------------------------------------------------------
Introduction
I would like to write the series of articles about useful User-Defined Functions gro
....Read More |
Rating
|
|
|
|
|
How to search all columns of all tables in a database for a keyword?
|
Total Hit (3505) |
While browsing the SQL Server newsgroups, every once in a while, I see a request for a script that can search all the columns of all the tables in a given database for a specific keyword. I never took such posts seriously. But then recently, one of my network administrators was troubleshooting a pro
....Read More |
Rating
|
|
|
Full-text indexing: Advanced Queries
|
Total Hit (2506) |
In our first two parts we covered creating a full-text index, updating the index and some basic queries. In this segment we'll cover some of the more advanced topics. The first is ranking the results we recieve. We do this using the CONTAINSTABLE statement. An sample query and result set are shown b
....Read More |
Rating
|
|
|
ADO like Cursor operations using T-SQL
|
Total Hit (1761) |
This article shows how to use SQL cursor to perform MoveFirst, MoveLast, MoveNext, MovePrev and MoveAbsolute operations using T-SQL's SCROLL CURSOR
|
Rating
|
|
|
Update SQL Server database with Updategrams
|
Total Hit (2618) |
You can use XML to transfer both data and commands. In this column I'll show how you can update a database by means of XML commands sent over the HTTP protocol and, even more interesting, how to perform bulk uploads with these commands.
An updategram is a piece of XML data that contains informati
....Read More |
Rating
|
|
|
Checking for Changes within trigger
|
Total Hit (2025) |
The UPDATE and COLUMNS_UPDATED functions are available within both types of triggers to allow the trigger to determine which columns were modified by the triggering action statement. For example, the following trigger prevents any modifications to the lastname column in the Employees table. Here, th
....Read More |
Rating
|
|
|
|
How can I change the filename for a text file connection?
|
Total Hit (618) |
It is a common scenario to have a scheduled package that imports a new file each day. Conversely you may wish to produce a uniquely named file each day. You can change the filename (DataSource) property of a connection at run-time from within an ActiveX Script Task.
....Read More |
Rating
|
|
|
SSIS Script Task Variable Write Example (Using LockOneForWrite)
|
Total Hit (1684) |
I had some difficulty finding a succinct code example for how to change the value of a variable in a SQL Server 2005 SSIS Script task, so I thought I would add one here now that I think I've figured it out. (Is anyone besides me disappointed by the lack of examples in the Books Online and Help?)
....Read More |
Rating
|
|
|
|
SQL Server Security Checklist
|
Total Hit (2553) |
This month we are going to look at the subject of security. The article is not an in depth tutorial, and is in no way comprehensive. Instead, what I have tried to do is to simply highlight some of the areas where many people (myself included) commonly leave gaps in their security.
....Read More |
Rating
|
|
|
Data Warehouse Design Considerations - 1
|
Total Hit (1431) |
Data warehousing is one of the more powerful tools available to support a business enterprise. Learn how to design and implement a data warehouse database with Microsoft SQL Server 2000.
|
Rating
|
|
|
SQL Server API Server Cursors
|
Total Hit (812) |
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
|
|
|
|
Scanning the network for SQL Server for a range of IP addresses
|
Total Hit (935) |
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
|
|
|
|
Formatting Character Data into Datetime fields
|
Total Hit (633) |
When building tables people quite often use character fields to hold dates. A style that is quite often used to format the date is this yyyymmdd. When we come to take this data into a field of say smalldatetime then we can encounter errors.
|
Rating
|
|
|
Commonly used expressions in SQL Reporting Services
|
Total Hit (1108) |
Some expressions are commonly used in reports. These include expressions to change the appearance of data in a report, change properties of report items, and affect how data is retrieved. This topic describes some expressions that can be used for common tasks within a report.
....Read More |
Rating
|
|
|
Cubes in the Real World
|
Total Hit (1703) |
Microsoft® SQL Server™ 2000 Analysis Services offers myriad options for creating cubes, and the flexibility and power to support almost any business case. This chapter presents practical guidelines for designing cubes and dimensions, design fundamentals, and other considerations
....Read More |
Rating
|
|
|
Export a Table to a Date Stamped File Name in SQL Server
|
Total Hit (1131) |
Date stamping is a very common requirement in the IT industry for any data extract created. Through the DTS package with ActiveX script, it is very easy to date stamp a file. In this article, I am going to walk you through how to export a table to a date stamped file.
....Read More |
Rating
|
|