By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,998 Members | 2,871 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,998 IT Pros & Developers. It's quick & easy.

SQLServer

100+
P: 143
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
Jan 22 '08 #1
Share this Question
Share on Google+
6 Replies


QVeen72
Expert 100+
P: 1,445
Hi,

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

Regards
Veena
Jan 22 '08 #2

100+
P: 143
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...
Jan 22 '08 #3

QVeen72
Expert 100+
P: 1,445
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:

Expand|Select|Wrap|Line Numbers
  1. Update TxBills Set BillType = 'D' Where BillType Is Null
  2.  
Regards
Veena
Jan 22 '08 #4

100+
P: 143
Hi,
Use ADO, Open the Connection and Execute this Query:

Expand|Select|Wrap|Line Numbers
  1. Update TxBills Set BillType = 'D' Where BillType Is Null
  2.  
Regards
Veena

Thank you very much.... Got It
Jan 22 '08 #5

Expert 5K+
P: 8,434
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.
Jan 23 '08 #6

100+
P: 143
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
Jan 23 '08 #7

Post your reply

Sign in to post your reply or Sign up for a free account.