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



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

Answer / laxman

using rand()

select rant()

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More SQL Server Interview Questions

check, not null,unique

2 Answers   IBM,


How to a Query to copy data from on table to another table.

6 Answers   Cap Gemini,


How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)

5 Answers   Infosys, McAfee,


what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

0 Answers  


Explain what is the use of custom fields in report?

0 Answers  






Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

0 Answers  


How to truncate a table first before running a package?

1 Answers  


What is tempdb in sql server?

0 Answers  


What is onf in normalization form?

0 Answers  


How exceptions can be handled in sql server programming?

0 Answers  


What is SQL server agent?

2 Answers   HCL, SAP Labs,


What are the approximate numeric data types?

0 Answers  


Categories