---
title: "how to use function to generate rand number in mssql server?"  
description: "how to use function to generate rand number in mssql server?"  
author: "Amit Singh"  
published: 2010-11-09  
updated: 2020-09-20  
canonical: https://www.mindstick.com/interview/222/how-to-use-function-to-generate-rand-number-in-mssql-server  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# how to use function to generate rand number in mssql server?

we use rand function in sql server to generate random number\
\
* **RAND(seed) -** Starting a new sequence of random numbers based on the given integer "seed" and returning the first random number in FLOAT(53) from the sequence.\
* **RAND() -** Returning the next random number in FLOAT(53) from the current sequence. If there has been no current sequence, SQL Server will start a new sequence with a random "seed".\
\
for example:\
SELECT RAND(100);\

## Answers

### Answer by Amit Singh

we use rand function in sql server to generate random number\
\
* **RAND(seed) -** Starting a new sequence of random numbers based on the given integer "seed" and returning the first random number in FLOAT(53) from the sequence.\
* **RAND() -** Returning the next random number in FLOAT(53) from the current sequence. If there has been no current sequence, SQL Server will start a new sequence with a random "seed".\
\
for example:\
SELECT RAND(100);\


---

Original Source: https://www.mindstick.com/interview/222/how-to-use-function-to-generate-rand-number-in-mssql-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.