Search results for query: *

If UPDATE(Column) ex. Create Table Calls ( CallID int, CallNumber varchar(20), CallText varchar(100) ) If UPDATE(CallText) SQL Online Books ---------------- See under triggers ( creating/modifying ) IF UPDATE (column) Tests for an INSERT or UPDATE action to a specified column and is...

Remember if the column has been updated with the same value, Update() will return true. Before Update Tbl1.Col1 = 45 Tbl1.Col2 = 'Test' Tbl1.Col3 = 'Jubii...' ex 1. Update Tbl1 Set Col2 = 'Test', Col3 = 'Hi' Where Col1 = 45 Update(Col2) = true Update(Col3) = true ex 2. Update Tbl1...

Cast the value as float to get a result in float Here: select ( cast( value as float) / 100 + value) as newvalue from mytable Bobby

Hi GoBrowns, Sorry For not responding a bit earlier as I had my hands filled a copule of assignment, which had to be out of the door. I didn't find out why it sometimes didn't work. But is has been months it last occured. It happens once in a blue moon. It would be quite helpful for me to...

Hi there, I use Asp.Net Application to upload a Excel file and then a DTS to import data from the file to the SQL2000 and finally to display the read data on the screen. The DTS starts with setting some variables with the help of Dynamic properties. On Succes. DTS rum 2 simultaneous Transform...

select emp-id, dbo.YourFunction() from budget-detail.

use dynmaic properties to set the path

insert into op_apps_daily.dbo.chktype select * from norway.dbo.chktype where norway.dbo.chktype.code not in (op_apps_daily.dbo.chktype)

Hi Dave, REPLACE EXEC @hr = sp_OASetProperty @oPKG, 'ImportFilename', @Filename WITH EXEC @hr = sp_OASetProperty @oPKG, GlobalVariables("ImportFilename").Value, @Filename Let me know how it turned out /b

Hi there, you nee to use sp_OASetProperty to set the global vraiables, before you call the excute method EXEC @hr = sp_OASetProperty @oPKG, <Global variable name>, <value> ex. EXEC @hr = sp_OASetProperty @oPKG, 'Filename', '\\svrname\c\inetpub\wwwroot\usadev\imports\credit1.txt' /b