|
|
|
pomogite pozaluisto
|
|||
|---|---|---|---|
|
#18+
kak hranimoj procedure peredatj kak parametr chastj samoi proceduri? Primer: @p1 varchar(100) as select * from table where @p1 @p1=name like '%olg%' ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 14.09.2001, 15:35 |
|
||
|
pomogite pozaluisto
|
|||
|---|---|---|---|
|
#18+
moshno icpol"zovat" Dynamic SQL , naprimer tak : DECLARE @SQLString varchar(8000) declare @Email varchar(75) = NULL, -- User's email , for exp SELECT @SQLstring = 'SELECT u.a, u.b, u.a ' SELECT @SQLString = @SQLString + ' FROM table1 u' SELECT @SQLString = @SQLString + 'JOIN table2 ua on ua.b = u.b ' SELECT @SQLstring = @SQLString + ' AND a like ''%' + @Email + '%''' PRINT @SQLstring ( ---for testing ) EXEC ( @SQLstring ) ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 14.09.2001, 16:11 |
|
||
|
|
start [/forum/topic.php?fid=46&gotonew=1&tid=1825538]: |
0ms |
get settings: |
9ms |
get forum list: |
20ms |
check forum access: |
4ms |
check topic access: |
4ms |
track hit: |
143ms |
get topic data: |
10ms |
get first new msg: |
6ms |
get forum data: |
3ms |
get page messages: |
40ms |
get tp. blocked users: |
1ms |
| others: | 223ms |
| total: | 463ms |
| 0 / 0 |
