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

Answer Posted / laxman

using rand()

select rant()

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is normalization? What number of normalization shapes are there?

611


What will be the maximum number of indexes per table?

538


How to transfer data from a cursor to variables with a "fetch" statement?

588


What methods do you follow to protect from sql injection attack?

519


Can we use where clause with group by?

522






Can we add our custom code in ssis?

555


What is the difference between a "where" clause and a "having" clause?

623


How to create a store procedure with encryption?

527


What is the partitioning method?

538


What is data source view or dsv? : sql server analysis services, ssas

559


Define Unique Key?

596


How do you test your database? : sql server database administration

529


What are different types of join?

765


Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

528


Differentiate between a primary key and a unique key.

604