Become Joomla Developer

How To Run T-SQL Statement

What is SQL Statement?

SQL is short for Structured Query Language and is a widely used database language, providing means of Data Manipulation Langurage(DML), that use to store, retrieve, update, delete. And Data Definition Language(DDL), The most basic items of DDL are the CREATE, ALTER, RENAME, TRUNCATE and DROP statements.

Run SQL Statement

  1. Open New Query
    Click on New Query in SQL Server 2005
  2. Write your code SQL statement
    Example.
    USE TestScript
    SELECT ProductID,ProductName,Price FROM tblProduct
    
    SQL Statement
    Keyword USE use to select Database. TestScript is the Database name.
  3. Click on Execute
    Click on Execute to run your SQL Statement

Suggestion | Contact US | About US | Term of Use | Privacy Policy | Advertiseing