|
|
|
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 [MSSQL] ODBC Posted by Marek Powichrowski at 9/25/2004 9:08:17 PM Hi all,
is it possibile to access two (or more) database tables using ODBC driver
for MSSQL 2000 ?
I have the select statement :
SELECT K.field1,
O.field1,
O.field2
O.field3
FROM ( table1 AS O
LEFT OUTER JOIN other_database_name.table2 AS K ON O.id = K.id )
WH...more >>
viewing differences between 2 db's (dev and production) Posted by Brian Henry at 9/25/2004 7:02:44 PM I would have to think this would be a common question for developers...
I have a production database which absoutly has to be perfect as it is used
regulary. and a development database which we do all the dev work on and
constnatly loose track of what was changed and what is still the same......more >>
Use of common SProcs in one database referring to tables in another database Posted by Lloyd Sheen at 9/25/2004 6:45:16 PM I have the following situation. We have an application which has a common
set of stored procedures but we have a seperate database for each user of
the database (not user of the application). We do not want to keep the
stored procedures in the database with the data but have one "common"
d...more >>
VB6/ADO: "Table.Append" yields VB6 error of 'The parameter is incorrect' with ADO v2.8 Posted by Martin A. Weinberger at 9/25/2004 6:00:30 PM Hi All,
I was interfacing to a MS-SQL 2000 server from my VB6 application using ADO
v2.7 nicely without any hitch. I decided to upgrade to ADO v2.8 and ever
since then I'm receiving the error (from Err.Description) of "The parameter
is incorrect". This error message is not very helpful. Anyway...more >>
Indexes Confuses me!! Posted by Drew at 9/25/2004 5:51:56 PM I was reading an article by Itzik Ben-Gan ->
http://www.windowsitpro.com/Article/ArticleID/21642/21642.html
It Gives the following example
"Suppose you have a table, T1, with a million rows and each row requires
around 400 bytes of storage. About 20 rows fit in a data page, thus the
table req...more >>
This is a Nice One (Bug) Posted by Tom Jastrzebski at 9/25/2004 4:14:40 PM Hello everybody,
Try this:
declare @table table(col int)
select a.col
from @table a
join (
select c.col
from @table c
join (
select e.col
from @table e
where e.col = (
select max(g.col)
from @t...more >>
delete error - correct error message Posted by SusieQ at 9/25/2004 4:05:16 PM I have this code
Function openDB()
Set conn = server.createobject("ADODB.connection")
conn.open "DSN=database"
Set rs = server.createobject("ADODB.Recordset")
End Function
Call openDB()
set rs=conn.execute("SELECT * FROM tblMemberTemp INNER JOIN tstBarCode on
memberBarCod...more >>
Warning: Existing columns have ANSI_PADDING 'off' Posted by Matt at 9/25/2004 4:05:05 PM I'm having an issue where I inhereted a database where existing columns in a
table have ANSI Padding Off
I am trying to add a column to the table and get a messge
" Warning: Existing columns have ANSI_PADDING 'off'. New columns will be
created with ANSI_PADDING 'on'."
I'm adding a char...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Delete error Posted by SusieQ at 9/25/2004 3:55:07 PM I have this code
Function openDB()
Set conn = server.createobject("ADODB.connection")
conn.open "DSN=database"
Set rs = server.createobject("ADODB.Recordset")
End Function
Call openDB()
set rs=conn.execute("SELECT * FROM tblMemberTemp INNER JOIN tstBarCode on
memberBarCo...more >>
COLUMNS_UPDATED Question Posted by Drew at 9/25/2004 1:39:07 PM Can anyone please explain me the working of COLUMNS_UPDATED(). I did go
through BOL but not much given on this topic. I did see some of the article
regarding this. Got some but not not completely understood, specially the
use of Substring.
Thanks
...more >>
Help with call function from a remote server Posted by Chu Tat Hon at 9/25/2004 12:21:53 PM Dear All,
I have a SQL statement which work if I run a from a local server:-
SELECT * FROM BESTSELLER('09/01/2004')
where BESTSELLER is a function that return a table.
but when I try to run it from a remote server, it return a error message:-
SELECT * FROM [SERVERNAME].[TESTDB].DBO....more >>
database scheme upgrade problem Posted by angus at 9/25/2004 11:04:15 AM Dear All,
i am a software developer using mssql.
There was a database A was used to development my system and it was deployed
to
the client.
then, in the past months, the client wanted to add a lot of functions. I
changed the database scheme
(add new fields in the current table in datab...more >>
Insert Query taking ages.... Posted by Kan Grewal at 9/25/2004 10:29:54 AM I have a very simple table:
username - varchar(10)
login_date - datetime
The problem I'm having is that every so often an insert query into this
table is taking ages to complete:
insert into login (username, login_date)
values ('test', getdate(())
Usually it takes less than a second to c...more >>
what's wrong Posted by Ed at 9/25/2004 9:15:26 AM Declare @Counter = tinyint
Declare @SQL nvarchar(100)
Set @Counter = 1
while @Counter <=12
Begin
If @Counter >= @startdate and @Counter <= @enddate
Begin
Set @SQL = @SQL + 'M' + convert(varchar(2), @Counter)
End
Set @Counter = @Counter + 1
End
What's wrong with the above sta...more >>
Error Message about Missing Index? Posted by Lucas Tam at 9/25/2004 5:38:06 AM Hi All,
I'm getting this error when there are queries against a bit index:
Error: 8646, Severity: 21, State: 1
The index entry for row ID was not found in index ID 6, of table
1051150790, in database 'TestDB'.
I've ran CheckDB and CheckTable but they both say the table is good.
The...more >>
Help with Stored proceedure Posted by Phil at 9/25/2004 4:02:16 AM I have limited knowledge of sql quiries and am trying to
do the following:-
I have a langage table with cols
langID : VariName : word
I need to create a stored procedure which I only pass in
the langID as Int but this will select numerous word
matching a pre defined list of VariName (i.e.
...more >>
Newbie Question on Jobs & Stored Procedures. Posted by Rob Boger at 9/25/2004 3:48:46 AM Hi, I was hoping someone could help me out, I have a table that lists tasks
and when they are supposed to be done. Note: These tasks are user tasks and
not server or system based.
I created a job that will run every hour that pulls data that meets the
requirement and then calls a stored proced...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |