Re: sql functions

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Aaron Bertrand - MVP (aaron_at_TRASHaspfaq.com)
Date: 05/18/04 

Date: Tue, 18 May 2004 11:29:14 -0400

> i can cut the function code from books on-line and it stil fails.

What does "fails" mean? Does that mean "doesn't work" or "broken"? If it
"doesn't work" then you have a syntax error on line 5. If it's "broken"
then you forgot to include a GO command.

In all seriousness, if you want a decent shot at getting an answer, you
should include the definition of fails. Do you get an error message? If
so, what is it? What does the code of your function look like? What
version and SP level of SQL Server are you on? What is the database
compatibility and collation of the db you are trying to create the function
in? What database is it? What user are you acting as, and what roles do
they belong to?

Saying something "fails" is like telling the doctor you're not feeling good,
and expecting an accurate prescription with no further details. You might
get cough medicine for constipation, or penicillin for a nosebleed. BE
SPECIFIC! Your post can never be too detailed. We get pretty good at
skimming for substance. 

-- 
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/

Relevant Pages

  • Re: About MS-Access RDBMS
    ... ie you shouldn't be able to say 'fails rule 2 because it ... > database not by applications' own exception processing features. ... > 8) Physical independence rule: ... > data manipulation, integrity rules, authorisation etc. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: About MS-Access RDBMS
    ... Since Access fails rule 1, ... database not by applications' own exception processing features. ... Physical independence rule: applications and interactive operations ... Access can define unique key and foreign key integrity rules, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: CeDeleteRecord Anomalies
    ... > I am trying to use the CeDeleteRecord function on CE4.2. ... > this function fails (repeatable depending on the database I'm using). ... Does your database contain Text as well? ...
    (microsoft.public.windowsce.embedded.vc)
  • Re: Unable to select records correctly in a Continuous Form
    ... if it fails even when HasModule is No, ... > Well, I've removed the code and compacted/repaired the database, have ... > Even without any code behind the form, the continuous form is still not ...
    (microsoft.public.access.forms)
  • Re: [Info-ingres] Replicator and E_US0845
    ... > Having added the replicator catalogs and support objects to a database ... > An attempt to modify or optimize an archive table fails with: ... > Note that I am connecting as the owner of this table. ... > While its probably not a good idea to modify or optimize these tables, ...
    (comp.databases.ingres)