Has anyone had to deal with removing punctuation (commas, apostrophes,
etc.) from a column?  What is the most efficient way to have these
characters automatically removed from the column?

Can anyone recommend a tool where I can email to someone both the SQL
query and the result set?  Right now, I'm just copying the results to a
spreadsheet.  No, I can't use Reporting Services or Crystal Reports.

I'm using SS2K on W2k.
I'v got a table say, humm, "Orders" with two fields in the PK:
OrderDate and CustomerID. I would like to add an "ID" column which
would be auto-increment (and would be the new PK). But, I would really

my table ha follow structure..
SalaryTable:
Value Salary
------------

I am using MS SQL Evaluation Edition for my ASP.NET web application. But it
suddenly stop working. I guess that it is because it expired and I forget to
backup all tables and stored procedures. Then, I bought MS SQL Server 2000
Developer Edition and want to install it (replace ...

I simply want to load an XML (either from a file or text),
then validate it against an XSD (file or text).
1.) I have NO idea how to do this, please help.
2.) Can this be done strickly in SQL Server 2005 (or do I need VS2005)

I have a reporting query that I need to do a quarterly trending on.  A
user enters a begining date and end date, and from there, I have to
determine the closest quarter to it.
Also, the actual Quarter starts on Sept 4th, then add 13 weeks to that,

Tengon una parametro el cual es un varchar(200).
El string que le paso viene con un caracter |, por ejemplo:
"aaaaa|bbbbbbbbbb"
necesito separar ese string en 2 string independientes, uno es "aaaaa" y el

Does sqlserver 2005 support utf-8?
In MySQL I can use charset=utf8 in the connectionString inorder to make
query again utf-8 string work (collation) I can send query to the server
 like SELECT * FROM users WHERE firstName LIKE '%utf-8_string%'.

Is there any front IDE for MS SQL as there is MySQL Front for MySQL. I
am looking for it so that it is easy to quickly add/edit/delete the
data from the existing table. Please prode the Download URL is there is
any.

I've developed an ASP.NET application which uses MS-SQL Server 2000 as a
backend. But as the site hits increase SQL server reponse becomes lower.
At some stage after that SQL Server gets automativally stopped bringing
complete web-application down to halt. i checked the Windows 2000 ...

I just downloaded a copy of the SQL Server 2000 64-bit help file in CHM
format and can't seem to get it to work. I have SQL Server 2000 developer
edition installed with SP4 on Windows XP SP2. Everything on my SQL Server
works fine including the updated help files. Just the 64-bit ...

I am now doing one type of analysis every month, and wanted to creat
table names in a more efficient way.
Here is what happens now, everytime I do the analysis, I will create a
table called something like customer_20050930, and then update the

I am using MS-Access as a front end for my MS-SQL DB. I have a sql view that
uses the following:
SELECT     TOP 100 PERCENT RECID, PATNUMBER AS [PAT #], SVCCODE AS [Service
Code], QTY, PROF_CHRGS AS [Pro Fee's'], AMOUNT,

An upcoming project is to monitor access logs in SQL Server 2000 SP3a. I
noticed that SQL Logs are generated in two places, the Application Event Log
and under "c:\program files\microsoft sql server\mssql\logs". I didn't see
any authentication logs though. I tried logging in ...