I wonder if anyone could offer some guidelines on the following
problem?
I need to transfer records from a SQL Server table to an 'equivalent'
Oracle table; however if the primary key for any record already exists

I have a database that I created as a database file, and then later attached
it to SQL Server.
I've decided I don't want this database file in my project folder hierarchy
and would rather move it somewhere else, preferably to the default location

I am able to extract dates in the correct format i.e.
SELECT CONVERT(VARCHAR(8), GETDATE(), 3)
=> dd/mm/yy
My issue is that my users are selecting a date in this format and I

I bought an open license for SQL 2005 Standard Edition and it is listed
in my eOpen account and I have access to the software download but
there is no install key listed. Is this normal/do I need one? Licenses
for other products have keys listed.

I know that in order to reduce network traffic you should always select only
the columns you require but I have a stored procedure which must **always**
return all columns from a specific table.
When returning all columns from a table is there any performance gain (or

I wish to make my trigger more efficient in that it only processes
columns that have actually changed.
I am currently processing 9 columns unconditionally.
I found UPDATE() function that returns true if a column has changed,

I've the following table structure:  Srv_Cost, Srv_Date_In, Srv_Date_Out.
I need to monthly spread the cost throughout the contract period and then
sum the totals.
SELECT SUM(Srv_Cost / DATEDIFF(M, Srv_Date_In, Srv_Date_Out)) AS

SQLServer 2000 Personal Edition SP4
Simple Question:
I have a small environment with one GUI computer and one Database computer.
I have one license for SQLServer 2000 Personal and Standard Editions (using

   i have created my site, got it ready for upload and even found out that
i need to create my d-bases online BEFORE i upload them... (stop laughing)
my question is this...
how do i configure my connection string so that my asp.net pages will access

In a multi-user scenario, where you would have up to four users accessing
the database, when would Access be the best overall solution?

We are using SQL Server 2000. I have already learned that there is no
MEDIAN, or MODE function to go along with the AVE... I've also found
several methods of computing Median. The one I like best is:
-- Apologies for not citing the source... I lost the website and the

Dear professional,
I want to ask one question regarding Database Mirroring. For last 1 year
databse mirroring works fine and suddenly the mirroring status changed to
disconnect.

I have a MSSQL database that stores data for a laser marking system. The
main table
OrderNo        nvarchar
LaserId        int

I have the following CASE statement in a view:
(SELECT CASE
WHEN ISNULL([dbo].[tblContact].[JobTitleID], NULL) = NULL
THEN [dbo].[f_ContactNameFL]([dbo].[tblContact].[ContactID])

I have a UDF that cleans a field of control characters and I use it
like this
select
 dbo.udf_CleanAlphaNum(Address1) as Address1