insert rows into table with cursor or C# code

Question

I am using C# and sql server 2008,I need to select 10 random rows from one table and insert them to another table and I wanted to do this with cursor in sql server,but I have read a lot about disadvantages of cursor.Now I want to do this via C# code.Does anybody have a better suggestion?? thanks in advance

Community · Accepted Answer · 2017-05-23 10:24:42Z

3

Idea from Select n random rows from SQL Server table

No cursors required:

Insert Into Table1
  (col1, col2)
Select Top 10
  col1, col2
From
  Table2
Order By
  NewID()

edited May 23, 2017 at 10:24

CommunityBot

11 silver badge

answered Nov 18, 2012 at 14:08

Laurence

11k1 gold badge28 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

insert rows into table with cursor or C# code

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related