|
|
|
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 Drop temp tables in tempdb Posted by Hassan at 8/16/2003 10:19:50 PM I see some temp tables in tempdb such as
#tablename_________________________X23 as an example when i query
tempdb..sysobjects. I noticed the create date of last month . I tried to do
a select * from that table and it says invalid object. So how come I see it
there ? Also how can i drop it . I am...more >>
do we need to explicity drop temp tables in stored procedures Posted by Hassan at 8/16/2003 9:59:40 PM If a temp table is created within a stored proc, do we need to explicitly
drop it within a stored procedure. I believe that they get dropped
automatically after the stored proc completes.. But am not too sure. Please
let me know the good practises. I am using SQL 2000
Thank you
...more >>
Select no duplicate value in a column Posted by Noor at 8/16/2003 5:25:51 PM Hi All
I need to select from a table where data is duplicated in a column.
I dont want duplicate values so i put a distinct clause but still getting
duplicate columns
because other some of the other fields dont have exact values.
I want only the unique values for a column ! how can do this....more >>
Need a workaround: error when saving stored proceduce Posted by maxhodges NO[at]SPAM hotmail.com at 8/16/2003 3:36:31 PM Hello everyone, I have written a stored procedure which selects from
tables in a linked server (using openquery.) The statement runs fine
from Query Analyzer, but when I past it into a stored procedure, and
the syntax check is fine, but I get this error when I try to Save it:
Error 7405: Heter...more >>
Normalization Help Posted by Andre at 8/16/2003 2:58:56 PM Hello,
I am a newbie at database design and need some help. I
am trying to create an employee database. I need to
track all of their data. I have created to an Employee
table to hold most of the data. Then I have an Address
table because they can have multiple addresses. My first
q...more >>
SQL Question Posted by Dan at 8/16/2003 11:31:25 AM I'm an amateur at SQL statements, so I was wondering if
anybody could help me out. I have a database that has a
Tasks table and its primary key is taskId. The database
also has an Updates table and Updates has its primary key
updateId and a foreign key to Tasks called task.
Basically, o...more >>
performance diff in xp_ and sp_OACreate Posted by jlongino at 8/16/2003 11:12:32 AM Is there any good information out there regarding the performance difference
between writing a function as an extended stored proc vs as a COM object and
using sp_OACreate?
...more >>
COUnting Distinct Rows Posted by Jon Spartan at 8/16/2003 9:44:46 AM
I am attempting to figure out how to count the number os distinct rows
in a table.
I have tablex with columns DATEIN and SESSIONID where SESSIONID can
have multiple entries for the same SESSIONID.
I only want the row count between two dates in DATEIN ( not a problme)
AND not include any...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL - difference between 2 rows?? Posted by chet gwin at 8/16/2003 1:38:10 AM hi! i was having trouble getting a handle on this one...i created a table
to log 'selects' in order to measure capacity of an inquiry-only
system....my problem is i need to subtract one row's datetime from the next
row's datetime in order to get the elapsed time between the two...any help
is gr...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |