Skip to main content

Liana Ali

Sharing random things with random people! ♥

Search This Blog

Showing posts with the label database

Posts

SQL: Why Stored Procedure execution slower from normal select query?

on Sunday, September 26, 2021

#HowTo #technology #Tips #tutorial command database it mssql parameter sniffing query select script stored procedure slow select fast

+

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

SQL: How to send custom email notification with attachment in MSSQL?

on Friday, September 24, 2021

#HowTo #technology #Tips #tutorial attachment custom html email notification database database mail email group hacks it mssql notification query select script send email sp_send_dbmail sql

+

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

SQL: How to SELECT TOP 1 in JOIN Query?

on Friday, July 17, 2020

#HowTo #technology command database info it latest microsoft mssql order by query sql sql server tips tutorial

+

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Author

.Liana Ali.

Hey peeps! :)

Instagram: @lianaali.official

Latest Popular Posts

NPM: Unable to Verify the First Certificate

I just recently given a test whereby one of the question requires me to build an API. There's plenty of ways on how to complete the test. I can always stick with C#/ASP.Net, but I decided to try something new; NodeJS and MongoDB . Both of it is fairly new to me. As usual, I do some research online in order to find the right tutorial where I can learn and understand how they work and their syntax as well. For me, as long as you get the logic right, it doesn't matter what language you use, you'll get there in no time . :) Problem I found this tutorial very helpful; Build a Node.js API in Under 30 Minutes . While following the steps in that tutorial, I encounter this issue(s) when I tried to "npm install". It displayed below error. If you refer to the above screenshot; the root cause of the error is because it's unable to verify the first certificate. Based on my previous experiences, it might caused by the https. Solution As usual, I start digging a

ESC/POS: Print QR Code on Receipt

QR code has been used widely in the past few years; either for ticketing, purchasing and etc. Since last year, it's usage become trending technology when e-wallet industry emerge . Some of us might have different ways on how to print it on receipt/ticket; send qr code as image and print, or send the data to be convert to qr code and let the printer do the work. This entry will guide you on how to print qr code using receipt printer ( Model: Pioneer STEP-5e Receipt Printer ) by using ESC/POS command in C#/.NET . COMMON ESC/POS COMMANDS ESC a 0 = align left ESC a 1 = align center ESC a 2 = align right ESC E 1 = turn on bold/emphasize mode ESC E 0 = turn off bold/emphasize mode ESC d n = feed/extra nth line GS V 66 = partial cut for receipt ESC @ = initialize printer QRCODE ESC/POS COMMANDS 1. Selects QR Code model Function 165: GS ( k pL pH cn fn n1 n2 2. Sets the module size of QR Code Function 167: GS ( k pL pH cn fn n 3. Selects the error correction level for

Translation

Powered by Blogger

Copyright © Liana Ali 2011 - 2023