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")...

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'...

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.

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 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...

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

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.

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...

Hello PHP users, In my script I am using the next script: include_once('a.php'); The functions in a.php can't be called because 'a.php' is located in an other directory. I tried: include_once('../pages/a.php'); include_once('..//pages//a.php'); include_once('..\pages\a.php')...

Hello all, Because we want to know how long a visitor was on our site we need an event for closing / leaving our site. What are the possibillities to get this information? Regards, solo1234.

Hello vb dotnet users, Via a class we can create pictureboxes and an event. Interesting is to know in the event what is the name or position of the object what caused the event. Used code: Public Class PlaatsPictureBox Private Shared ipb_count As Integer = 0 Public Shared Sub...

Dear vb dotnet users, Via a class we can make a button but how can be an event inserted? Hope you can help us. Michelle. Used code: Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load create_button.setButton(Me) End Sub...

Hello everybody, We are trying to get a picturebox on a form via a class. The reason is that we need sometimes more then one time the same picture on the form. The mouse pointer must give the picture the right place. Can someone tell us how to make the syntax because the next doesn't work...