Tema: Re: HELP SQL
Autorius: N
Data: 2010-01-24 18:41:13
Nu aisku tikejaus biski lengviau isisukti :(

"CGI 600" <nespamink@spamas.lt> wrote in message 
news:hjhsvs$sn5$1@trimpas.omnitel.net...
> EXEC ('SELECT ContactID,
>    FirstName,
>    LastName
>  FROM '+ @LentelePavadinimas + '
>  WHERE LastName = ' + @LastName + '
>  ORDER BY Contact
>      )
>
> N wrote:
>> CREATE PROCEDURE GautiKiekius (@LentelePavadinimas NVARCHAR(50))
>> AS
>> SELECT ContactID,
>>     FirstName,
>>     LastName
>> FROM '{'+@LentelePavadinimas+']'
>> WHERE LastName = @LastName
>> ORDER BY Contact
>>
>> Iskart gaunu klaida FROM negali buti tarp kabuciu ir t.t
>> Gal yra kokia fukncija tokiems dalykams pvz foxpro tikrai zinau kad 
>> stringa
>> gali isreiskti kaip koda selektro.
>>
>>