SELECT
STUFF((SELECT
' ' + CAST(NUMBER AS VARCHAR)
FROM MASTER..SPT_VALUES
WHERE NUMBER BETWEEN 2000 AND 2010
FOR XML PATH ('')), 1, 1, '');
Sequência de números em linha no SQL Server
Responder
Arquivo da tag: sql_server
RowNum SQL Sever
Script para gerar número randômico no SQL Server
Random Number Generator
There are many methods to generate random number in SQL Server.
Method 1 : Generate Random Numbers (Int) between Rang
---- Create the variables for the random number generation
DECLARE @Random INT; Continue lendo