Search Results

Thread by: Sheetal, Oct 27, 2007, 3 replies, in forum: SQL Server 2005 General Developer Questions

Hi Sir, I want to call one linked server stored procedure from another stored procedure. --BATCH FOR LINKED SERVER SETUP SET @IBatchNum = 2 EXEC...

Thread by: Sheetal, Oct 26, 2007, 1 replies, in forum: SQL Server 2005 Integration Services

Hi, 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)) 2....

Thanks Sir, 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? Sheetal

Thread by: Sheetal, Oct 23, 2007, 3 replies, in forum: SQL Server 2005 General Developer Questions

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...

Thread by: Sheetal, Oct 15, 2007, 4 replies, in forum: SQL Server 2005 Integration Services

Hi Sir, 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...

Thread by: Sheetal, Oct 12, 2007, 13 replies, in forum: SQL Server 2005 General Developer Questions

Hi, The below query doesn't work for me. [:'(] DECLARE @int INT SET @int = 4WHILE (@int)<10BEGIN SELECT TOP @int * FROM Pubs..salesSET @int =...