|
|
|
January 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 |
Filter by week: 1 2 3 4 5 Microsoft OLE DB Provider for ODBC Drivers error '80040e14' Posted by Bhavna at 8/14/2007 12:47:42 PM I have recently updated the stored procedure and now I am getting
"Microsoft OLE DB Provider for ODBC Drivers error '80040e14' .
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
'bbakshi'. " error message. Here is the stored procedure
CREATE PROCEDURE stp_ExportMeetings @selm...more >>
Find rows by date. Compare today's row with yesterdays etc Posted by Yas at 8/14/2007 6:58:42 AM Hello,
I have a table containing user data. Each row has user data and last
column of each row has current date in the format: 2007-07-04
00.00.00.000. I don't need to specify time. I'm using
dateadd(day,datediff(day,0,getdate()),0) to build this column.
Each day new user data is updated a...more >>
Restore database with no log Posted by at 8/14/2007 3:51:04 AM I'm trying to restore a database backed up a production machine onto
my development machine. I don't want to restore the transaction logs
(there are two) because they are far too large and are unnecessary for
what I'm doing. I would be happy to simply create one new log in my
development envir...more >>
query Oracle -> sqlserver Posted by dario.8282 NO[at]SPAM hotmail.it at 8/14/2007 2:53:20 AM select pippo
from
(
select person.name as pippo
from person
)
This query run in oracle....in sqlserver no!
what can i do!?
thank's
...more >>
Restoring from Backup without logs Posted by GM at 8/13/2007 2:53:09 PM We have received a backup file that is 6G in size. The log file is
about 74G while the MDF is about 5 G when we restored. Is there a way
to run a SQL script to restore the .BAK file without restoring the log
file as we do not have enough space on the server.
PS. We are running Sql2K5.
Thank...more >>
Temp Table vs. Union: Which Has Better Performance? Posted by at 8/13/2007 1:45:33 PM Right now, a client of mine has a T-SQL statement that does the
following:
1) Create a temp table.
2) Populate temp table with data from one table using an INSERT
statement.
3) Populate temp table with data from another table using an INSERT
statement.
4) SELECT from temp table.
Would i...more >>
Linked Server Headache (Access) Posted by BillCo at 8/13/2007 9:39:34 AM
There seems to be a lot of confusion around the groups about linking
to an Access mdb with the SQL Server Jet OLE DB provider and I havent
been able to find a straight forward solution. Basically, I have an
Access MDB (A2K) on one server and a SQL Server DB (2005 std ed.) on
another - Both on ...more >>
INNER JOIN - INSERT Posted by Clive Swan at 8/13/2007 2:44:43 AM Hi,
My GIS software has a tool to count the number of points within a
grid.
This is fine for small recordset, when you get into the tens thousands
it
becomes unfriendly.
It must be possible (more efficent??) to do a select statement from
the two tables and insert the result into a column?...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Saving data to SQL Data Base Posted by Omar Abid at 8/10/2007 12:07:19 PM Hi,
I'm using the following code to open a data base and show it's content
in a Data Grid View
----
Code
-----
Imports System.Data.SqlClient
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
Dim conn As New SqlConnection("...more >>
Standard Schemas? Posted by Rich at 8/10/2007 12:03:23 PM Hi,
Anyone know an online source for database schemas, or schemas for single
tables i.e. where can I download a schema for an addresses table?
--
Rich
http://www.badangling.com -= Sea fishing badly explained =-
...more >>
Using sql to execute a batch file Posted by mcolson at 8/9/2007 3:44:36 PM Is it possible to use sql to execute a batch file? I would like to
execute the following "C:\BTW\bartend.exe /f=C:\BTW\Toolbox\Formats
\carnum.btw /p", 6
Thanks,
Matt
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |