|
|
|
|
|
|
|
SQL Server Reprting Services (SSRS) Report Design Tips and Tricks
|
Total Hit (3855) |
This white paper covers best practices on report design and helps you avoid common mistakes when choosing a report layout and output format. Take advantage of existing product features to achieve the results you want. The paper includes report and code examples that implement functionality that is f
....Read More |
Rating
|
|
|
|
|
Displaying random data from SQL table
|
Total Hit (2784) |
Following query will display any 5 random rows from Products table of Northwind database
NewId() function genereates New GUID.......Try this code it works fine
«Code LangId=6»
select top 5 * from products order by NewId() «/Code»
|
Rating
|
|
|
Finding SQL Server Object Name from PageNumber
|
Total Hit (6597) |
Most of time when sql server throw an error will tell you object Id or PageNumber.
This article will show you how to find which object caused the error.
«b»Step-By-Step Example«/b»
Lets say you got the folloing error from SQL Server
«b»Error«/b»
«font color=red»Error: 7105, Severity:
....Read More |
Rating
|
|
|
Find out the nth highest number in a column.
|
Total Hit (2633) |
Ever wondered how to find out the second highest salary from the employees table? Or how to find out the third oldest employee in the company? Here is a stored procedure which accepts the table name, column name, and nth number and displays the nth highest number from the given column.
....Read More |
Rating
|
|
|
Tutorial : Building a Package in the DTS Designer
|
Total Hit (710) |
The point of this tutorial is to give us an introduction to the DTS designer. If you're serious about DTS or want to explore more of its many features then it won't be long before you end up here. This tutorial was created using SQL Server 2000 but users of SQL Server 7 will still find it useful. Wh
....Read More |
Rating
|
|
|
Control your SQL Server 7.0 and 2000 via E-Mail
|
Total Hit (905) |
Data Base Administrators are often exposed to a situation where they want to query a table, check on the status of a server, check an error log or run a DBCC command on a SQL Server box when they do not have access to the box directly. This often happens when they are off site or on vacation or they
....Read More |
Rating
|
|
|
|
How can I change the source data file for a Bulk Insert Task
|
Total Hit (608) |
To change the name of the source data file at runtime you can use an ActiveX Script Task. In the following example the new filename is read from a global variable called ImportFilename. Please ensure you change the bulk insert task's name value ("DTSTask_DTSBulkInsertTask_1") to match that in your p
....Read More |
Rating
|
|
|
The Curse and Blessings of Dynamic SQL
|
Total Hit (759) |
In this article I will discuss the of use dynamic SQL in stored procedures in MS SQL Server, and I will show that this is a powerful feature that you should use with care.
|
Rating
|
|
|
|
Global Variables and Stored Procedure Parameters
|
Total Hit (600) |
One of the benefits of the SQL Server 2000 is that the SQL tasks support mapping of global variables to parameter placeholders within the SQL. This means you can use the global variable as an input parameter for your stored procedure.
|
Rating
|
|
|
|
|
Working with SQL Server Date/Time Variables
|
Total Hit (1902) |
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
|
|
|
|
XML and SQL 2000 (Part 2)
|
Total Hit (1743) |
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 (1609) |
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
|
|
|
|
|
Brief Tutorial on Text, Ntext, and Image
|
Total Hit (1115) |
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
|
|
|
|