SQL Help

Results 1 to 2 of 2

Thread: SQL Help

  1. #1
    Join Date
    Dec 1969

    Default SQL Help

    I am using SQL Server.<BR><BR>I have table with column name like t1,t2,t3,t4,t5<BR><BR>suppose i want to get value by colume wish like<BR><BR>i can execute this in MSAccess<BR><BR>for i = 1 to 5<BR>"select * from t" & i & "=&#039;somethings&#039;"<BR>next<BR><BR>same thing i what to execute in SQL Server any possible to do like that if yes Please tell me............<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL Help

    crappy performace from that. do it all, as one statement by building the string in script FIRST, then execting it.<BR><BR>j

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts