Database

DECLARE @tmp TABLE
(
     CityName NVARCHAR(200)
)
  
INSERT INTO @tmp (CityName)
SELECT TOP 10 
    ISNULL(Cities_Localized.[Name], Cities.[Name])
FROM 
    Cities
LEFT JOIN 
    Cities_Localized 
    ON (Cities.CityID = Cities_Localized.CityID) AND 
       (Cities_Localized.Language  = 'en-US') 
WHERE 
    Cities.[Name] LIKE 'T%' OR 
    Cities_Localized.[Name] LIKE 'T%'
  
SELECT 
    CityName 
FROM
    @tmp
ORDER BY
    CityName

SELECT 
    [Name] AS CityName
FROM
    Cities
WHERE 
    [Name] LIKE 'T%'
  
UNION 
  
SELECT 
    [Name]
FROM
    Cities_Localized 
WHERE
    Cities_Localized.Language  = 'en-US' AND
    Cities_Localized.[Name] LIKE 'T%'
  
ORDER BY
    CityName

--Get top 10 city names that do NOT have a localised version.
select top 10 C.CityId, C.Name
  into #tmp
  from Cities C
  left outer join Cities_Localization CL
    on CL.CityID = C.CityID
    and CL.Language = 'en-US'
  where C.Name like 'T%'
  and CL.CityID is null
  order by C.Name

--Add the top 10 localised city names.
insert into #tmp (CityID, Name)
  select top 10 CL.CityID, CL.Name
  from Cities_Localization CL
  where CL.Name like 'T%'
  and CL.Language = 'en-US'
  order by CL.Name

--Return top 10 cities (localised or not).
select top 10 #tmp.Name
  from #tmp
  order by Name

CREATE PROCEDURE DeleteUser
@userId int
AS
DELETE FROM LoginInfo WHERE uid = @UserId;
GO

int userId = int.Parse(user_id.Text);
SqlCommand cmd = new SqlCommand("DeleteUser");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = myConnection;
cmd.Parameters.AddWithValue("@UserId", userId);
cmd.ExecuteNonQuery();

Pete O'Hanlon wrote:

Why on earth do you want a table with only an autogenerated column on it?