|
|
Search
You searched for the word(s):
Showing page 4 of 39 (389 total posts)
< 1 second(s)
-
salut, in sql server 2005 cum pot da execute permission pe o anumita procedura la toti userii din db
am crezut ca e simplu :
GRANT EXECUTE ON [dbo].[SP] to all
dar se pare ca nu :)
multumesc
alex
-
perfect, multumesc mult
alex.
-
e corect asa?
UPDATE aaa SET Principal= 0
WHERE DataInregistrare IN (
SELECT TOP 2 DataInregistrare
FROM aaa b
WHERE b.CodContract=aaa.CodContract
AND DATEDIFF(month, DataInregistrare, ( SELECT MIN(DataInregistrare)
FROM aaa c
WHERE c.CodContract=b.CodContract
)
) = 0
and DataInregistrare > ( SELECT MIN(DataInregistrare) ...
-
syntaxa e gresita
am eroarea
Msg 1033, Level 15, State 1, Line 14
The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified.
si daca folosesc top 100 percent adica:
UPDATE aaa SET Principal=0
WHERE DataInregistrare = (
SELECT top 100 ...
-
dar updateul se face si pe prima inregistrare nu doar pe cea de-a 2-a
si anume pt o inregistrare de ...
-
primesc eroare
Msg 512, Level 16, State 1, Line 1
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.
alex.
-
nu cred ca e ce-mi trebuie pt ca o sa faca update si in cazul ...
-
salut, ma puteti ajuta va rog cu un update
am tabela urmatoare
create table aaa (
[NodId] [int] NOT NULL ,
[CodContract] [varchar] (20) NULL,
[CodCategorie] [varchar] (20) NOT NULL ,
[DataInregistrare] [datetime] NOT NULL ,
[DataInregistrareAjustata] [datetime] NULL ,
[CodClient] [int] NOT NULL ,
[NumeClient] [varchar] (61) NULL ...
-
am gasit pana la urma
trebuia activat trace 3604
dbcc traceon(3604);
go
alex.
-
salut, foloseste cineva dbcc page()
am urmat pasii de aici:
http://www.sqlservercentral.com/articles/deadlock/64315/
doar ca
DBCC page (5,1,4432,0)
imi returneaza
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
si nu datele care-mi trebuiesc
aveti idee de ce?
multumesc
alex.
... 4 ...
|
|
|