|
|
|
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 Open DBF file with MSDE Posted by H.S. at 1/31/2004 10:49:53 PM Hi
Sori, but how is possible to open a DBF file with MSDE.
The server MSDE is already instaled, but I d'ont know how atache the
Teste.mdb file?
Is necessary to run same script?
Please urgent.
H.S.
...more >>
Backups with MSDE Posted by SStory at 1/31/2004 10:40:46 PM How can I setup backups with MSDE?
I have the DBAMGR2 but don't know how to set up backups for it.
What is the best strategy. The people who are using it with my app have a
tape backup on the machine, but I'm not sure how to set up backups. And
they are not super users or anything.
Wha...more >>
Which is faster? Posted by William Chung at 1/31/2004 10:07:53 PM Q1.
I have to create a table with new schema which has 10 billion rows.
Which is faster?
method 1:
select ...... into
alter table NEW alter column c1 char(5) NOT NULL
alter table NEW alter column c2 char(5) NOT NULL
alter table NEW alter column c3 char(5) NOT NULL
...
alter table ...more >>
String Result! Posted by Jeff at 1/31/2004 9:48:07 PM Hi,
I've a SQl 2000 Standard Editon on 2K Server. I've a VB program that run
locally. Recently I got Timeout probelm where the command timeout = 90.
Then I tried on other PC to call reomtely. It's worked fine. Is there any
differences for SQL to react on local and remote query and update. ...more >>
Unique Values and NULL output Posted by don larry at 1/31/2004 8:49:59 PM Greetings, here's my table
--DROP TABLE Tbl2toe
CREATE TABLE Tbl2toe (ThisID int IDENTITY(1,1), NameID int, myName
varchar(20), myPhone varchar(20))
INSERT INTO Tbl2toe (NameID, myName, myPhone)
VALUES (1,'Droof', '233-2223')
INSERT INTO Tbl2toe (NameID, myName, myPhone)
V...more >>
Simple Cursor Question Posted by CSharp ( ILM ) at 1/31/2004 5:08:51 PM Hello, I am using a cursor but getting my results doubled, Trippled etc..
DECLARE some_cursor CURSOR FOR
SELECT C1S, C2S,
FROM SomeTable
WHERE OST= @OST -- this has some value
OPEN some_cursor
FETCH NEXT FROM some_cursor
WHILE @@FETCH_STATUS = 0
BEGIN
Insert TargetTable(C1...more >>
smallint and int Posted by Alex Chan at 1/31/2004 3:03:25 PM Hi All,
I would like to use the smallint as the primary key for some tables which is
enough. Is there any impact for the performance issues?
If compare with integer fields? Will it be slower when I use it as the
primary key?
Thanks and Regards
Alex
...more >>
Help with Date Posted by Kissi at 1/31/2004 2:48:42 PM Could anyone help me with this Please. I want to write an SQL statement in
VB.
A user enters a start date using inputbox. Sql statement searches database
with two fields,
BeginField and EndField. If date entered by the user exist within the range
BeginField and EndField, prompt user(Dates not a...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Problem with a SQL Statement Posted by Atley at 1/31/2004 2:24:37 PM I have three tables:
Products Table
PID
PName
PType
Linking Table
LID
PID
CID
Customers Table
CID
CName
CPhone
I am trying to make a single statement that will give me all the customers
that haven't bought a certain single product so i can make a list of people
to c...more >>
weird errors when precompiling genwin.sqc with nsqlprep Posted by akumar1 NO[at]SPAM mn.rr.com at 1/31/2004 2:16:37 PM I am trying to compile the sample program genwin.sqc, using nsqlprep
which is used to precompile embedded sql in C. I am getting weird
errors and that is because windows.h is included in the genwin.sqc
file. I am using
Setting the lib and include path:
set INCLUDE=C:\Program Files\Microso...more >>
SQL Server User Group Posted by Roji. P. Thomas at 1/31/2004 1:16:03 PM How can I start a SQL Server loca user group (community)
that is recognized by MicroSoft?
--
TIA
Roji. P. Thomas
...more >>
Problem with INFORMATION_SCHEMA.SHEMATAS Posted by Per Hultqvist at 1/31/2004 1:05:01 PM Hi,
I have used "SELECT * FROM INFORMATION_SCHEMA.SCHEMATAS" to give me the
names of all databases on the SQL-server. The problem is that I just
realized that the list is not allways complete. I have 30+ databases and
there are 6 or 7 who is missing. I have seen this happen from different
com...more >>
nvarchar and field collations Posted by Sedat Eyuboglu at 1/31/2004 12:37:49 PM is the collation of the field effective when i use the nvarchar for the
field as the datatype.
sorting properties may be still effective but the charakter set?
i can't understand exactly what happens when i use the nvharchar although i
use it successfuly.
i need any description about this poi...more >>
Northwind SQL UPDATE problem Posted by Nick Butler at 1/31/2004 11:47:58 AM Hi,
I have added a field to the Customers table called TotalValue with a type of
Currency.
I want to populate this field with the total value of all sales to that
customer, so I tried this:
UPDATE Customers SET TotalValue =
(
SELECT SUM( Quantity * UnitPrice * ( 1 - Discount ) )
FROM O...more >>
Is it possible to Alias a database name? Posted by Enzo at 1/31/2004 11:28:22 AM We have an application where we create two databases in SQL Server.
The data is seperated for a reason, however, there are some stored
procedures that need to reference
the other database for some business rules.
Lets say I have DB_ONE and DB_TWO.
In a stored procedure in database DB_ONE ...more >>
Convert Date Varchar To smalldatetime Posted by allen NO[at]SPAM oysterweb.com at 1/31/2004 9:27:55 AM I am having a difficult time accomplishing the following. I have a
text file that contains fields containing dates with and without the
time stamp.
ie;
1/12/2003
1/12/2003 12:30:00 AM
11/1/2003
11/1/2003 12:01:00 PM
etc.
I am trying to import the text file using DTS, but it will only ...more >>
Stored procedures Posted by Peter Newman at 1/31/2004 8:11:06 AM I read a comment someone made that it is better to use a stored procedure thans a T-sql if possible, to this end im trying to write a stored prodedure to create a recordset from several tables, is it possibel t
1. create two temporary tables from two different select statments
2. join the two ta...more >>
Slow UDF in Replicated Database Posted by dave NO[at]SPAM whconsult.com at 1/31/2004 7:55:39 AM I have a database that is being replicated to a server. I am finding
that some UDFs are running very slow in the replicated version of the
database. If I run the same query against a non-replicated version of
the database on the SAME server, the query runs quite fast - 3 seconds
compared to 59 s...more >>
datetime conversion Posted by SMK at 1/31/2004 6:46:07 AM I have numerous datetime fields that are times when something was done. I would like to convert
these to smalldatetime but can't because SQL has put in 1/1/1900 or whatever it uses for a date if
nothing is specified and whatever date that is is apparently outside the smalldatetime range.
How c...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |