Category: Computer

computer related topics



Download COM object from or from NuGet Example Code in   Imports WinSCP —–   Try ‘ Setup session options Dim sessionOptions As New SessionOptions With sessionOptions .Protocol = Protocol.Ftp .FtpSecure =...


To get list of tables used in a stored procedure

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


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...


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...