'How can I use a SQL Server sp_* stored procedure/function in a if case?

I'd like to check the catalog existence before I create or use it, so there is go.

sp_fulltext_catalog 'testcatelog1', 'create';

if not exists (select 1 from sys.sysfulltextcatalogs where name ='testcatelog1') 
  create fulltext catalog  testcatelog1;

if not exists (select 1 from sys.sysfulltextcatalogs where name ='testcatelog1') 
  sp_fulltext_catalog 'testcatelog1', 'create';
-- It doesn't work. Syntax error near 'sp_fulltext_catalog'.

if exists (select 1 from sys.sysfulltextcatalogs where name ='testcatelog2') 
  sp_fulltext_catalog 'testcatelog2', 'start_full';
-- It doesn't work. Syntax error near 'sp_fulltext_catalog'.

If SQL Server is designed that cann't run build-in function in T-SQL case, how to issuse an useful alternative statement?

sql-server


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions