随笔分类 -  数据库

Init wms goodlocation data
摘要：insert goodlocation： sp_batchinsert_goodlocation： Execute： Result： 阅读全文
posted @ 2019-04-23 11:54 AriLee 阅读(176) 评论(0) 推荐(0)
Get all static wms goodlocation data
摘要：sql function and store process: call: result: 阅读全文
posted @ 2019-04-23 11:48 AriLee 阅读(124) 评论(0) 推荐(0)
Get WMS Static GoodLocation By Dynamic SQL
摘要：Dynamic SQL Store Procedure： Note: use variable,you need convert varchar and as a variable,not directly use variable,like this: '+convert(varchar(10), 阅读全文
posted @ 2019-04-22 19:51 AriLee 阅读(178) 评论(0) 推荐(0)