Interview Question in Sql Server 2000


 

Interview Question :: PLZ help me i need a professional SQL server developer, using DotNet? To insert from table

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 (ID 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 PLZ PLZ PLZ
by ksk