Solved

Auto-generate Dummy Records (SQL Server)

Posted on 2006-11-21
7
715 Views
Last Modified: 2012-05-05
I need to populate a SQl Server 2005 table with dummy records.  My boss says this is a new 2005 feature, and I cannot use SQL statements. Any Ideas???
0
Comment
Question by:servicegroup
  • 4
  • 3
7 Comments
 
LVL 8

Accepted Solution

by:
drydenhogg earned 500 total points
ID: 17988323
If the feature exists, I have never come across it, I would ask your boss to substanciate his claim. What makes it even more bizarre is to suggest it is a SQL Server feature, but that you are not to use SQL Statements to do it.

I'd be a very happy man if it existed, that's for sure.
0
 
LVL 3

Author Comment

by:servicegroup
ID: 17988566
She assured me that this feature exists, and a coworker witnessed the presentation.
0
 
LVL 8

Expert Comment

by:drydenhogg
ID: 17988683
Sounds like the 'presentation' is possibly from someone (vendor) with a product.

Thinking outside of SQL Server, I can't remember the datadude ctp's having it, and Im trying to think whether perhaps they are thinking of something from visual studio team studio - test edition, there are test generation tools in that, in terms of creating code coverage through automatic parameter generation. Possibly they have seen a dmeonstration of something in that?



0
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 
LVL 3

Author Comment

by:servicegroup
ID: 17988815
It was a microsoft conference, and they assured me it was done on SQL Server, not VS.
0
 
LVL 8

Expert Comment

by:drydenhogg
ID: 17988858
Drawing a blank then, nothing in SP2 added to do this that I have seen, not seen it as a base feature of 2005 - be a very happy man if it exists as a current feature, or is due in sp2 etc.
0
 
LVL 3

Author Comment

by:servicegroup
ID: 17988894
Thanks. I will post any good news.
0
 
LVL 3

Author Comment

by:servicegroup
ID: 18028180
SQLIS.com has a record generator for use in the Business Intelligence Development Studio, but it only creates string and numeric fields.  I guess it might be useful if you were not creating tables for the real world.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Restore Procedure question 4 31
ms sql stored procedure 22 77
shrink datafile Sql server 4 17
Test a query 23 18
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now