Novice question about SQL Server
-
Hi, I am trying to expand my knowledge of SQL. I am very familiar with ACCESS and the SQL language associated with all the query types in that program (okay except parameter queries and pass-through queries) and am curious about SQL server. I am just trying to understand what it is, (Like is it a language or a program). I know these questions are probably embarrassing, but ...
The quest was started when I tried to find a simple solution to transposing data in ACCESS without using VBA. Can it be done and is SQL Server the right direction? Thanks for your help
-
I made a mistake and need to clarify my question. I understand the parameter query, not what data definition or pass through queries really do how to write them. My original quest was to transpose a table and automatically generate field names from the values in the first column of the 'old table'. Those names change all the time, so I was trying to automate it.
-
SQL Server is a server database that uses a client server model. This means that a client - your typical end user - submits a query, the server processes the query and returns the result. Contrast this with Access where...generally speaking!...all the work is done on the client. Transact SQL is the language you use to retrieve/modify data and objects in SQL Server.
In Access you can use a DDL query to create a object using SQL rather than the Access designer. Pass through queries are written in TSQL rather than Access SQL and are processed on the server and the results returned to Access, a way to let the server do the work rather than the client.
For what you're trying to accomplish your best bet is to just write some code. Fairly easy done in Access in a code module. You might luck out and find the answer here, probably a greater chance of a good answer and/or code on an Access specific site.
Andy
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply