March 2, 2022

How to Add SQL Linked Server on SQL Server

This SQL Server 2012 tutorial shows how to add linked server to SQL Server 2012 instance. Here is a step by step SQL Server linked server […]
February 28, 2022

Update first 2 characters in SQL

DECLARE @ReplaceString CHAR(2) SET @ReplaceString = 'C:' UPDATE [DATABASENAME].[dbo].[TABLENAME] SET TABLENAME= REPLACE(TABLENAME, LEFT(TABLENAME, 2),@ReplaceString) WHERE LEFT(TABLENAME,2) = 'P:'
January 14, 2022

HOW I SOLVED the error: The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine

The solution that you will find everywhere for this error is to install the Microsoft Access Database Engine. If you have the 32bit version of office, […]
February 11, 2021

How to Install LAMP Stack with PhpMyAdmin in Ubuntu

LAMP stack is the combination of the most frequently used software packages to build dynamic websites. LAMP is an abbreviation that uses the first letter of each of the packages included […]
gdpr-image
This website uses cookies to improve your experience. By using this website you agree to our Data Protection Policy.
Read more