How can we help you today?

How can we help you today?

Hardcode the Foreign Key value

Hi

I have a User table with UserStatusId as foreign key, where UserStatus table have two rows

UserStatusId Name
1 Active
2 Deleted

I am going to populate the User table, but i need to populate only Active users, that means UserStatusId is 1.

How should i do it in SQL Data Generator 1? Any suggestions?

hashcoderz April 24, 2012 02:15

0

Comments

1 comment

I believe using the Generic - SQL Statement generator may be able to accomplish what you are looking for.

See here for more information.

http://www.red-gate.com/supportcenter/Content?p=SQL%20Data%20Generator&c=SQL_Data_Generator/help/1.2/SDG_generic_generators.htm&toc=SQL_Data_Generator/help/1.2/toc52077.htm#o5532

Hope this helps.

Manfred.Castro April 25, 2012 05:32

0

Add comment

Please sign in to leave a comment.