Jun 11, 2008 · You can have the function update a dummy table that has a update trigger with waitfor in it. Wednesday, June 11, 2008 8:31 PM 0 Sign in to vote I got the waitfor to work in a function like …

Mar 12, 2007 · I would like to prepare a query from the arguments of the function and have a return rowset as the result of the prepared query: To simplify the matter the following prepares a simple query

May 29, 2019 · And the Model itself is set to compatibility level = 1200. Why does the one server bomb out when it tries to reconcile USERPRINCIPALNAME () function? Todd C - MCSE SQL Server …

Jun 14, 2019 · I am looking for help on how to return a table of key/value pairs from a CLR function in SQL Server. I have this code. It doesn't work ATM. Still reading posts and watching videos, but they …

Oct 15, 2014 · SQL is a different language than C#, if you need help in SQL, post in a SQL forum. But yeah, escaping SQL is like goto, the less people talk or use it the better.

Aug 7, 2013 · There are a few ways to skin this cat, but I would replace the scalar function with a table function that accepts either a comma separated list of arguments or a table valued parameter.

Mar 26, 2014 · Yes it is possible using linked server in SQL Server. You can join the two tables (current DB table and linked server DB table) and finally have a single query used in SSRS dataset.

Feb 19, 2020 · The SQL solution you linked to seems relatively sound, although you might get better performance from a CLR function. The bit that trips most people up is that they think there is only a …

Oct 7, 2021 · Hi, I am workining in vb.net and sql. In DB have a uniqueidentifier field and want to insert in it, When try to send data, some thing parameter: ByVal value as GUID In the query : '"& Value &"' …

May 4, 2011 · For you current problem an function is probably sufficient, just remember the performance is going to be dictated by what you do in your function and how many rows your function is being …