Viewing 15 posts - 3,826 through 3,840 (of 5,103 total)
create function dbo.digit ( @n varchar(40))
returns int
as
begin
declare @result int, @cntr int
select @result = 0, @n = replace(rtrim(ltrim(@n)),'.','')
set @cntr = len(@n)
While @cntr > 0
begin
set @result...
* Noel
April 25, 2005 at 1:37 pm
I personally don't think that you are going to persive a big hit because of that change. I would worry if you were to use those columns for range , ordered...
* Noel
April 25, 2005 at 1:19 pm
but even when is being run from a stored proc on sql box you still have to be worry about sql injection and guard really well those parameters!
* Noel
April 25, 2005 at 1:01 pm
What Happens is that DBCC DBREINDEX is usually employed with tableName and indexName to pick and choose what to rebuild (you omitted how was this being run ![]()
* Noel
April 25, 2005 at 12:57 pm
two choises:
1. Create a separate operator wich has the email address of a distribution list in which you keep the addresses of all those operators
2. Create aq second step on...
* Noel
April 25, 2005 at 12:36 pm
Identity is a PROPERTY. Primary Key is a CONSTRAINT.
Therefore only a Primary key or a unique constraint guarantee uniqueness.
Primary Key also prevents nulls ![]()
* Noel
April 25, 2005 at 12:32 pm
Please, Do not Double Post. See my point view on this thread:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=177164
* Noel
April 25, 2005 at 12:05 pm
The error that you get is on the Left function that can't perform well with a money type!
EXEC
(
'SELECT ''' + @TableName + '.' + @ColumnName + ''',
* Noel
April 25, 2005 at 10:52 am
I know, I know...
- There were summary tables created at many levels (indexed views may have helped but system backward compatibility was an important issue)
- There were Journal Tables
- There...
* Noel
April 25, 2005 at 10:11 am
select
TABLE_NAME, COLUMN_NAME
from
INFORMATION_SCHEMA.COLUMNS
where
NUMERIC_PRECISION IS NOT NULL
* Noel
April 25, 2005 at 10:04 am
I do think that "should" be almost always the right way but this is not a one size fit all position.
For management flexibility if you have separated triggers you can:
-...
* Noel
April 25, 2005 at 9:57 am
select RecordDate, [Values], [Values] -( select top 1 t2.[Values]
from test t2
Where t2.RecordDate < t1.Recorddate
order by t2.RecordDate desc ) diff
from test t1
* Noel
April 25, 2005 at 9:35 am
There is not a direct way to fire a trigger on a select statement in SQL 2000.
There is a very unconventional way to do this bay using a trace and...
* Noel
April 25, 2005 at 8:37 am
And to be honest I don't think there is any guarantee that you will get those ID in the correct (expected) order. To be on the safe side I would...
* Noel
April 25, 2005 at 8:31 am
Congratulations for the good Job!
Thanks,
* Noel
April 25, 2005 at 8:16 am
Viewing 15 posts - 3,826 through 3,840 (of 5,103 total)