Mohammad Towhidul Islam

    20-Feb-21 06:39:54 pm

    Copy Table In Microsoft SQL Server

    Copy Table In Microsoft SQL Server
    SELECT * INTO IERP_GARMENT.dbo.mfg_bom_master FROM IERP_MODERN_WOOD.dbo.mfg_bom_master ...

    Read More


    Mohammad Towhidul Islam

    12-Jul-17 01:12:35 pm

    Create a unique constraint that also allows nulls in MSSQL Server

    Create a unique constraint that also allows nulls in MSSQL Server
    CREATE UNIQUE NONCLUSTERED INDEX uni_lot_master_doc_ref ON item_lot_master(doc_ref) WHERE doc_ref IS NOT NULL; ...

    Read More


    Mohammad Towhidul Islam

    12-May-17 04:39:04 pm

    Delete SQL Server Old Database using cmd

    Delete SQL Server Old Database using cmd
    Connect to the SQL ServerStep 1 Open command promptStep 2 Command as follows: C:\Users\UserName> sqlcmd -S localhost\sqlexpress Display all ...

    Read More


    Mohammad Towhidul Islam

    23-Jun-16 11:44:30 am

    How to change sa password in SQL Server Express?

    How to change sa password in SQL Server Express?
    If you want to change your 'sa' password with SQL Server Management Studio, here are the steps:1 Login using Windows Authentication and ".\SQLExpress" as...

    Read More


    Mohammad Towhidul Islam

    16-Jun-15 02:11:35 pm

    Working with SQL Server using Management Studio (SSMS)

    Working with SQL Server using Management Studio (SSMS)
    SQL Server Management Studio (SSMS) Basics SQL Server Management Studio (SSMS) is one of the most important tools you’ll use with SQL Server. It provides a user-interface for common database task...

    Read More


    Mohammad Towhidul Islam

    10-Apr-15 12:40:09 pm

    Developing Microsoft SQL Server 2014 Databases

    Developing Microsoft SQL Server 2014 Databases
    If you are new to SQL databases, this 5 hour(!) video starts with the absolute basics, and progresses into fairly advanced use, tuning and debugging. Some of it is specific to MSSQL Ser...

    Read More


First1Last
1 of 1 pages