Re: Parameter default value

peregenem@xxxxxxxxxxxx wrote: 
MGFoster wrote:

What I was trying to get at about Access vs. T-SQL queries/stored
procedures (SPs).  When using an .adp file you are actually using the MS
SQL Server (or, the desktop edition MSDE) DB engine.  Your post example
was showing a T-SQL SP (not an Access query) which was using the VBA
function IIf(); this is incorrect in T-SQL.



Please take another at my code. This is not T-SQL, not an .adp file,
not SQL Server, not MSDE. It really is Jet/Access. Honest. Please try
running my VBA code: it creates a Access/Jet database, table, data,
PROC/Query and uses it.


I suggest you read the documentation.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
.

Relevant Pages

  • Re: Update or Delete querys with Joins
    ... This is were I was missing the boat Steve. ... update multiple columns in the ANSI with the same right-side of query. ... that time as Microsoft deems it suitable for inclusion into T-SQL. ... > but SQL Server doesn't implement it. ...
    (microsoft.public.sqlserver.programming)
  • Re: T-SQL Compiled?
    ... the most amount of time in SQL Server batches is the manipulation of data. ... replacement for T-SQL objects. ... > compiled into machine code and are fast. ... > machine code, and for T-SQL, the word "compiled" means that an execution ...
    (microsoft.public.sqlserver.programming)
  • Re: how to match time ranges for multiple records in a query?
    ... No. T-SQL is the variant of SQL that is used in MS ... going to be doing anything with SQL Server. ... BOL will be found in the SQL ...
    (microsoft.public.inetserver.asp.db)
  • Re: Accessing SQL data from an ACCESS app...
    ... When you are referring to writing an Access query that uses a VBA function ... for it's criteria to fill in the parameters (I've never even used SendKeys ... > database to SQL Server, using only ODBC linked tables to SQL server 2000. ...
    (microsoft.public.sqlserver.odbc)
  • Re: 10 most popular
    ... Yes that is correct in T-SQL, I missed the first line of your reply and ... SQL Server MVP ... Columnist, SQL Server Professional ... there are less than 10 distinct ItemIDs then it will return the same number ...
    (microsoft.public.vb.database.ado)