top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to return truly random data from a table?

+2 votes
501 views

How to return truly random data from a table?

posted May 2, 2014 by Muskan

Looking for an answer?  Promote on:
Facebook Share Button Twitter Share Button LinkedIn Share Button

Similar Questions
+3 votes
SQL Server - Update column from data in the same table

I have a table that looks something like this:

SetId ID Premium 
2012 5 Y 
2012 6 Y 
2013 5 N 
2013 6 N

I want to update the 2013 records with the premium values where the setid equals 2012.
So after the query it would look like this:

SetId ID Premium 
2012 5 Y
 2012 6 Y 
2013 5 Y 
2013 6 Y

Any help greatly appreciated

+2 votes
How do I assign a cursor or table data type?

I want to assign the values if Cursor or table in a single column.
Is it possible directly?
If not ant other way to store it?

...