|
Search/Replace text in text, ntext datatype column
|
Total Hit (3114) |
In SQL Server anything text longer than 8000 characters can be stored in TEXT or NTEXT datatype column but when you use TEXT or NTEXT datatype is not same as regular char, varchar, nchar or nvarchar datatype. You can not use string function like ltrim, rtrim, replace etc... Then how do you search an
....Read More |
Rating
|
|
|
|
|
Example for encrypting data using XOR
|
Total Hit (1830) |
Functions to encrypt data in columns are not available in SQL Server (except undocumented ones that are risky to use & not supported). Here is one that shows how to do this using XOR.
«code LangId=6»DECLARE @pwd varchar(30) , @encryptkey int , @encryptedpwd varchar(30) , @charpos smallint;
SELE
....Read More |
Rating
|
|
|
SQL Server Reporting Services WebCasts
|
Total Hit (2720) |
All bold links are reporting services related webcasts
«code LangId=999»<table dir="ltr" cellSpacing="0" cellPadding="0" width="100%" border="0" id="table1">
<tr vAlign="top">
<td dir="ltr" width="100%">
<div class="clsDocBody" id="pageContainer">
<table id="table2" style="WIDTH: 100%
....Read More |
Rating
|
|
|
|
Linked Severs on MS SQL Part 4, Oracle
|
Total Hit (2311) |
In previous articles, we created Linked Servers to Excel, Access and MS SQL. Several stored procedures were introduced for creating links, and the security profiles that accompany them. For this article, sp_AddLinkedServer and sp_AddLinkedSrvLogin should be familiar. Several different access methods
....Read More |
Rating
|
|
|
|
How to Fix Inconsistent Metadata Errors (SQL Server 7.0)
|
Total Hit (3334) |
Why does changing a table on a SQL Server 7.0 server cause "OLE DB provider 'SQLOLEDB' supplied inconsistent metadata. An extra column was supplied during execution that was not found at compile time." to occur when query the table from a SQL Server 2000 server via link to other.
BASIC UNDERSTAND
....Read More |
Rating
|
|
|
Working with Reporting Services Using Microsoft Sharepoint
|
Total Hit (1354) |
There are many instances in which the business process requires executive reports or some company performance reports to show up on intranet sites. Companies do use different portals to build their intranet sites. Microsoft’s SharePoint technology is one such tool. The main task is how we display th
....Read More |
Rating
|
|
|
Custom Assembly in Reporting Services
|
Total Hit (1075) |
SQL Server 2000 Reporting Services is a server-based reporting solution that can deliver interactive Web–based reports. This article describes a problem that occurs when you access a custom assembly in your Reporting Services report that does not have sufficient permissions on the resources in your
....Read More |
Rating
|
|
|
|
A Comparison of SQL Server 2000 With Sybase ASE 12.5
|
Total Hit (1609) |
Often people in newsgroups ask about some comparison of Microsoft SQL Server and Sybase Adaptive Server. In this article, I compare SQL Server 2000 with Sybase Adaptive Server Enterprise 12.5 (Sybase ASE 12.5) regarding price, performance, platforms supported, SQL dialects, and products limits.
....Read More |
Rating
|
|
|
A Comparison of SQL Server 2000 with DB2 v8.1
|
Total Hit (1563) |
Often people in newsgroups ask about a comparison of DB2 and Microsoft SQL Server. In this article I will compare SQL Server 2000 with DB2 Universal Database version 8.1 regarding price, performance, platforms supported, SQL dialects, and products limits.
....Read More |
Rating
|
|
|
Setting Up Merge Replication: A Step-by-step Guide
|
Total Hit (730) |
In this article, I want to tell you about some general Microsoft SQL Server replication's topics: replication topologies, replication types, and replication agents. I will also discuss Merge replication: how to check necessary conditions for this type of replication and how to backup and restore the
....Read More |
Rating
|
|
|
Supporting DTS in SQL Server 2005
|
Total Hit (943) |
Supporting DTS packages in SSIS ( SQL Server Integration Services ) is a daunting task for many. Let’s look at what you need to get the job done and get some good tutorials on the subject.
|
Rating
|
|
|
Benchmarking Performance of a Query - Part 1 Elapsed Time
|
Total Hit (899) |
How many times have you had more than one way to do something and wanted to determine which method was faster and/or which one used more resources? I am going to guess that most developers have run across this dilemma more than once. So how do you decide with method is faster--or which method requir
....Read More |
Rating
|
|
|