SQL Server Update New Column
-
Dears, I have SQL Server table which includes contains follwing columns File Name Telephone MemeberName_TelephoneNumber_IDNUmber ,TelephoneNumber I need to add one or more column named ID Number and get the value from column Filename.what is the query to get the result? please help me
-
Dears, I have SQL Server table which includes contains follwing columns File Name Telephone MemeberName_TelephoneNumber_IDNUmber ,TelephoneNumber I need to add one or more column named ID Number and get the value from column Filename.what is the query to get the result? please help me
Not entirely clear what you are asking but this might set you in the right direction:
declare @Id int
set @Id = 999
select FileName from [table] where IDNumber = @IdHoep that helps.
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair. nils illegitimus carborundum me, me, me