Hardcode the Foreign Key value

hashcoderz

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?

Manfred.Castro

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.