FabulousCode Blog
    • Showing posts with label SQL SERVER. Show all posts
    Showing posts with label SQL SERVER. Show all posts

    Wednesday, May 13, 2026

    Download ODBC Driver for SQL Server

    May 13, 2026 0
    Download ODBC Driver for SQL Server

     




    Download ODBC Driver for SQL Server

    Applies to:  SQL Server  Azure SQL Database  Azure SQL Managed Instance  Azure Synapse Analytics  Analytics Platform System (PDW)  SQL analytics endpoint in Microsoft Fabric  Warehouse in Microsoft Fabric  SQL database in Microsoft Fabric

    Microsoft ODBC Driver for SQL Server is a single dynamic-link library (DLL) containing run-time support for applications using native-code APIs to connect to SQL Server. Use Microsoft ODBC Driver 18 for SQL Server to create new applications or enhance existing applications that need to take advantage of newer SQL Server features.

    Prerequisites

    Before you install the ODBC driver on Windows, make sure you have the following prerequisites:

    • Visual C++ Redistributable: The ODBC Driver for SQL Server requires the Microsoft Visual C++ Redistributable. If this component isn't already installed on your system, download and install it before installing the ODBC driver. Download the version that matches your system architecture (x64, x86, or ARM64) from Microsoft Visual C++ Redistributable latest supported downloads.

     Note

    Most Windows systems already have the Visual C++ Redistributable installed. If the ODBC driver installation fails or the driver doesn't load correctly, verify that the Visual C++ Redistributable is installed on your system.

    Linux and macOS don't require this component. For Linux and macOS prerequisites, see the installation guides linked in the Download for Linux and macOS section.

    Download for Windows

    The redistributable installer for Microsoft ODBC Driver 18 for SQL Server installs the client components, which are required during run time to take advantage of newer SQL Server features. It optionally installs the header files needed to develop an application that uses the ODBC API. Starting with version 17.4.2, the installer also includes and installs the Microsoft Active Directory Authentication Library (ADAL.dll).

    Version 18.6.2.1 is the latest general availability (GA) version. If you have a previous version of Microsoft ODBC Driver 18 for SQL Server installed, installing 18.6.2.1 upgrades it to 18.6.2.1. The Microsoft ODBC Driver 18 for SQL Server can be installed side by side with Microsoft ODBC Driver 17 for SQL Server.

     Download Microsoft ODBC Driver 18 for SQL Server (x64)
     Download Microsoft ODBC Driver 18 for SQL Server (x86)
     Download Microsoft ODBC Driver 18 for SQL Server (ARM64)

     Note

    Use the x86 installer on 32-bit machines, the x64 installer on x64 machines, or the arm64 installer on ARM64 machines. The x64 and arm64 installers install both 64-bit and 32-bit drivers.

    Version information

    • Release number: 18.6.2.1
    • Released: March 31, 2026

     Note

    If you're accessing this page from a non-English language version, and want to see the most up-to-date content, select Read in English at the top of this page. You can download different languages from the US-English version site by selecting available languages.
    By at No comments:
    Labels: ,

    Friday, January 14, 2022

    select all columns from first table and only one column from second table on inner join

    January 14, 2022 0
    select all columns from first table and only one column from second table on inner join



     https://stackoverflow.com/questions/14000572/better-way-to-select-all-columns-from-first-table-and-only-one-column-from-secon



    SELECT  tb1.*, tb2.x
