Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Goce Smilevski,
While it's not likely that many of you need to find prime numbers using T-SQL, it is an interesting ...
"Trying to create a sp that prints Prime numbers upto 500"
Generates prime numbers and puts them into a table for future reference by adhoc queries and databas...
Very simple and straightforward script that creates a temporary table and fills it with prime number...
Select prime numbers