add anPLUCode in view MS

Kategorija: Pantheon TSQL

DECLARE @tekst varchar(max)select @tekst = definition FROM sys.sql_modules WHERE object_id = object_id('MS')SET @tekst = REPLACE(@tekst, ', anPLUCode', '') SET @tekst = REPLACE(@tekst, 'create view', ...

Auto PLU Codes

Kategorija: Pantheon

create table #x(id int identity (1,2) not null,ident char (16)) insert into #x (ident)select ident from ms update mset m.anPLUCode = t.id, m.anPLUCode2 = t.id + 1from tHE_SetItem minner join #x t on m...

CHECKCONSTRAINTS

Kategorija: TSQL

This command can be run as follows: DBCC CHECKCONSTRAINTS (TableName) - checks an individual table DBCC CHECKCONSTRAINTS (ConstraintName) - checks an individual constraint DBCC CHECKCONSTRAINTS WITH ...

Rebuild all indexes on all tables (see attachment)

Kategorija: TSQL

DECLARE @Database NVARCHAR(255) DECLARE @Table NVARCHAR(255) DECLARE @cmd NVARCHAR(1000) DECLARE DatabaseCursor CURSOR READ_ONLY FOR SELECT name FROM master.sys.databases WHERE name NOT I...

Unos artikala/first setup

Kategorija: Pantheon TSQL

update tHE_SetItem set acSetOfItem = '13X' where acSetOfItem like '';  create trigger _PrenosItemSubj on tHE_SetItemafter insert, updateasinsert into tHE_SetItemExtItemSubj (acIdent, acSubject, acType...

Brzo kreiranje tabele i kolona

Kategorija: TSQL

Brzo kreiranje tabele i kolona