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...
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...
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!
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
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...
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
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
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 + ''',
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...
April 25, 2005 at 10:11 am
select
TABLE_NAME, COLUMN_NAME
from
INFORMATION_SCHEMA.COLUMNS
where
NUMERIC_PRECISION IS NOT NULL
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:
-...
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
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...
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...
April 25, 2005 at 8:31 am
Congratulations for the good Job!
Thanks,
April 25, 2005 at 8:16 am
Viewing 15 posts - 3,826 through 3,840 (of 5,103 total)