Technical Article

FTP files using SQL stored procedure

This stored procedure takes four parameters1)file to ftp2)server name or IP3)ftp login4)ftp passwordSP will ensure that local file exists before continuing,it will create and execute a batch file in order to push the file to the remote FTP server.--exec exampleEXEC dbo.up_FTPPushFile 'c:\temp\test.txt', 'server', 'user', 'password'

(2)

You rated this post out of 5. Change rating

2002-12-09

4,883 reads

Technical Article

Add Check Digit (LUHN)

If you ever need to create a credit card like number this stored procedure is for you.Most credit cards contain a check digit, which is the digit at the end of the credit card number. To generate the check digit, the LUHN formula is applied to the number. To validate the credit-card number, the check […]

You rated this post out of 5. Change rating

2002-11-30

4,305 reads

Blogs

Overcoming Imposter Syndrome: A Plan

By

My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...

Advice I Like: Celebrate Success

By

“On the way to a grand goal, celebrate the smallest victories as if each...

Programmatically Retrieving MLV Lineage and Refresh Times

By

Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...

Read the latest Blogs

Forums

BCA KCP ITC Roxi Mas Telpon/WA:087768193341

By matkydablog

BCA KCP ITC Roxi Mas Telpon/WA:087768193341.ITC ROXY MAS, Jl. Kh Hasyim Ashari No.125 Basement...

BCA KCP Grand Cempaka Mas Telpon/WA:087768193341

By matkydablog

BCA KCP Grand Cempaka Mas Telpon/WA:087768193341.Ruko Mega Grosir Cempaka Mas, Blk. A Jl. Letjen...

BCA Wisma Asia II Lt 12,Telpon/Wa 0821-8200-239

By crowdfundingsoftware

RQ6X+98R, Jl. Brigjen Katamso No.1 4, RT.4/RW.9, Kota Bambu Sel., Kec. Palmerah, Kota Jakarta...

Visit the forum

Question of the Day

Increase Deadlock Detection

How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?

See possible answers