|
|
Search
You searched for the word(s):
Showing page 54 of 68 (674 total posts)
< 1 second(s)
-
Sunt bani bine cheltuiti...
-
Sorry again...
http://www.sql-server-performance.com/reducing_locks_hints.asp
-
Imi cer scuze...scriptul din Inside SQL Server 2000 poate fi rulat din mai multe conexiuni simultan daca folosesti UPDLOCK...
-
Un exemplu din Inside SQL Server ...
-
NOLOCK, READUNCOMMITED
Specifies that dirty reads are allowed. No shared locks are issued to prevent
other transactions from modifying data read by the current transaction, and
exclusive locks set by other transactions do not block the current transaction
from reading the locked data.
UPDLOCK
Specifies that update locks are to ...
-
Incearca sa folosesti WITH (UPDLOCK) la operatiile pe tabela Y.
-
Cum arata scriptul pe care il folosesti?
-
...poti testa pe SQL Server 2005 Express Edition with Advanced Services...
http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx
-
Iti vor trebui si licente de SQL Server 2005, vezi http://www.microsoft.com/sql/howtobuy/howtolicensers.mspx.
Despre
upgrade (inclusiv upgrade-ul de rapoarte) exista un intreg capitol in
Books Online de SQL 2005
(http://msdn2.microsoft.com/en-us/library/ms130214.aspx). Este bine sa
experimentezi intai pe un mediu de test.
-
Multumesc...nu a ajuns inca (?)...
Pentru punctul 3 din prima intrebare (''cea mai populata unitate teritoriala.....'')
--tabelul temporar cuprinde populatia fiecarui ''judet''
DECLARE @t TABLE(id_tara int, id_judet int, pop int)
INSERT INTO @t
SELECT t.id_tara, j.id_judet, SUM(nr_locuitori) AS pop
FROM tara t JOIN Judet j ON ...
... 54 ...
|
|
|