No announcements
Found 257968 threads
-
0 VotesExecute function from query
way would be to call it from a SQL query? But I'm not having much luck doing that. How do I execute this function from a query? qeqwAnswered | 4 Replies | 1051 Views | Created by rqwew - Tuesday, August 6, 2013 7:07 PM | Last reply by rqwew - Tuesday, August 6, 2013 7:39 PM
-
3 Votes
"EXECUTE" Function Problem!!
out. If you are using sql server 2005, post the definition of the function and the TSQL statement that you are using to execute it. I might be able to find the problemAnswered | 14 Replies | 11260 Views | Created by debuging - Thursday, December 27, 2007 5:09 AM | Last reply by Jacob Sebastian - Sunday, January 6, 2008 4:42 PM -
3 Votes
execute a function
You can't test a function with EXEC. Here is an example of how you can test a functionAnswered | 6 Replies | 3559 Views | Created by Shaikh Sadaf - Monday, January 18, 2010 12:00 PM | Last reply by Abdshall - Monday, January 18, 2010 3:14 PM -
1 Votes
"IF Function"= Execute function if value is true
Hello, I need to make an IF statement, which will execute another funtion, if value is true- basically this: IF there's any text in a cell, ...Answered | 2 Replies | 867 Views | Created by Moriannae - Thursday, February 1, 2018 2:17 PM | Last reply by Moriannae - Thursday, February 1, 2018 8:48 PM -
4 Votes
error in execute function : Procedure or function expects parameter , which was not supplied.
this is not how you execute scalar function select ...Answered | 4 Replies | 2832 Views | Created by Banafshe A - Tuesday, September 4, 2012 12:36 PM | Last reply by Olaf Helper - Tuesday, September 4, 2012 12:39 PM -
1 Votes
Execute powershell function within tsql
function new-aduser( . . . ) -New-AdUser -name '''+@username+''' and etc...' SELECT @sql This will return the following command: powershell.exe -commandAnswered | 4 Replies | 44290 Views | Created by Execute self created powershell function tsql - Wednesday, August 15, 2012 6:12 PM | Last reply by Execute self created powershell function tsql - Thursday, August 16, 2012 8:32 PM -
0 Votes
Button to execute c# function
to the function you want to call. Button button = new Button(); button.Click += new EventHandler(myFunction);Answered | 9 Replies | 7884 Views | Created by RegX - Thursday, January 31, 2008 2:18 PM | Last reply by RegX - Monday, February 4, 2008 5:45 PM -
1 Votes
How to execute a function with passing select * from table as a parameter.
Hi All, I have a function , lets say named TEST i can execute this function by saying Select * from dbo.Test('abc'). My question here is instead of ...Answered | 1 Replies | 528 Views | Created by siddu_123 - Monday, October 19, 2015 1:22 AM | Last reply by Naomi N - Monday, October 19, 2015 1:32 AM -
1 Votes
Execute a DLL function
Good Day i m trying to configure my SQL DB to call a COM+ DLL written in VB. First i tested this using visual studio and this is the source code used in VB.net to ...Answered | 1 Replies | 5636 Views | Created by TONCAL - Tuesday, October 12, 2010 1:01 PM | Last reply by Erland Sommarskog - Tuesday, October 12, 2010 6:52 PM -
0 Votes
OpenQuery executed by EXECUTE in a function
I want execute a statement on remote server by using linked server. This statement returns zero or one or more records. I want to run this statement by using OPENQUERY to gain performance ...Answered | 2 Replies | 5547 Views | Created by MeetP - Monday, April 19, 2010 10:02 PM | Last reply by Muhammad Abbas - Tuesday, April 20, 2010 7:46 AM -
0 Votes
SQL server error message to Parameter and execute the function
/sql-internals-useful-parameters-for-xp_readerrorlog/ after you know how readerrorlog work, insert result in a temporary table and loop on it to execute your ...Answered | 8 Replies | 484 Views | Created by Aadhira - Tuesday, March 1, 2016 11:31 AM | Last reply by remi.smeeckaert - Tuesday, March 1, 2016 12:18 PM -
0 Votes
Want to execute a jquery function
We've a scenario where we require to execute some JQuery function on creation of list items. Here we want to move some items from one list to another based on some ...Answered | 3 Replies | 848 Views | Created by Akram Tamboli - Tuesday, October 20, 2015 4:15 AM | Last reply by sadomovalex - Monday, November 2, 2015 1:17 PM -
0 Votes
Execute JavaScript function when SharePoint List item is added
Hi, I want to execute a JavaScript function by passing ID as parameter when new item is added to SharePoint List. please let me know ...Answered | 4 Replies | 3987 Views | Created by Baindla - Thursday, June 28, 2012 4:04 PM | Last reply by Baindla - Thursday, July 5, 2012 6:34 AM -
0 Votes
execute query in function from table
U cannot use dynamic sql in a function... Create a stored procedure and call that procedure in the place whereever u want... see this example.. create table ...Answered | 2 Replies | 6385 Views | Created by sh.mekawy - Thursday, February 11, 2010 6:23 AM | Last reply by ramireddy - Thursday, February 11, 2010 6:51 AM -
0 Votes
How to execute user define function
This is my function below when i create in my Test database then it is created properly but when i try to execute it from select statement then it is throwing ...Answered | 3 Replies | 521 Views | Created by Sudip_inn - Sunday, April 12, 2020 8:58 AM | Last reply by SQLZealots - Sunday, April 12, 2020 9:26 AM -
0 Votes
How to execute a Function from Powershell V2.
Hi, I have created a function in the Powershell script having file name remotedesktop.ps1 function ...Answered | 5 Replies | 8436 Views | Created by Jaspreet Singh New - Tuesday, November 23, 2010 9:10 AM | Last reply by Jaspreet Singh New - Wednesday, November 24, 2010 5:40 AM -
2 Votes
Use while in a stored procedure to execute a function
A while loop can be used like below : If your table values function is ufnGet() and a stored procedure ...Answered | 9 Replies | 11206 Views | Created by PLiachasPaschalis - Friday, May 13, 2011 4:46 PM | Last reply by PLiachasPaschalis - Saturday, May 14, 2011 3:45 PM -
13 Votes
Execute function one time in every 10 mins in windows powershell
This script will simply wait 10 seconds in between executing the command. which would in practice be (Time to Execute the command) + 10 seconds. If executing the command every 10 seconds on ...Answered | 6 Replies | 78001 Views | Created by Tushart - Thursday, December 2, 2010 12:20 PM | Last reply by GodEmperorZero - Tuesday, April 11, 2017 8:12 PM -
0 Votes
Application Role in one database can execute function in another database on same server
application role. I was not able to grant security to an application role to execute functions or select tables on the other database. I've read chaining databases will work, but ...Answered | 1 Replies | 497 Views | Created by Fiodir - Monday, April 25, 2016 10:31 PM | Last reply by bhanu_nz - Monday, April 25, 2016 11:20 PM -
2 Votes
Can we execute a powershell function using file name.
users>. .\remote.ps1 ps:>c:>users>findAnswered | 4 Replies | 6032 Views | Created by Jaspreet Singh New - Wednesday, November 24, 2010 12:26 PM | Last reply by Jason Hofferle - Wednesday, November 24, 2010 5:44 PM - Items 1 to 20 of 257968 Next ›
No announcements
