You can set like

select @ch1=N'?'

select @ch2=N'?'

As long as you have relationship among all of them , hope you can have it as a single cude.

But while considering performance, you should have it seperately

You can use Column Type as nvarchar(max) or Text.

And make sure that when you enter values into the columns are enterted with ASCII char for new line of '' (new...

Also you can do like below:

update table set col1=isnull(@newvalue1,col1), col2=isnull(@newvalue2,col2),etc...

You have to use cursor

Use the sysobjects table to get the list of table.

Then loop through one by one and check for the condition you want

Yes, You have to mention all the columns in the SP which are all needs to update

update table set col1=@newvalue1, col2= @newvlaue2, etc...

But there are options for passing values to...

YES. you are correct. I want to know the list of Tables used in the Query.

The purpose is , while executing the Query, i need to add few more columns...

Hi,

Thanks for your reply.

I think i dont explain my requirement

I want to get list of tables in C# coding and not in SSMS

exactly

Say Eg :

Table1

FieldId FieldName

1 Value1

2 Value2

3 ...

ALTER TABLE [dbo].[table1] WITH CHECK ADD FOREIGN KEY([fieldid])

REFERENCES [dbo].[table2] ([fieldi_id])

ON DELETE CASCADE

You can modify the sql such that it gets parameter with semicon

select * from <table> where stageId in (<your parameter>)

Or

Write the sql with the parameter and assign it to the...

The above code returns(Dispalys) string "Red" or "Green".

I want the fore color of Field to changed to Red/ Green based on its value

Thanks for your reply. Actually i want to set the forecolor based on some condition.

Eg :

If Value of Field!txtfld.Value<5 then Green Else Red

How to do this