Macca
public sql v1 · immutable INSERT INTO [Town] ( [StateId], [Name], [PostCode] ) VALUES ( (SELECT [StateId] FROM [State] WHERE [Abbreviation] = @State), @Name, @PostCode ); INSERT INTO [Town] ( [StateId], [Name], [PostCode] ) VALUES ( (SELECT [StateId] FROM [State] WHERE [Abbreviation] = @State), @Name, @PostCode );