Search results for query: *

Dear all, Using sql server 2005. We are busy with a stored procedure. Please look at the code: declare @var varchar(10), @nr varchar(10) set @var='field1' set @nr = (SELECT @var FROM myTable) In the table is only one record. The result of Print @nr: 'field1' Is it possible that the sp is...

Dear all, We are busy with selecting a a table with data type Money and using the next statement: SELECT CASE moneyFld WHEN 0 THEN 0 ELSE Cast(moneyFld as Numeric(10,2)) END AS moneyFld from tbl_x Field values zero are displayed as ".00", can someone tell us how to show a real zero? ("0")...

Thanks for all the usefull information. Michelle.

Dear all, Is there any difference in speed using a temporary table or a normal table in sql server 2000. for example; select * into #temp from any_table When any table has a lot of records, is it faster to use #temp or the any_table. Nice regards, Michelle.

Dear all, We have a string (float value) (komma as decimal sign) and we want this string into a floating field. We tried: insert into DB (floatField) values (CONVERT(DECIMAL('12,1'))) insert into DB (floatField) values (cast('12,1' as double)) insert into DB (floatField) values (cast('12,1'...

Everybody, Thanks for the information! Michelle.

Hello fredericofonseca, We are using VB60, we can call an sql statement for inserting data but an image we don't know how to do. Michelle.

Hello everybody, Configuring fields into a table of sql server 2000 you can to select an image. Can someone tell us how to insert an image into such a field. We can calculate the the binary string of an image. Nice regards, Michelle.

Hello everybody, Thanks for the information. The solution we made is making a scheduled backup with a date in the filename. One hour later a small scheduled task is starting an application thats moves all *.bak to an other server (directory). Nice regards, Michelle.

Hello ptheriault, As I wrote we can reach the sheared directory on the target server from the server where sqlserver is running. We are logging in as administrator We don't understand you're last part. If we are going to the server and open the enterprice manager the sqlserver is local. Via...

Dear user of sql server 2000, We are busy to make a backup to an other server, we did the next things: 1) We made a shared drive on the target drive on the server where the sql server is running, for example: Z:. 2) test via the explorer or the z: drive is writable: is ok. 3) Configuring the...

Hello chrissie1, Thanks a lot!! Michelle.

Hello all, We are busy with a trigger in sql server 2000. The results of a select we want to insert into a table in an other database. Can someone give us script how to do this? In a trigger is it not allowed to use the "Use" command!! Nice regards, Michelle. Example: use xx declare...

I find it out by myself: The changed records are temporary insert into table Inserted! Michelle.

Dear all, How can we find out in a update trigger script which record is updated? For example which record_id? Nice regards, Michelle. script: CREATE trigger dbo.update_indicator on dbo.Products after update as print @@ROWCOUNT

Hi gmmastros, Is there any documentation on internet about this? Michelle.

Hi gmmastros, Thanks for the reaction. We are busy to learn something about the sql server and there will maximal 2 users on the network. We have a network: ip sql server 2000: 192.168.10.100 Clients: 192.168.10.101 / .102 All computers can be pinged and directories can be shared on all...

Hello everybody, We are searching for good documentation or pdf file to create a network with one pc with the sql server installed and a lot of clients who are using this sql server. Hope you can help us. Nice regards, Michelle.

Hello philhege and others, We changed the properties of the local server on pc-A, tab security: Authentication from "Windows only" to "SQL server and windows"! There was access. Today we are going further with installation because there are some other problems. Thanks for the reaction! Michelle.

Dear readers, We have the next situation: Pc-A: Installed XP Ip address 192.168.10.1 Installed sql server 2000 Pc-B: Installed XP Ip address 192.168.10.2 Both computers can be pinged and directories can be shared from pc-A < > B. Installing sql server 2000 on the pc-B, choosing for “remote...