I have a simple select query working inside a sproc (below) that I need to enhance with 2 additional features. 1) Add a column filled with a random number then 'Order By' that column so the questio...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20077591.html
I am trying to Execute Stored Procedure. What is the equalant to .NET DateTime.Now in SPROC?
Here is what I got:
SELECT * FROM dbo.MyTable
WHERE DateTime.NOW BETWEEN StartTime AND EndTime
Date...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23654506.html
I have a table which, among other things, contains as a field the names of stored procedures. I would like to, in another stored procedure, get the name of a stored procedure from my table and exec...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_11280917.html
Hi, here's my question.
Say you have sproc A that is a simple "select * from Customers". I want to write a sproc B that will run Sproc A (like Exec A), capture the data, massage the data, and t...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20141935.html
I would like to know whether we can set the parameter in Sproc to be an optional. The values that passed from VB or Access to the sproc can be ignore when this option has been set. Like in Vb or VB...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20293423.html
I would like to search through the text of all of the sprocs in a given database for a certain string. I am using MS SQL 2000. Is there a way to do this? Any tables that this info is stored in? ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20496656.html
How do,
I would like to write a DTS or some sql that will iterate through each proc in the database, find and replace a string, and then save the sproc out again using ALTER.
This is a big jo...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20723797.html
I have a sproc that runs for quite a long time and I would like to know what the current progress is at any given time.
I have place print statements (this sproc will only be called from Query A...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20732194.html
Hello Experts,
This is an Access Project/SQL2K question.
How can I return a recordset from a Stored Procedure?
and on the heels of that question;
Is it faster to use a SQL statement in ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20828496.html
Zones:
MS AccessDate Answered: 12/19/2003 Grade: A Views: 0
Hi,
Easy question for you!
Instead of cutting and pasting the SELECT statement from one sproc into another, I want to reference it to keep everything nice and modularised. I just want to know t...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21036595.html
