Database

--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?

select * from Gallery1 where SmallImage = "whatever" And 
Exists (Select Distinct(SmallImage) From Gallery1 Where Active=1)

select * from Gallery1 where SmallImage = '~/Gallery/Bhaiji in USA/Small/IMG_0028.jpg' And 
Exists (Select Distinct(SmallImage) From Gallery1 Where Active=1)

Select * From Gallery1 Where SmallImage='~/Gallery/Bhaiji in USA/Small/IMG_0028.jpg' and SmallImage in
(Select Distinct SmallImage From Gallery1 Where Active=1)