FROM    tableA tb1
        INNER JOIN tableB tb2
            ON tb1.a = tb2.a
    By at No comments:
    Labels: , ,

    Wednesday, December 1, 2021

    Multiple case function in sqlserver

    December 01, 2021 0
    Multiple case function in sqlserver





    Example::::

    SELECT GreyReceiveTypeName,

    FROM TBL...XYZ

     CASE GreyReceiveTypeName WHEN 'Bulk' THEN 'Bulk' WHEN 'Sample' THEN 'Sample' WHEN 'Order Related Sample' THEN 'Sample' 

    WHEN 'Others Sample' THEN 'Sample' WHEN 'RETURN' THEN 'RETURN' WHEN 'Replacement' THEN 'Replacement' WHEN 'Coller Cuff' THEN 'Coller Cuff' WHEN 'Coller Cuff' THEN 'Short Qty'

    WHEN 'Process Loss Qty' THEN 'Process Loss Qty'  ELSE '' END ProductionType 
    By at No comments:
    Labels: ,

    Sunday, February 23, 2020

    sql-server-linked-server-creation-error-ole-db-provider-sqlncli11-for-linked-server

    February 23, 2020 0
    sql-server-linked-server-creation-error-ole-db-provider-sqlncli11-for-linked-server

    Setp-1



    Setp-2


     Setp-3

    Setp-4

    Setp-5

    Setp-6

    Setp-7


    LINKED SERVER CONNECTION  QUERY:: 

    SELECT QUERY

    SELECT *
    FROM [192.168.1.110].XX_GROUP.XX_TABLE

    INSERT QUERY

    DECLARE @EmpID INT,@Name VARCHAR(50)

    INSERT INTO [192.168.1.150].DBL_GROUP.dbo.XX_GROUP.XX_TABLE(EmployeeId, Name)
    Select @EmpID,@Name 




    OPENSQL OLEDB DATA SOURCE CONNECTION :: 

    You Must be copy this  Below Code and  Run into SQL SERVER Management Studio.

    ==========================================================
    EXEC sp_configure 'show advanced options', 1
    RECONFIGURE WITH OVERRIDE
    GO
    EXEC sp_configure 'ad hoc distributed queries', 1
    RECONFIGURE WITH OVERRIDE
    GO

    Include OPENDATASOURCE Query This Way

    SELECT TOP 1 * FROM OPENDATASOURCE ('SQLOLEDB', 'Data Source=192.168.1.110;User ID=XX;Password=XXX').TESTDATABASE.dbo.TAST_TABLE
    By at No comments:
    Labels: ,

    Tuesday, December 17, 2019

    SQL SERVER Multiple LIKE Statements

    December 17, 2019 0
    SQL SERVER Multiple LIKE Statements

    SQL SERVER  Multiple LIKE Statements::

    WITH CTE AS
(
SELECT VALUE
FROM (
        VALUES ('B79'), ('BB1'), ('BB10'), ('BB11'), ('BB12'), ('BB18'), ('BB2'), ('BB3'), ('BB4'), ('BB5'), ('BB6'), ('BB8'), ('BB9'), ('BB94'), ('BD1'), ('BD10'), ('BD11'), ('BD12'), ('BD13'), ('BD14'),
                ('BD15'), ('BD16'), ('BD17'), ('BD18'), ('BD19'), ('BD2'), ('BD20'), ('BD21'), ('BD22'), ('BD3'), ('BD4'), ('BD5'), ('BD6')
     ) V(VALUE)
)   

    
SELECT * 
FROM tbl_ClientFile T
WHERE EXISTS ( SELECT TOP 1 1 FROM CTE WHERE T.CLNTPOST1 LIKE CTE.VALUE + '%')

    OWN Exercise ::

    WITH CTE AS
(
SELECT VALUE FROM (VALUES ('Generator'),('REB')) V(VALUE))   
SELECT  date,MCName
FROM TBL_UtilityGeneratorBoilerLogBook T
WHERE CAST(CONVERT(VARCHAR, date, 106) AS DATETIME) between '2019-12-01 00:00:00.000' and '2019-12-16 00:00:00.000'  AND
EXISTS ( SELECT * FROM CTE WHERE T.MCName LIKE  '%'+ CTE.VALUE + '%' )
    By at No comments:
    Labels: ,

    Monday, September 2, 2019

    SQL QUERY IS NOT NULL AND IS NULL VALUE COMBINATION QUARY

    September 02, 2019 0
    SQL QUERY IS NOT NULL AND IS NULL VALUE COMBINATION QUARY




    SELECT DISTINCT SpecialWorkID, OrderDetailBodyID, SpecialWorkTypeID, TypeStatus, createby
    FROM dbo.tblSpecialWorks
    WHERE (OrderDetailBodyID = 437848) AND isnull(createby , 'Md. Nuruzzaman')='Md. Nuruzzaman'
    By at No comments:
    Labels: ,

    Sunday, September 1, 2019

    SQL SERVER TABLE CREATE NEW FIELD UPDATE, DELETE

    September 01, 2019 0
    SQL SERVER TABLE CREATE NEW FIELD UPDATE, DELETE

    Create Table ::
    CREATE TABLE Persons (
        PersonID int,
        LastName varchar(255),
        FirstName varchar(255),
        Address varchar(255),
        City varchar(255) 
    );


    Field Update Structure::
    ALTER TABLE table_name

    ADD column_name datatype;

    EXAMPLE::
    ALTER TABLE tblUnitList
    ADD KORMEE_UNITID int;
    By at No comments:
    Labels: ,