let's assume i have many tables in my database, tables A thru z. is it possible to write a stored procedure that takes a tablename as a parameter? I want to be able to delete data from tables that ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10157130.html
Zones:
MS SQL ServerDate Answered: 06/05/1999 Rating: 6.4 Views: 0
This is the situation:
On SQL Server 6.5 (on a remote machine in the network) is stored a database with tables and stored procedures.
Locally (on my Win 98 machine) I have installed SQL Serve...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10259368.html
Zones:
MS SQL ServerDate Answered: 02/08/2000 Rating: 7.0 Views: 0
How can I read and parse an external tab/comma delimeted file from a stored procedure?
My goal is to parse the text file and either pass the rows to a database or write an exception for that ro...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10332048.html
Zones:
MS SQL ServerDate Answered: 04/26/2000 Rating: 7.8 Views: 0
We use Microsoft Aceess to deal with user daily data and prepare it and use remote Oracle stored process to insert the sale data to Oracle table in the remote Oracle server with version 7.3.2 runni...
http://www.experts-exchange.com/Database/Oracle/Q_11184651.html
Zones:
OracleDate Answered: 09/08/2000 Rating: 4.0 Views: 0
How do i call a stored procedure on another servers database from my servers database. How do i use the remote stored procedure call to do this. Examples would be very helpful.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20110396.html
Zones:
MS SQL ServerDate Answered: 08/01/2003 Rating: 8.8 Views: 0
I'm using MSSQL 7.0. thinking of writing a stored procedure which receive an input as parameter & output the parameter rite after it does some encryption process inside. later, this stored procedur...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20174283.html
Zones:
MS SQL ServerDate Answered: 09/02/2001 Rating: 6.8 Views: 0
hi
i want to order the record dynamically..want to pass the order by string at runtime to the SP.
tried with the code below.. it doesn't work..
select clentname,add1 from client
order by ' +...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20268833.html
Zones:
MS SQL ServerDate Answered: 06/13/2002 Rating: 6.2 Views: 0
Hi,
May i know is there any method we can lock the stored procedure, even for the DBA (system administrator), where just the programmer can view the stored procedure only...
thnx,
sityee
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20310201.html
Zones:
MS SQL ServerDate Answered: 12/30/2002 Rating: 8.0 Views: 26
I'm trying without success to return the results of a SELECT statement from a store procedure. I was told that need to return a Cursor, is it correct? if it is, what is the correct syntax to accom...
http://www.experts-exchange.com/Database/Oracle/Q_20352613.html
Zones:
OracleDate Answered: 09/11/2002 Rating: 7.8 Views: 0
Where can i find examples of stored procedures. I havent been able to download this manual sg245485.pdf
http://www.experts-exchange.com/Database/DB2/Q_20387708.html
Zones:
DB2Date Answered: 08/17/2004 Rating: 7.4 Views: 0
