Showing posts with label msql. Show all posts
Showing posts with label msql. Show all posts

Friday, March 23, 2012

MSQL Update

Hi
Can anyone help me with the MSSQL following problem:
I want to update the field "Date" with today´s date in a Tabel named Customers
I want to click on a "button" that runs something like:

Update Date with Today´s date where CustomerName = TextBox.text

Thanks in advance for your helpstring strSQL = "UPDATE [Customers] SET [Date] = GetDate() WHERE CustomerName = " + TextBox.Text

basic, basic, basic

MSQL Server Version with service pack

I just installed sp3 from micrsofot. how I would know that which service pack I have installed on MSSQL 2000.
thanks for help in advance.
KMType SELECT @.@.Version in the query analyzer and it will tell you all the version info on your SQL Server.|||Or you may go to Enterprise Manager and Right Click on the Server--Properties and under the Gereral Tab it gives you the SP information.

SQL 2000----No SP--8.00.194
SQL 2000------SP1--8.00.384
SQL 2000------SP2--8.00.534
SQL 2000------SP3--8.00.760|||I must say I had a devil of a time connecting to remote sites with ent manager. Until I finally installed sp3 - now I connect up with ease. must of been some bug in the software (winXP) sql server2k that the sp3 fixes.

MSQL 6.5+7+2000>one server ?

Hi,
I need to run MSQL 6.5, 7 and 2000 on single Windows 2000 server.
Is it even possible?
Thanks, SimsasHello Simsas,

as far as I know this constallation is not possible, because the services installed by these different version doe have the same name.

Perhaps some of the experts in this forum know a way to realise it!

Greetings,
Carsten|||Yes you can have but for 6.5 or 7.0 you can only use one server instance, you need to switch between versions. And for SQL 2K only one default instance and variety of named instances.|||you won't be able to run the 6.5 along with the 7.0 as only one of them can be active at a time, I can't remember if 6.5 and 2000 can run at the same time

Is there any particular reason why you have to run all three versions at the same time on the same server? You should be able to run your 6.5 databases on 7 or 2000 in 6.5 compatability mode with little or no modification (depending on the app that's using it of course)|||thanx , i'll try