Dynamic SQL

Technical Article

RE: randomized update

  • Reply

try this DECLARE @RandomValues TABLE ( RandVal int ) DECLARE @Tbl TABLE ( Id int identity, RandVal int ) INSERT INTO @RandomValues VALUES (1) INSERT INTO @RandomValues VALUES (4) INSERT INTO @RandomValues VALUES (6) INSERT INTO @RandomValues VALUES (10) INSERT INTO @Tbl (RandVal) VALUES (NULL) INSERT INTO @Tbl (RandVal) VALUES (NULL) INSERT INTO @Tbl (RandVal) […]

You rated this post out of 5. Change rating

2003-05-27

Blogs

Enabling an Index: #SQLNewBlogger

By

I don’t do a lot of work with disabled index, but I learned how...

Back to Boston for SQL Saturday

By

I’m leaving again tomorrow for a trip. This time I head back to Boston...

T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?

By

Most of us who work with data have, at least a few times, been...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers