Creating scalar functions in SQL Server

Question

I have come across a situation where functions are very helpful. I can create it using its syntax and then I would use them in select or procedures.

But recently I have found that a function is called automatically when a row is inserted or updated. Also it is accepting two parameters. This user-defined scalar function is neither called in C# through ORM and moreover there is no stored procedure using this function, yet it is being called and as per my assumption, this setting must be in a table itself. It is triggered automatically when a row is updated or inserted.

Can somebody please throw some light on this as I have never encountered it before. An example of it would really be helpful that how it is created and how we can call this function.

It could be a default value on a column of the table you are inserting into. It could also be on a trigger. — Vincent
– Vincent, Commented Apr 27, 2016 at 5:07
Could you please add some reference or example of something similar. It would be very helpful for me. — Sweetie
– Sweetie, Commented Apr 27, 2016 at 5:09
It might be called from the trigger. The below link might be useful. - msdn.microsoft.com/en-IN/library/ms189799.aspx — Manish
– Manish, Commented Apr 27, 2016 at 5:15
CREATE TABLE [dbo].[DEFAULTS_SAMPLE]( [ID] [int] NOT NULL, [GUID] [uniqueidentifier] NOT NULL, [CREATED] [datetime] NOT NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[DEFAULTS_SAMPLE] ADD CONSTRAINT [DF_DEFAULTS_SAMPLE_GUID] DEFAULT (newid()) FOR [GUID] GO ALTER TABLE [dbo].[DEFAULTS_SAMPLE] ADD CONSTRAINT [DF_DEFAULTS_SAMPLE_CREATED] DEFAULT (sysdatetime()) FOR [CREATED] GO — Vincent
– Vincent, Commented Apr 27, 2016 at 5:16
@Vincent: please do not put code samples or sample data into comments - since you cannot format it, it's extremely hard to read it.... Thank you. — marc_s
– marc_s, Commented Apr 27, 2016 at 5:40

Community · Accepted Answer · 2017-05-23 12:23:55Z

2

You can install SQL RedGate Search (it's free) which allows you to search all SQL objects to find where your functions has been used:

http://www.red-gate.com/products/sql-development/sql-search/

Also possible is that you make a trace on that function to see where it has been called from (or at least by who):

How to trace T-SQL function calls

edited May 23, 2017 at 12:23

CommunityBot

11 silver badge

answered Apr 27, 2016 at 7:18

Reboon

5782 gold badges5 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Creating scalar functions in SQL Server

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related