Solved

Is it possible to use the SET command in a table-value function?

Posted on 2011-02-28
2
305 Views
Last Modified: 2012-05-11
I want to use the following commands in a table-value function.  Is this possible?  If so, Where do I place the commands?

            SET ARITHABORT OFF
            SET ARITHIGNORE ON
            SET ANSI_WARNINGS OFF
0
Comment
Question by:mburk1968
2 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 150 total points
ID: 34997058
no, those are not possible inside the function.
you can set them just before you creation the function, so the function shall apply those settings when it runs.
0
 

Author Closing Comment

by:mburk1968
ID: 35000440
Thank You.  I understand the solution.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Testing connection to sql 7 63
Sql Permission 6 67
CONVERT date time to a different time zone. 2 63
Move SQL 2005 Express to Server 2012R2 19 144
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question