Viewing 15 posts - 1 through 15 (of 44 total)
An even easier solution:
create view v_max (number) as
select count(grade) number
from results group by studentid
select max(number) from v_max
January 19, 2004 at 6:32 am
allright, time for a different sound:
avoid NULL where possible
NULLs are giving you a hard time when comparing and with logical operators. In SQL server it even gets worse because...
December 15, 2003 at 2:26 am
you can actually create a table with varchars exceeding the maximum page size. But you won't be able to fill them beyond 8032 bytes.
workaround1: previous answer (Frank Kalis)
workaround2: use...
December 10, 2003 at 12:56 am
just make a script containing all of them (or probably partially)
Open this script in query analyzer, do "find and replace" to change the headers of the stored procedures creations.
December 10, 2003 at 12:45 am
quote:
We have a large database in SQL Server 2k. I need to create a test database for our
October 23, 2003 at 12:32 am
Why not use a partitioned view on the
tables ?
October 8, 2003 at 2:54 am
>update employee set password=encrypt
>(password)
>but i don't know how to decrypt it?
Being unable to decrypt gives you better
security ...
September 29, 2003 at 5:11 am
probably yet another reason:
minimize the number of different protocol on your LAN
September 29, 2003 at 5:05 am
>It should be hard to maintain two servers >with a real time replication. isn't it ?
Probably not, but it doubles risk on downtime
September 17, 2003 at 2:16 am
Thanks Antares686,
Indeed, that's what I meant (running from design view/EM) Is there no run-time to kill (dtsrun or something ?)
September 3, 2003 at 12:19 pm
quote:
Also, remember that any number of tools can be used to connect to SQL Server, it's not the tools that matter, it's...
September 1, 2003 at 1:00 am
insert into ADStable
select * from ODStable1 a
where exists (select PK from ODStable2 b where a.PK = b.PK
and b.a_key_field='SOMETHING')
ODStable2 will be only accessed by index (seek), the data is not needed....
August 28, 2003 at 8:14 am
can anybody give info on this ?
It's an important matter to us.
Thanks a lot.
August 26, 2003 at 7:13 am
himan0110,
I'm not quite with you ... Let's try it with an example.
say: 1 row = 1000 bytes
insert into ADStable
select * from ODStable1 a
where exists (select PK from ODStable2 b...
August 25, 2003 at 4:13 am
Viewing 15 posts - 1 through 15 (of 44 total)