Interview Question in Sql Server 2000


 

Interview Question :: Help me i need a professional SQL server developer, using DotNet

how can i insert/update a table and get the values from another tables using SQl server 2000 strored procedure,in other way the user will insert an information as a 'string' and my table is a "smallint " the values must convert to a small int using another table the another table have 2 columns (1D as int,str as varchar(20)) the user input from the str and i have to insert the ID of that str.

please help me imediatlly
by ksk