Akram@microsoft786

Software Engineer's Corner

Sunday, 23 August 2015

Auto gen ID in Sql

 Auto Gen ID  in Sql
SELECT @AdmnNo=CAST(LEFT(@AdmnSessYr,4)+RIGHT(@AdmnSessYr,2)+'0001' AS BIGINT)
Posted by Unknown at 22:57
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Auto gen ID in Sql

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

Unknown
View my complete profile

Blog Archive

  • ►  2018 (3)
    • ►  June (2)
    • ►  April (1)
  • ►  2017 (1)
    • ►  March (1)
  • ►  2016 (6)
    • ►  November (6)
  • ▼  2015 (77)
    • ►  October (25)
    • ►  September (2)
    • ▼  August (13)
      • popup modal
      • pop up on link button click
      • On Check Grid view Rows color change
      • Triggers for Update Panel
      • Export Data into Excel
      • Auto gen ID in Sql
      • Sql Helper Class
      • Validation
      • Encrypt And Decrypt Function
      • Pop up calender values
      • Check Permission
      • Retribe all databse name from Server
    • ►  July (2)
    • ►  June (5)
    • ►  May (11)
    • ►  April (7)
    • ►  March (2)
    • ►  February (3)
    • ►  January (7)
  • ►  2014 (1)
    • ►  December (1)
Ethereal theme. Powered by Blogger.