LogoMakerCa-1587613265609_edited.jpg
  • Home

  • About

  • Video Tutorial

    • Microsoft Power BI
    • Alteryx
    • Tableau
    • MicroStrategy
    • HP LoadRunner
    • HP UFT
  • Text Tutorial

    • Microsoft Excel
    • SQL
  • Downloads

    • Microsoft Power BI
  • Reach Us

  • More

    Use tab to navigate through the menu items.
    • Udemy
    • Facebook
    • Twitter
    • YouTube
    • Linkedin

    IDENTITY COLUMNS /AUTO INCREEMENT

    SYNTAX | PRACTICE YOURSELF

    Identity column is a column whose value increases automatically as and when data is inserted into the table. The value in an identity column is created by the server. A user cannot insert a value into an identity column; it’s created by the server.

    Identity column can be used to uniquely identify the rows in the table and acts like a primary key field.

    SYNTAX

    39.png
     
     

    PRACTICE YOURSELF 

    40.png
    Previous
    Next
    Back to Top

    Want More SQL Deep Dives

    1. SQL Introduction

    2. Database Overview

    3. Creating a Database

    4. Dropping a Database

    5. Table Fundamentals

    6. Table Types

    7. Datatypes in SQL

    8. DDL, DML, TCL & DCL

    9. Null & Not Null Values

    10. Creating Tables

    11. SQL - Constraints

    12. SQL - Index 

    13. SQL Inserting Data

    14. SQL Identity Columns

    15. Selecting Data

    16. Using Distinct

    17. SQL in NOT IN

    18. Using Top Clause

    19. Where Clause

    20. Group By

    21. Order By

    22. Having

    23. Exists

    24. Offset

    25. SQL - Operators

    26. Between

    27. Update

    28. Delete

    29. SQL - Aggregate Functions

    30. SQL - Introductions to Joins

    31. Table Alias

    32. SQL - Inner Join

    33. SQL - Left Join

    34. SQL - Right Join

    35. Full Join

    36. Self Join

    37. SQL Union

    38. Pivot

    39. Alter Command

    40. Limit Clause

    41. Truncate

    42. Drop

    43. Table Backup

    44. SQL - Normalization

    45. Subquery

    46. SQL - Views & Materialized Views

    47. Case Statement

    48. SQL Transactions

    49. SQL - Scaler Functions

    50. Working with Dates

    51. Grant revoke

    52. SQL - Performance Tunning

    53. Stored Procedure Basics

    54. Stuff function

    55. Keyword

    56. SQL - Miscellaneous

    ©2020 by Pavan Lalwani.