T-SQL has bitwise operations (& | ...) so you could use that, and just specify such an expression in your where clause.

Regards,

Andras

a very simple (but may not be the best) workaround:

create a table with the days like:

CREATE TABLE days (dayname CHAR(3) PRIMARY KEY)

INSERT INTO days VALUES ('MON')

INSERT INTO days VALUES ('TUE')

INSERT...

Hi James,

have a look at http://msdn2.microsoft.com/en-us/library/aa902656(SQL.80).aspx#sql2k_replperf_tran4_topic05a

and look at the section "Cost of Transactional Replication at the Publisher"

Regards,

Andras

Probably the most important question: Would you enjoy doing an MS or the type of work that it can lead to? We live only once 🙂

It is true that an...

Chirag (3/20/2008)

What i really wanted to know was about execution plans.

I believe that dropping and recreating the stored procedures

will drop the existing executions plans of the stored procedures and...

Have a look at http://support.microsoft.com/?kbid=305977

There are some differences that will affect performance...

on the right hand side of your comparisons in the where clause (DATEADD(DAY, -1, DATEDIFF(DAY, 0, convert(varchar(10),getdate(),101))))) you get a date and the time part of it will be 0:0:0.0

On...

A clustered index determines the order in which data is stored in the database files on disk. You cannot store the same data in the same file in two different...

gk (3/18/2008)

I am new to this SQL Server stuff.

The following link tells little more about traceon

http://msdn2.microsoft.com/en-us/library/ms187329.aspx

I wish to know what are the values that can be passed on for...

Do note that this is an Enterprise/Developer edition...

Hi Jeff,

it was introduced...

No, it only affects the numeric and the decimal datatypes.

Regards,

Andras

The...

Ok, a version that does something (although it is weird, you do assume that the id column is an identity column for exmaple) is:

ALTER PROCEDURE [dbo].[TableRowCopy]

(...

Another thing in your query is the

where TABLE_NAME = 'Ltrim(RTRIM(@TableName))'

and column_name <> 'Ltrim(RTRIM((@IdColumname))'

First, you are checking if the table name is the string "Ltrim(RTRIM(@TableName))". Rather uncommon names for a...