Asp.Net With C# & Windows Application

This blog is only for C# Windows Aplication & Web Application & Other feature is css & jquery & Sql store procedure

Pages

  • Home
  • Asp.Net Special
  • Windows Application
  • SQL Server
  • CSS
  • GK Of IT
  • MVC
Showing posts with label Random Number. Show all posts
Showing posts with label Random Number. Show all posts

Sunday, January 14, 2018

How to generate random 10 digit number using sql

SELECT RIGHT('000000' + CAST(ABS(CHECKSUM(NEWID())) % 9999999999 AS varchar(10)), 10)
Posted by Hardik Deshani at 1/14/2018 02:20:00 PM No comments :
Email This BlogThis! Share to X Share to Facebook Share to Pinterest
Labels: 10 digit no generate from sql , 10 digit random number , Random Number , SQL , sql server
Older Posts Home
Subscribe to: Posts ( Atom )

Pageviews

My Blog List

  • MS Sql Server 2005 to 2017
    How to use SQL UNION
  • SQL - MVC - ASP.NET - Angular JS - Javascript - JQuery
    How to create talk bubble using css

Search This Blog

Featured Post

How to mearge multiple PDF files with page number using PDFSharp using C# MVC

In this article how to mearge multiple PDF file using PDFSharp dll in c# MVC first install this package from nuget "Install-Package ...

Popular Posts

  • How to create excel file from data table using NPOI in c# asp.net or MVC
  • Import Excel Data To Gridview Using C#
  • How to create KBC game in c# desktop application

Followers

Search This Blog

Blog Archive

  • ▼  2018 ( 14 )
    • ▼  January ( 14 )
      • How to mearge multiple PDF files with page number ...
      • How to delete files from directory using c# MVC
      • How to create excel file from data table using NPO...
      • Download image or file from Azure Blob Storage usi...
      • Send mail using office365 email id
      • How to upload file in azure blob storage explorer
      • How to create Insert or Update query from select s...
      • How to generate random 10 digit number using sql
      • How to send Twillo SMS from Azure function
      • Javascript - How to call function after complete p...
      • How to create website thumbnail from URL in C# .net
      • How to convert xElement to XML Node in C#
      • What is MVC and How it's work
      • SQL DROP TABLE Statement
  • ►  2017 ( 20 )
    • ►  December ( 18 )
    • ►  November ( 2 )
  • ►  2016 ( 2 )
    • ►  July ( 2 )
  • ►  2015 ( 11 )
    • ►  May ( 2 )
    • ►  March ( 9 )
  • ►  2013 ( 19 )
    • ►  July ( 2 )
    • ►  June ( 15 )
    • ►  May ( 2 )

About Me

My Photo
Hardik Deshani
YO, I AM HARDIK I am developer since 2012 to continue working in C# technologies and learn something new every day.
View my complete profile
Theme images by Jason Morrow. Powered by Blogger.