By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,089 Members | 2,432 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,089 IT Pros & Developers. It's quick & easy.

Accessing SQL View with Python

P: n/a
Hi All,

I need to access a Microsoft SQL database View. Is there a way to do
this with Python? I have done a fair share of "googling" and found
nothing on accessing Views, just executing SQL, which I already know
how to do.

I am running Windows XP, Python 2.4.

Thanks a lot!

Mike

Apr 27 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
ky******@gmail.com wrote:
Hi All,

I need to access a Microsoft SQL database View. Is there a way to do
this with Python? I have done a fair share of "googling" and found
nothing on accessing Views, just executing SQL, which I already know
how to do.

I am running Windows XP, Python 2.4.
Absolutely loads of ways. But (unless I'm missing
something here) they all involve executing SQL
which accesses a View (such as: SELECT * FROM v_info).
Have I missed the point of your question?

TJG
Apr 27 '07 #2

P: n/a
On Apr 27, 10:29 am, Tim Golden <m...@timgolden.me.ukwrote:
kyoso...@gmail.com wrote:
Hi All,
I need to access a Microsoft SQL database View. Is there a way to do
this with Python? I have done a fair share of "googling" and found
nothing on accessing Views, just executing SQL, which I already know
how to do.
I am running Windows XP, Python 2.4.

Absolutely loads of ways. But (unless I'm missing
something here) they all involve executing SQL
which accesses a View (such as: SELECT * FROM v_info).
Have I missed the point of your question?

TJG
I figured there was. And yes, I knew you'd need to use SQL to get at
the View. I just re-ran it and discovered that I am quite good at
typos. I corrected the SQL and it seems to be working now.

Thanks for the help.

Mike

Apr 27 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.