script for submiting form to the specifix url.. write SubmitForm.js as follows:
//to call any web service without
passing data and get all form data in web service.. Added By Vimal Vataliya
$.fn.SubmitForm = function
(url, callback) {
var form = $(this);
if (document.getElementById("test_if"))
{ }//check if this id is already exist
else {
var ifram = document.createElement("iframe");//create
iframe to store json result
ifram.id...
Wednesday, May 13, 2015
Friday, May 1, 2015
call store procedure from function in sql server
By Vimal Vataliya
2:41 AM
call sp from function,
function,
sql server,
store procedure
Leave a Comment
Function dbo.yourFunctionName
(
yourPara
)
RETURN TABLE
AS
RETURN
(
SELECT * FROM OPENROWSET('SQLNCLI','Server=yourServerName;UID=yourUserName;Pwd=yourPassword;','SET FMTONLY OFF; EXEC yourDataBase.dbo.yourSpName @yourPara') as C...