|
|
|
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 INSERT INTO Locksup PROC but OK in Query Analyzer Posted by Erik at 10/24/2004 9:04:26 PM I have SQL Similar to this:
--Put new records in Table3
Truncate Table Table3
Insert into table3
select * from STAGING where key1 not in (select distinct key1 from LIVE)
It works fine in SQL Analyzer, but when I create a stored procedure with the
same Sql code in it, its related process h...more >>
ntext column Posted by barbaranesbitt NO[at]SPAM bellsouth.net at 10/24/2004 6:23:07 PM I need to replace some characters on an ntext column. However, the REPLACE
function won't work with the ntext column type. I know that I can cast to a
varchar(8000) and then call the function but I might truncate the data that
way. Is there a way that I can safely do this?
Thanks
...more >>
Creating Views Posted by Views in SQL Server at 10/24/2004 5:25:02 PM Hi,
Lots of people are saying that using views slow down the performance. Is
this true ? If so, how and why ?
Thanks......more >>
conflict of primary keys Posted by Frank Dulk at 10/24/2004 3:07:07 PM I need to do an update in a field Code that this present in dozens of
tables. I need to change the old value and to place a new one, the problem
it is that this field is key in many tables and it happens conflict of
primary keys.
Does have some form of altering those fields without has to elim...more >>
TIMEOUT Posted by Frank Dulk at 10/24/2004 3:04:59 PM I configured the connection to await a limitless time (0) and I don't have
more the problem of the message " TIMEOUT EXPIRED ", however it is sometimes
instantaneous and sometimes group almost 1 minute.
This only to open the connection through ADO.
is resembling a problem in the net. gives ...more >>
SQL server 2005 Posted by Bonj at 10/24/2004 1:15:22 PM 1) Can you install SQL 2005 beta express over the top (aswell as) MSDE 2000?
Is it advisable?
2) Any good links for writing "managed extended stored procedures " or the
like?
...more >>
SQL Query help help Posted by TonyR at 10/24/2004 12:42:26 PM In a contact management system that hase a contact table, and a history
table (1tomany off the contact table).
Each Contact has many history records , each one with a date field of when
that event took place. I need to retrieve a list of names and the date
when that contact was last co...more >>
Uploading the file Posted by msnews.microsoft.com at 10/24/2004 12:21:17 PM Hi
I want to write a program that archives the files. How can I write a SP =
that uploads files to the database.=20
Thanks.=20
Amin...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Format SQL Select output question Posted by Jims at 10/24/2004 11:59:17 AM I'm looking for a way or trick to format the results of a sql statement.
Specifically I want the select output to be in a format I can use in an ldif
file. How can I insert some constant string and/or blank row between each
result?
Thank you,
Jim
Please see below examples:
Currently
sel...more >>
How to determine the max value of a SQL Datatype Posted by Daniel Walzenbach at 10/24/2004 2:10:55 AM Hi,
how can I do this?
select SearchedFunction('smallint') as [Result]
Result
-------------------
32767
Thank you!
Daniel
...more >>
SQL Server Birth Date! Posted by Leila at 10/24/2004 12:24:35 AM Hi,
I know this is not a question related to programming or anything else...But
I didn't know any better place to post this question!
When is SQL Server birth date?
Thanks,
Leila
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |