Normal
0
false
false
false
EN-AU
X-NONE
X-NONE
MicrosoftInternetExplorer4
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:”Table Normal”;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:””;
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin-top:0cm;
mso-para-margin-right:0cm;
mso-para-margin-bottom:10.0pt;
mso-para-margin-left:0cm;
line-height:115%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:”Calibri”,”sans-serif”;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:”Times New Roman”;
mso-bidi-theme-font:minor-bidi;
mso-fareast-language:EN-US;}
host of different types of operation with SQL and it’s incredibly powerful.
makes a binding file for you, it will make the schemas, but the binding file
contains that extra little bit of magic
TableOp/Update/dbo/Employee
update employee record(s) in the employee table.
Then there is of course stored procedures for both send and receive ports.
TypedProcedure/dbo/StoredProcedureName
want to do, you want to go for a more composite operation.
example, insert into a table, and when done, run a stored procedure.
procedure schema, that the wizard generates, now bundle this into the following
structure and all of a sudden a whole world of opportunities opens up.
ref=“ns0:Insert“ />
ref=“ns1:CompareEmployee“ />
name=“RequestResponse“>
ref=“ns0:InsertResponse“ />
ref=“ns1:CompareEmployeeResponse“/>
</xs:element>
for example a SQL reader, that can execute SQL against the database and return
the results of the query
xmlns=“http://schemas.microsoft.com/Sql/2008/05/GenericTableOp/“>
STATEMENT1];[PL/SQL STATEMENT2];</Query>
Operation
|
Soap Action
Header |
ExecuteNonQuery
Request |
GenericOp/ExecuteNonQuery
|
ExecuteNonQuery
Response |
GenericOp/ExecuteNonQuery/response
|
ExecuteReader
Request |
GenericOp/ExecuteReader
|
ExecuteReader
Response |
GenericOp/ExecuteReader/response
|
ExecuteScalar
Request |
GenericOp/ExecuteScalar
|
ExecuteScalar
Response |
GenericOp/ExecuteScalar/response
|
Refer to this link for more: http://msdn.microsoft.com/en-us/library/dd788372%28v=bts.10%29.aspx