Tofu - Baza

Create Declare Cursor Hungarian
Select Update Insert Fancy
Tabela		Suffix
Select	All, None, Invert


Naziv	Tip	Null	Privzeto	Opis
acKey	char(13)	0	('')
anNo	smallint	0	(0)
acWorker	char(30)	1	('')
acIdent	char(16)	1	('')
anQty	decimal(19,6)	1	(0)
anPlanQty	decimal(19,6)	1	(0)
anTime	decimal(19,6)	1	(0)
adDate	datetime	1	(substring(convert(char,getdate(),102),1,10))
adTimeChg	datetime	1
anUserChg	smallint	1
adTimeIns	datetime	1
anUserIns	smallint	1
anVariant	tinyint	0	(0)
anScrapPcs	decimal(19,6)	1	(0)
anHoldUp	decimal(19,6)	1	(0)
acHoldUpReason	char(2)	1	('')
acHoldUpType	char(1)	1	('')
adBeginTime	datetime	1
adEndTime	datetime	1
acET	char(3)	1	('')
acWorkTimeType	char(1)	1	('1')
anRatifyPcs	decimal(19,6)	1	(0)
anRatifyTime	decimal(19,6)	1	(0)
anSubNo	smallint	0	(0)
acNote	varchar(2000)	1
acScrapReason	char(2)	1	('')

Select All, None, Invert