• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 347
  • Last Modified:

SQL 2000 - Can I call a function from within a view?

MS SQL 2000

I am creating a view, and I need to use a function within the select query. Is this possible? I am getting syntax errors...
0
novice12
Asked:
novice12
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>I am creating a view, and I need to use a function within the select query. Is this possible? I am getting syntax errors...
yes.


create view xy
as
select * from dbo.yourfunction()
0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now