|
|
|
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 Add record to new workbook problem Posted by Todd Huttenstine at 5/2/2004 10:20:20 PM This is a new problem
Dim objConn As ADODB.Connection
Dim szConnect As String
Dim szSQL As String
' Create the connection string.
szConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Employee Database.mdb;" & _
"Extended Properties=Excel 8....more >>
Deleting empty spaces in a string Posted by Razi at 5/2/2004 10:16:05 PM Hi
I have a address string stored in a varchar column data type. Sometime there spacing between two words in a string is greater than a single space. How do I delete the extra spaces in the string. I have a parser which is failing because of the extra spaces
Thanks in advance....more >>
SQL code Database add record Posted by Todd Huttenstine at 5/2/2004 8:54:53 PM Hey guys
I am new to this and want to figure out how to add a line to my database.
It is located on C:\Employee Database.mdb
I have created a sample database called Employee Database.mdb. My table is
called Employee Database. The columns in it are as follow:
ID Employee, Name Employe ID,...more >>
Output from Stored Procedure Posted by Bala at 5/2/2004 5:46:02 PM Hi All
I have a stored procedure that is defined in the following way
*****************************************************************
if exists
(select * from sysobjects where id = object_id('RestoreBAKFile')
drop procedure RestoreBAKFil
g
create procedure dbo.RestoreBAKFile
@i...more >>
Duplicate sql Posted by Lasse Edsvik at 5/2/2004 3:50:24 PM Hello
I have this:
CREATE TABLE #Test (
IP char(15) NOT NULL,
Test char(1) NOT NULL
)
INSERT INTO #Test(IP,Test)VALUES('192.168.8.12','A')
INSERT INTO #Test(IP,Test)VALUES('192.168.8.22','A')
INSERT INTO #Test(IP,Test)VALUES('192.168.8.22','B')
INSERT INTO #Test(IP,Test)VALU...more >>
CSV as inparam Posted by Hakan at 5/2/2004 1:41:03 PM Hey
I have a table named "employee", another table called "knowledge". A third table called "employeeKnowledge" stores relational data for these tables. A schoolbook example. My problem is that I want to pass a CSV (comma separated value) as inparam to stored procedure which contains the knowledgeI...more >>
Migrate from SQL Server 2000 to Oracle 9i Posted by bcheema at 5/2/2004 9:41:02 AM Does any one know how to migrate database from SQL Server 2000 to Oracle 9i? Any help would be appreciated
Thanks....more >>
No logging a select into statement Posted by Fabrizio Maccarrone at 5/2/2004 7:45:32 AM I perform 2 select into statement and my log file grow up to 2.5 gb.
I do not use this log to ship or so on than I can truncate it whan I want.
Is there a way to NO LOG this statement?
Any help appreciated.
Regards.
--
Fabrizio Maccarrone
YAMSSQLU
(Yet Another MSSQL User)
--
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Row inputs for a stored procedure Posted by James Autry at 5/2/2004 3:47:12 AM I have set up my update command as a block of rows to insert into a table
with one update.
If I port this to a stored procedure, can I pass this rowset to a stored
procedure, or do I need to call the stored procedure to iteratively insert
row data. What is the most efficient method?
Thanks...more >>
Creating unique records using a stored procedure Posted by Derek Chapman at 5/2/2004 1:56:02 AM H
Does anyone know how to create a unique record identifier using a lookup from a master table? For example
I have a table called SystemTable which has 2 fields, SystemTable.Table_Name and SystemTable.Table_Counter. There is a unique record for every table within my application, with the name in...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |