UPDATE stockmaster
						SET longdescription='Crest Sausage Sizzlers Chicken',
							description='Crest Sausage Sizzlers Chicken',
							discontinued='0',
							controlled='0',
							serialised='0',
							perishable='0',
							categoryid='chicken',
							units='each',
							mbflag='B',
							eoq='0',
							volume='0.0000',
							grossweight='0.0000',
							netweight='0.0000',
							barcode='',
							discountcategory='',
							taxcatid='1',
							decimalplaces='2',
							shrinkfactor='0',
							pansize='0',
							nextserialno='0',
							lastupdate='2018-06-05 12:08:20'
					WHERE stockid='34'