Jan

WMUG

WMUG
Windows Management User Group Community blogs
  • Using Data Manipulation Function

    • 0 Comments
    Issue with function is that they tend to be DBMS specific. Only few are supported by all popular DBMS. Although function is the same the implementations is not. Therefore they are not portable. Portable: Code that is written so that it will run on multiple...
  • SQL Creating Calculated Fields

    • 1 Comments
    Field It really mean the same thing as column, although database columns are typically called columns and the term fields is normally used in conjunction with calculated fields. Concatenating Fields Concatenate Joining values together to form a single...
  • SQL Wildcard Filtering

    • 0 Comments
    Wildcards – Special characters used to mach parts of a value. Search Pattern - A search condition made up of literal text, wildcards characters, or any combination of the two. The Percent Sing (%) Wildcard it means to mach any number of occurrences of...
  • SQL Advanced Data Filtering updated

    • 0 Comments
    Here I show you how to combine WHERE clauses to create very efficient search conditions. Also we will be using Not and In operators. Combining WHERE Clauses Operator: A special keyword used to join or change clauses within a WHERE clause. Can be called...
  • SQL Advanced Data Filtering

    • 0 Comments
    Here I’ll show you how to combine WHERE clause so you can create more complex search conditions. Also we will see NOT and IN operators in action. Operator: also know as Logical operator, used to join or change clauses within a WHERE clause. If we want...
  • SQL Filtering Data

    • 0 Comments
    Here I’ll show you how to use SELECT’s statement’s WHERE clause to specify search conditions. SELECT prod_name, prod_price FROM Products WHERE prod_price = 3.49; So DBMS retrieved only rows with prod_price value of 3.49 WHERE Clause Operators: OPERATOR...
  • SQL Sorting Retrieved Data

    • 0 Comments
    Here I’ll show you how to use the SELECT statement's ORDER BY clause to sort retrieved data as needed. Sorting by SINGLE column: SELECT prod_name FROM Products ORDER BY prod_name; So the DMS has retrieved data and sort them alphabetically. Sorting...
  • SQL Retrieving Data

    • 0 Comments
    So this is where we star learning. I have to mention that my sample database came with the book I bought. Is it very helpful and it will speed up your learning. Open your SQL Server 2012. You can right click on your database and select new query witch...
  • SQL Basics

    • 0 Comments
    Here is some basic terminology used in SQL. SQL: Structured Query Language. Database: A container to store organized data. Table: A structured list of data of a specific type. Schema: Information about database and table layout and properties. Datatype...
  • How to start with SQL

    • 1 Comments
    If you going to learn SQL you will need database management program. You can download SQL Server 2012 from here : http://technet.microsoft.com/en-gb/evalcenter Install and you are ready to go.
  • At the beginning of a journey. . .

    • 1 Comments
    Yes, indeed I am and looking forward to it. In the end there is System Center 2012 Configuration Manager. To help me I have some companions with me: Books are lovely. Very happy with them. Just the SCCM2012 is on the way by And of course nothing of this...