Simple Url shortener script using Sql and TinyURL
Simple Url shortener script using Sql and TinyURL Posted On: April 16, 2019 Published By: Rachel Jaya Prabha S A URL shortener is very useful script to shorten your large URL. In this post, I explain you how to code for URL shortener. URL sharpeners are being used more now than ever because people need to post short links on Twi!er, Facebook, SMS etc. Long links can some%mes take up the en%re 140-character limit. So, the solu%on is to shrink a long URL into a short one. Example: Declare @InputURL varchar(200),@CreateURL varchar(500),@Obj Int,@TinyURL varchar(500) Set @InputURL='https://en.wikipedia.org/wiki/Search_engine_marketing' --//Create Tiny URL set @CreateURL = 'http://tinyurl.com/api-create.php?url='+ @InputURL exec sp_OACreate 'MSXML2.ServerXMLHttp', @Obj OUT exec sp_OAMethod @Obj, 'Open', NULL, 'POST', @CreateURL, false exec sp_OAMethod @Obj, 'send' exec sp_OAGetProperty @Obj, 'responseText', @TinyURL O...