ssrs report builder

 funktioniert nur mit eigener Datenquelle, nach veröffentlich umstellen auf shared datasource

ssrs Reporting Services Cannot read next row

 Erhalte diesen Fehler durch die Where Klausel: where C>GetDate()-@Tage

umgestellt auf where C>@Von funktioniert

FEHLER SQL GESAMT:

declare @tage as int=100; declare @Anz as int =0

select  errlevel,namespace as nspace,title,msg,count(*) as anz  from tLog 

where C>GetDate()-@Tage

group by errlevel, namespace, title,msg 

having count(*)>@Anz 

order by errlevel,count(*) desc

Sql Update Delete JOIN

 

UPDATE P
   SET P.UnitPrice = P.UnitPrice * 1.1
  FROM Product P
  JOIN OrderItem I ON P.Id = I.ProductId

	delete a From tAdressen a join cte as c on 

sql server no delete - kein löschen

das Löschen von Datensätzen in einer tabelle kann mittels dieses triggers verhindert werden:

 to prevent sql server to delete records of a table use  this trigger:

 

create TRIGGER dbo.Test1Delete
   ON  dbo.Test1
   INSTEAD OF DELETE
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    print 'no delete !'

END

oracle add user

 create user ztest identified by 123;
GRANT CREATE SESSION TO ztest2; -- so can log in

GRANT CREATE Table, create VIEW, CREATE PROCEDURE, CREATE SEQUENCE, CREATE TRIGGER to ztest2;
ALTER USER ztest2 QUOTA 100M ON DMCS;