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

What is merge?

0 Answers  


1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"

8 Answers  


How to drop existing views from a database in ms sql server?

0 Answers  


Mention the different types of replication in sql server.

0 Answers  


How many non clustered indexes there can be on table ?

0 Answers  






Can someone suggest me the best institute to learn SQL Server... I want to gain in depth knowledge on SQL Server Development. I have been to naresh, peers, sql school,mind q systems... Any idea about best faculty....

3 Answers  


How do I find the default sql server instance?

0 Answers  


how to replace double quotes by single quotes in sql server

2 Answers   CAC,


How many types of functions are there in sql server?

0 Answers  


What is the difference between index seek vs. Index scan?

0 Answers  


Does partitioning ssd reduce performance?

0 Answers  


Explain ms sql server reporting services vs crystal reports?

0 Answers  


Categories