First of all we create a temporary table , lets call as Datav

create table Datav

(
eid int,
ename varchar(100)
)

Now , we are about to import data from c:\data.csv , assuming fields are separated with coma(,) and records are in separate lines

BULK
INSERT Datav
FROM ‘c:\\data.csv’ — location with filename
WITH
(
FIELDTERMINATOR = ‘,’,
ROWTERMINATOR = ‘\n’
)

This will populate data in that table , provided you have right permissions to access file system.

Case

Here our scenario is to get a redirection towards a URL
Eg. subdoamin.domainname.com must redirect to domainname.com/folderName/subdomain

<rule name=”subdomain_redirect” stopProcessing=”true”>
<match url=”.*” />
<conditions>
<add input=”{HTTP_HOST}” pattern=”^(?!www)(.+)\.domainname\.com$” />
</conditions>
<action type=”Redirect” url=”http://www.domainname.com/folderName/{C:1}" appendQueryString=”false” />
</rule>

In SQL Server its a common requirement to count how many times a particular character is appeared in a string

in “Hello friend” , “l” occurred 2 times 

To find the number of occurrences , lets use a logic by

1. Take total length of the string , say its 12 , in our case
2. Now remove all “l” s
3. Find difference before and after removing “l”
4. This difference is the number of occurrence of “l” in the string “Hello friend”

Example

select len('Hello friend')12select replace('Hello friend','l','')10select len('Hello friend') - len(replace('Hello friend','l',''))2

To solve this use letsencrypt. Install on your cPanel server as root

/usr/local/cpanel/scripts/install_lets_encrypt_autossl_provider

Once installed , this will be available under , WHM > Manage Auto SSL

Once selected , next time when issuing SSL certificate for any of your domain/subdomain , Letsencrypt certificates will be issued from SSL Status window in cPanel interface

for more information , get in touch with us : intertoons.com

Here is how to list all procedures where a table products is related

SELECT Name
FROM sys.procedures
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE ‘%products%’

Always check the latest version from official website

Here is 2 step direct upgrade

Always login as the privilaged user , say root

]# sudo npm install -g n

Now execute

]# sudo n latest

Or you can specify a latest version 12.2.2

]# sudo n 12.2.2

you ll be prompted like this in most cases

Note: the node command changed location and the old location may be remembered in your current shell.old : /usr/bin/nodenew : /usr/local/bin/nodeTo reset the command location hash either start a new shell, or execute PATH="$PATH"

in such case execute this as well

]#PATH="$PATH"

Now verify node version

]#node --version

you are done!