Category: Computer

computer related topics

0

FTPS via WinSCP.NET

Download COM object from https://winscp.net/eng/docs/library#vbnet or from NuGet Example Code in VB.net   Imports WinSCP —–   Try ‘ Setup session options Dim sessionOptions As New SessionOptions With sessionOptions .Protocol = Protocol.Ftp .FtpSecure =...

0

To get list of tables used in a stored procedure

;WITH stored_procedures AS ( SELECT o.name AS proc_name, oo.name AS tables_used_in_procedure, ROW_NUMBER() OVER(partition BY o.name,oo.name ORDER BY o.name,oo.name) AS ROW FROM sysdepends d INNER JOIN sysobjects o ON o.id=d.id INNER JOIN sysobjects oo ON...

0

Install Mac OS on Dell Precision 690 Workstation

Lastest: The following guide is a complete walkthrough for updating to or installing a fresh version of macOS Sierra. It requires no experience and all of the basic installation and post-installation tools are available...

0

Run SQL Code Block with Variables in Oracle SQL Developer

DECLARE p_cart_id NUMBER:= 125330; p_cart_item_id NUMBER; BEGIN FOR i IN 1..200 LOOP — get next sequence p_cart_item_id := tbl_cart_item.NEXTVAL;   –insert new line from select INSERT INTO TBL_CART_ITEM(cart_item_id,cart_id,item,qty, line_no) SELECT t.* FROM ( SELECT...