then use trigger(After Insert) on child table which handle master table.

what kind of changes you want to see in child table

please give more focus on what you want

going with alter column method is best option according to me as its a primary column for your table.

any column string of entire database table.

can you tell me purpose of doing so

it may have batter alternate for the same.

string means what is it any column value

like

select * from a where abc='xyz'

or any string in store procedure

your query return only those recode of where clause od.p_id in (1,2,3,5)

select * from persons s left join orders od on s.p_id = od.p_id

Where od.p_id in (1,2,3,5)

if you want...

try this

declare @sql varchar(max)

select @sql=coalesce(@sql,'')+columnname

from

tablename

select @sql

please post table structure and more sample data

also give more focus on what you want.

your query seems ok and working fine

may be you are selecting LEFT(127.0.0.1,len(127.0.0.1)-charindex('.',reverse(([Ip])))) which may leads you to confusion

you can try putting ip in select and find where's the problem

select...

( problem in your query

select

LEFT(127.0.0.1,len(127.0.0.1)-charindex('.',reverse(([Ip]))))

from tablename

try this if you know columns(limited columns)

select

(case when key='Key1' then value) as 'Key 1'

,(case when key='Key2' then value) as 'Key 2'

,(case when key='Key3' then value) as 'Key 3'

from...

Try this

CREATE PROC TestProc1 (@id INT)

AS

BEGIN

if(@id=0) --if you pass null then no need to write this code instead of 0 for all recods from Code behind

...

what if you use coalesce and make one query combine all diff where columns

like

select * from emp

where id=coalesce(@id,id) and name=coalesce(@name,name)

and make one index of all combine columns...

try this one

declare @string varchar(20)

set @string='e33,B6661,C1'

select substring(@string,charindex(',',@string)+1,charindex(',',@string,charindex(',',@string)+1)-charindex(',',@string)-1)

is your chargeAmount is INT then you need to convert it to decimal to get decimal in SUM