I want to call one linked server stored procedure from another stored procedure.
--BATCH FOR LINKED SERVER SETUP
SET @IBatchNum = 2
I have created one Linked server to fetch the data from Oracle server.
I have two tables at Oracle server
1. EMP_Tbl1 (Emp_Cd VARCHAR2(10))
Suppose I have 20 batches in my SP and SP execution fails at batch no 12.
Do all the batches from 1 to 12 will rollback?
Hi Sir, I have a task in hand To extract data from one DB to another (SAME SERVER). For this I have written one SP which use one batch to do this...
I am trying to get xml data from xml file into MS SQL DB.
For this I use following code in SP.
SET @XDoc = ( SELECT * FROM OPENROWSET...
The below query doesn't work for me. [:'(]
DECLARE @int INT
@int = 4WHILE
TOP @int * FROM Pubs..salesSET
Separate names with a comma.