SQL Server Performance Forum – Threads Archive

table extract

folks,
How do i take an extract of a table without extracting one or two columns? your prompt response greatly appreciated. thanks

---

do a select statement listing the columns you do want: SELECT Col1, Col2, Col9
FROM table ‘I reject your reality and substitute my own’ – Adam Savage

---

What do you mean by extracting table?
Do you mean fetching records? Madhivanan Failing to plan is Planning to fail

---

Hi,<br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by matey</i><br /><br />folks, <br />How do i take an extract of a table without extracting one or two columns? your prompt response greatly appreciated. thanks<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />if you are looking what columns you have in your table then<br /><br />sp_help ‘yrdb.dbo.yrtable'<br /><br />select * from information_schema.columns where table_name=’yrtable'<br /><br />Or please ask your question again with exactly what extract you need !?<br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />]<br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami<br />

---

thanks guys i used DTS and it worked fine. cheers

---

Hi,
but still its not clear about the *EXTRACT* ! would you let us know ! Regards Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami

---

]]>