|
How to transfer database diagrams to a different database?
|
Total Hit (2657) |
Database diagrams are stored in the 'dtproperties' table within the database. So, database diagrams can be transferred to a different database, by transferring the contents of this table.
For example , run the following query to transfer the diagram named 'MyTableDesign' from 'pubs' database to '
....Read More |
Rating
|
|
|
|
|
Strip the tags out of a HTML string
|
Total Hit (1321) |
A relational technique to strip the HTML tags out of a string. This solution demonstrates how to use simple tables & search functions effectively in SQL Server to solve procedural / iterative problems.
|
Rating
|
|
|
|
|
|
|
Regular Expressions in T-SQL
|
Total Hit (3950) |
For this solution we need SQL Server 2000 or higher. Also we need to make sure we have the VBScript.RegExp library on our computer. This should come with most Windows 2000 servers, in the Windows Scripting package. If you are using this on an older version of Windows, you will probably have to downl
....Read More |
Rating
|
|
|
|
|
|
|
|
|
|
Divide and Conquer - Batching Part 1
|
Total Hit (672) |
There are many queries and processes that a DBA may perform on an SQL Server that run quickly and efficiently with small amounts of data, but do not scale up when run on large sets of data. The power behind a RDBMS and SQL Server come from the extremely efficient and rapid processing of sets of data
....Read More |
Rating
|
|
|
|
Summarizing Data with ROLLUP
|
Total Hit (630) |
Oftentimes, when building Web-based reporting tools we need to show totals and sub-totals for information stored in the database. For example, imagine that you worked at an eCommerce site like Amazon.com that sold products from a variety of categories: books, electronics, clothes, etc. Managers woul
....Read More |
Rating
|
|
|
Using DiffGrams for XML data modifications (XML and SQL part 9)
|
Total Hit (1019) |
In a previous article of this series, I described using bulk loading of XML data with scripting interfaces included in the SQLXML version 2.0 and later. Now, we are going to explore another feature introduced in SQLXML version 2.0 (and enhanced in the version 3.0) called Diffgrams.
....Read More |
Rating
|
|
|
|
How to Schedule a Job Programatically with VB
|
Total Hit (839) |
First off, set a reference to Microsoft SQL-DMO in your VB project. You will need to have SQL Server 7 installed on your box for this. I haven't tried this under SQL 2000 or SQL 6.5
|
Rating
|
|
|
Business Case Solutions Using MDX
|
Total Hit (869) |
The purpose of the Multidimensional Expressions (MDX) language is to make access to multidimensional data more concise and efficient. However, because MDX reflects the natural complexity of multidimensional data structures, simple business questions may sometimes require complex MDX solutions.
....Read More |
Rating
|
|
|
Importing a Named Range From Microsoft Excel
|
Total Hit (1727) |
On the newsgroups recently there has been a great deal of interest in importing data from Microsoft Excel into SQL Server using DTS. One of the questions that caught my eye was "How do I import values from cells from anywhere on the page?". You can do this using Named Ranges in the Excel spreadsheet
....Read More |
Rating
|
|
|
Tutorial : How to Use Lookups in DTS
|
Total Hit (613) |
When you see people in the newsgroups answering a question with a query and the query includes a question mark then you may be forgiven for thinking that the person who is replying doesn't know what value goes in here. Here we present a different answer and yes you guessed it the solution we present
....Read More |
Rating
|
|
|
|
SQL Server 2000 Active Directory Integration
|
Total Hit (1904) |
SQL Server 2000 was designed to operate as an integral part of the Windows 2000 domain environment. Unfortunately, the new features that best exemplify this integration are rarely taken advantage of. The purpose of this article is to present their overview.
....Read More |
Rating
|
|
|
|
Cubes: ProClarity Professional, Part I
|
Total Hit (1186) |
This is the nineteenth article of the series, Introduction to MSSQL Server 2000 Analysis Services. As I stated in the first article, Creating Our First Cube, the primary focus of this series is an introduction to the practical creation, manipulation and use of multidimensional OLAP cubes. The series
....Read More |
Rating
|
|
|