How to Generate a Series of Random Integers With T-SQL?

Question Posted / guest

How to Generate a Series of Random Integers With T-SQL?..

using rand()

select rant()

Is This Answer Correct ?

5 Yes

0 No

More SQL Server Interview Questions

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

Can select statements be used on views in ms sql server?

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

What does set rowcount do?

Why use update_statistics command in sql server?

What is exporting and importing utility?

What do u mean by orphan users, how will u list them in the DB

Does order by actually change the order of the data in the tables or does it just change the output?

How to get number of days in a given year?

what is a self join? Explain it with an example? : Sql server database administration

How extra digits are handled with numeric data type literals?

How to get a list of columns in a view using the "sp_help" stored procedure?

For more SQL Server Interview Questions Click Here