This is a general question on SQL performance. I have a stored procedure that is roughly 1200 lines. The procedure is comprised of
A main query that extracts data and inserts it into a temporary...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23108307.html
Hi All,
Like all "computer guys" I have been asked this a hundred times and I don't know a good answer. A co-worker is helping a friend get a buinsess established. They would like to sell on-l...
http://www.experts-exchange.com/Web_Development/Internet_Marketing/E-Commerce/Q_23370339.h...
Zones:
E-CommerceDate Answered: 05/02/2008 Grade: A Views: 0
Hi All,
I have more than one textarea in my form. while submititng the form i want to store line break <br> of textarea into the database...And when i retrieve the data from database i want to dis...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_21555800.htm...
Zones:
ASPDate Answered: 09/12/2005 Grade: A Views: 0
I need help with this code:
I have a email message in an @array. I would like to search for the Subject: line and then store the subject line and the line below the subject line into 1 variable...
http://www.experts-exchange.com/Programming/Misc/Q_21733038.html
Zones:
ProgrammingDate Answered: 02/12/2006 Grade: A Views: 0
Hi
I have an insert form where the users can store several paragraphs of text. when this data is stored in the database the paragraph information is lost but i need to keep it.
How do you han...
http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/Q_21788177.html
I want to write a stored procedure in oracle that takes in parametere and returns a recordset part by part for paging purposes. I found lot of stored procedures but mainly in SQL Server nothing in...
http://www.experts-exchange.com/Database/Oracle/Q_21246102.html
Zones:
OracleDate Answered: 06/29/2005 Grade: A Views: 0
In below batch : (sqlserver 2000)
create table t (a nvarchar(2))
declare
@a nvarchar(100),
@b nvarchar(100),
@c nvarchar(100)
set @a = 'insert into t values(''aa'')'
set @b = 'insert into...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22828443.html
