473,385 Members | 1,356 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

SQLServer

143 100+
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
6 949
QVeen72
1,445 Expert 1GB
Hi,

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

Regards
Veena
Jan 22 '08 #2
squrel
143 100+
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
1,445 Expert 1GB
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
squrel
143 100+
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
Killer42
8,435 Expert 8TB
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
squrel
143 100+
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

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

Similar topics

2
by: Martijn Rutte | last post by:
Hi, On one side, I have a Sybase 12.5 32 bits Server running on AIX 5.1 (maintenance level 3). On the other, I've got W2000 5.00.2195 (SP2) with SQL Server Standard Edition, Product Version...
7
by: Bart Torbert | last post by:
Hello, I am starting to examine using SQLServer instead of Oracle. I went through the SQLServer import utility to copy tables from Oracle into SQLServer. I then checked the size of the...
1
by: mdurliSPAMFILTER | last post by:
Hello, I developed a win32 .exe CGI that connects to a clustered SQLServer to report some data. The software is written with Borland C++Builder. This is the oledb string:...
3
by: Devonish | last post by:
I am planning to convert an existing Access database which has a back end (data tables and relationships only) on a server and a copy of the front end (form, queries, reports) on each of about a...
0
by: how can i insert a image to SQLServer? | last post by:
I want to insert some strings and images which from richTextBox into SQLServer. I could insert it into SQLServer,such as follows: FileStream s=new FileStream...
14
by: Roy Gourgi | last post by:
Hi, I need to store and retrieve information from a database. It looks as though there is a lot more support for SQLServer than there is for Access, correct me if I am wrong. What do I have...
8
by: karahan celikel | last post by:
I realized that when SqlServer mode is used for session management Session_End event is not fired in global.asax. What can I do if I want to do something when a user's session end? Thanks
0
by: UDBDBA | last post by:
Hi: We have a setup which connects a V8.2 32bit db2 instance on AIX to SQLServer 2000 using the unixODBC driver. We have 5 SQLServer "Server mappings" and 4 of them work just fine and can use...
2
by: Jenniflower | last post by:
Hi Gurus, Our system is using SqlServer 2005 on XP.( On my machine,only this application access SQLServer.) The sqlserver memory is configured to 128MB (Min)~512 MB(Max) After our system get...
7
by: Academia | last post by:
I was told that SqlServer express should get installed when VS2008Pro is installed (that is it is on the same DVD). I had a couple of errors during vs2008's installation and I don't see any...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.