without looking it up (assuming you actually have a copy of the SQL Standard), is the following valid SQL?
select 1, * from mytable
hint: no, it isn't
:-)
r937.com | rudy.ca
i've done the keyword search in this forum, and i've gone all through BOL...
i have a DTS package that i created with the wizard (i hate that stupid wizard), which copies 15 tables from my production database to my test database
this is an elaborate, painstaking procedure (i hate that stupid...
long story short, i can see the following tables:
MSysAccessObjects
MSysAccessXML
MSysACEs
MSysObjects
MSysQueries
MSysRelationships
they got unhidden by me as instructed by some access modules i was trying out
i want to print the tables/columns in a database (i'm still looking, too...
question for the DBAs (among whom i cannot count myself):
what's the best strategy for refreshing summary tables in a sql server database?
the summary tables will be reloaded in toto, i.e. all rows removed (doesn't matter how) and a new set of rows inserted, using, for example, INSERT INTO or...
anybody have a recommendation where i can get a licensed copy of access 97? anybody know approx how much i should be paying if i do find someone selling?
rudy
http://rudy.ca/
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.