Bulk Insert into Database – Dump your bulk data into Database

Bulk Insert in Database
Dump your bulk data files into Tables. Values of Row Terminator and Field Terminator changes according the requirement.

 

 

 

Ask for Google Plus Reviews to your clients

You can ask your clients to give feedback about your product through your Google Plus profile. You need to have Google Plus profile to do that. You can redirect users to your Google Plus profile just by adding “?hl=en&review=1” after the URL.

Sample URL – https://plus.google.com/104588473734084240116/posts?hl=en&review=1

But the user should be logged in to Google Account to do the action.

Reference Article – https://www.webworksofkc.com/blog/get-more-google-business-reviews-by-giving-customers-a-direct-link/

 

Change the exisiting schema of MSSQL database

You can change the schema of existing MS SQL database by below query.

 

Make DIRLISITING for specific extension or all files

Make the DIR Listing for specific format or for all files