SQLServer

[squrel]

Thank u very much for the help but there is only one single syntax wil be there to replace the value of one column in a table to some other value in the sqlserver2000.. . can anyone help me with tht syntax

[QVeen72]

Hi,

Not Clear, what you actually want to do..
Are you Looking for an "Update Query" ...?

Regards
Veena

[squrel]

Hi,

Not Clear, what you actually want to do..
Are you Looking for an "Update Query" ...?

Regards
Veena

i have a table called TxBills and i have created a new column in tht called BillType wit the default value Null.. i want to replace this Null value to D... and need the syntax for tht in sqlserver...

[QVeen72]

i have a table called TxBills and i have created a new column in tht called BillType wit the default value Null.. i want to replace this Null value to D... and need the syntax for tht in sqlserver...

Hi,
Use ADO, Open the Connection and Execute this Query:

[code=oracle]
Update TxBills Set BillType = 'D' Where BillType Is Null
[/code]

Regards
Veena

[squrel]

Hi,
Use ADO, Open the Connection and Execute this Query:

[code=oracle]
Update TxBills Set BillType = 'D' Where BillType Is Null
[/code]

Regards
Veena

Thank you very much.... Got It

[Killer42]

Just a point I'd like to mention, squrel. We're happy to help out when we can, of course. But for questions specifically relating to SQL Server, you'd probably be better advised to post in the SQL Server forum, to improve your chances of getting the answers you need.

[squrel]

Just a point I'd like to mention, squrel. We're happy to help out when we can, of course. But for questions specifically relating to SQL Server, you'd probably be better advised to post in the SQL Server forum, to improve your chances of getting the answers you need.

Ok... Thank u very much for your point... Ofcourse it wil be better