|
|
|
January 2003 March 2003 April 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 April 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Temporary Table vs Table Data Type Posted by Krist Lioe at 8/10/2003 10:54:34 PM Hi SQL Gurus,
Is there any condition in a stored procedure where I should use
Temporary Table or Table Data type to store Query result??
This query result is to be used by the subsequent Queries
How do you compare their apropriate usage ?
Thanks in advance,
Krist
*** Sent via D...more >>
using ip addresses in windows scripting host Posted by ldsweet at 8/10/2003 9:32:45 PM
Does anyone know how to use ip addresses in wsh? I have used an url
statement such as //server/share. Is there a way to change this to:
for examle : //100.100.100.10?
Thanks
Larry
--
Posted via http://dbforums.com...more >>
Stored Proc Input Paramater type Posted by Kerri at 8/10/2003 8:54:51 PM I have a stored Proc that takes 2 paramaters.
One is an int and the other is a varchar(50)
Why can I not exlictity say.
@Param1 int(4),
@Param2 varchar(50)
It does not likke the int(4) and only takes below
@Param1 int,
@Param2 varchar(50)
Any ideas?
K...more >>
Calling stored procedures from ASP Posted by joe_engineer2003 NO[at]SPAM yahoo.ca at 8/10/2003 7:47:24 PM Hi all,
How many possibilities to call a stored procedure from an ASP page are
there? I know the stored procedure which is called to generate a
report, but I can not find it anywhere in the ASP (VBScript &
JavaScript) code. Can anybody suggest me how to search for it?
Thanks,
Joe...more >>
Execute ('tsql statement') isn't returning @@error Posted by Karen Grube at 8/10/2003 6:09:26 PM Hi!
I have an update sql statement that I am building
dynamically within a stored procedure. At one point, I
execute the statement like:
declare @Variable smalldatetime
declare @error int
select @Variable = '01/02/2002'
Select SQLStatement = 'Update Mytable set Mydate = ' +
@Varia...more >>
How to check if a table already exists Posted by Abhishek Srivastava at 8/10/2003 5:51:30 PM Hello All,
Is there any system stored procedure which can tell if a table already
exists in the db?
I know how to do this by a query ... but that makes code unreadable.
regards,
Abhishek.
...more >>
Dynamic like clause Posted by Jonathan Blitz at 8/10/2003 2:47:48 PM I am trying to set up a "dynamic" like clause where the contents of the
entry data will be from a table.
For example, I have a table with a Phone Number column. I want to compare it
to another column which should match but doesn't have to be an exact match.
So, for example, if the first colu...more >>
loop in stored procedure Posted by Marcin at 8/10/2003 1:28:24 PM I've got stored procedure (sp_SendMail) to send email which accepts 3
parameters: email address, subject and body text. Here is SELECT statement
that returns all records for which I should send emails:
SELECT user_address, subject, body_txt FROM MailsToSend WHERE (....)
What is the simplest/q...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
syntax to dynamically create field names in an Update Query Posted by Ron Weiner at 8/10/2003 1:07:43 PM I need to update a tempory table where the field names are Temp1, Temp2,
Temp3,....
From an Access app I coded some VBA that uses a Sql Statement created
dynamically that updates any Row, Column in the table. The sql statement is
in a loop that moves through a RecordSet (rs) updating Row, Col...more >>
String replacement Posted by Jonathan Blitz at 8/10/2003 12:58:59 PM Is there an SQL function that will replace all occurences of a certain
letter within string with another character?
Jonathan Blitz
AnyKey Limited
Israel
...more >>
String functions for text fields Posted by Bob Brainin at 8/10/2003 12:16:59 PM I am trying to relate two tables using the first, say, 50 characters of
their respective history fields. The reason is that Table2.History has a
truncated version of Table1.History and I need to replace the one with the
other. The problem is that Table1 does not have a unique ID on which to
rel...more >>
trigger on insert output to applet Posted by Jeff at 8/10/2003 12:00:31 PM I am trying to write a trigger that will fire after
insert and output the data from the newly inserted row to
be used to update a remote applet. Does anyone know of
any examples out there how this could be done or maybe
point me in the right direction on where to look?
TIA...more >>
index Posted by christoph at 8/10/2003 11:25:24 AM
Hi!
New challange!
Table Persons:
id(int)...PK
Name(varchar)
Job(varchar)
Hobby(varchar)
Table Combination:
id(int)...PK
Job(varchar)
Hobby(varchar)
Advise(varchar)
Weird example, but it shows all I need. Job and Hobby are
a unique pair in table Combination but not in table
P...more >>
how to get Recordcount in stored procedures ? Posted by peters at 8/10/2003 9:41:05 AM Hi,Everybody!
I wrote a statement :Select Recommender from userinfo where recommender
= 'username' ,I want to know how many lines it would Return ? just like
rs.Recordcount in ADO , Anyone knows ? Thanks !
...more >>
Case Else ... don't mess up my other fields Posted by Fox at 8/10/2003 6:14:33 AM Hi,
Can someone tell me if there is a shorthand way
to stop an UPDATE w/CASE statement
from voiding the other data in the column ?
I know I am supposed to use ELSE, but how
do I cover all the other data without naming it all ?
Just a newbie
Thanks,
Fox
...more >>
Anybody use proc # with CREATE PROC? Posted by nospam_mytrash9 NO[at]SPAM bellsouth.net at 8/10/2003 5:47:59 AM Does anyone use the [ ; number ] option when creating a procedure (CREATE PROC [ EDURE ] procedure_name [ ; number ] )?
The only way this seems to be usefull is for being able to drop several procedures with just one command. I tried this script:
CREATE PROCEDURE Test;1 AS
PRINT '1'
GO
...more >>
What could cause this wrapping ? Posted by Fox at 8/10/2003 4:43:42 AM Is there anything invisible that could cause data from the
same column to behave differently. When I loop through
this column something is causing some of the surrounding
HTML code to wrap to the next line. I am using ASP
to get the data, but the problem has to be in the data
itself since the A...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |