|
|
|
Удаленная процедура MSSQL в запрос на MySQL
|
|||
|---|---|---|---|
|
#18+
Помогите... Была на МССКЛ такая хранимая процедура CREATE PROCEDURE put_realtime @region_ID int , @sec_id int , @ticker VARCHAR(20), @field_id int, @dt datetime , @value_ float , @volume_ int AS DECLARE @ct as int Select @ct = Count ( * ) from stored_fields WHERE region_ID = @region_ID and sec_id = @sec_id and ticker = @ticker and field_id = @field_id and days_keep > 0 if @ct > 0 Begin Insert into realtime_tick ( region_ID , sec_id , ticker , field_id , dt , value_ , volume_ ) Values (@region_ID , @sec_id , @ticker , @field_id , @dt , @value_ , @volume_ ) end sp_help stored_fields select count (*) from realtime_tick delete from realtime_tick Теперь это же надо переписать на внешнийзапрос MySQL. Плиз, хелп! ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 14.07.2005, 14:54 |
|
||
|
|

start [/forum/topic.php?fid=47&msg=33166155&tid=1853850]: |
0ms |
get settings: |
10ms |
get forum list: |
19ms |
check forum access: |
4ms |
check topic access: |
4ms |
track hit: |
177ms |
get topic data: |
11ms |
get forum data: |
2ms |
get page messages: |
37ms |
get tp. blocked users: |
1ms |
| others: | 246ms |
| total: | 511ms |

| 0 / 0 |
