| Groups | Blog | Home |
|
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 |
Filter by week: 1 2 3 4 5 Using SQL Server to store files Posted by John Owens at 6/14/2005 4:03:14 PM I want to store documents in SQL Server (using it as a file repository) so
it can be accessed via a WebForm in .NET.
Is this possible and if so is there any references or documentation about to
do this? BTW - The .NET stuff I can handle.
Thanks.
...more >>
Insert Date Value Posted by syrac at 6/14/2005 11:48:55 AM On my ASP page, with a SQL backend, I have the following code to insert a
date value into a table, but it is not working correctly.
sql = "UPDATE Problems SET FupDate = '" & updFuDate & "' WHERE TicketNumber
= " & tn & ""
The value updFuDate is currently 06/15/2005. The command works, howev...more >>
Searching for Duplicate records. Posted by bob at zachys at 6/14/2005 11:39:04 AM Is there a better way to search for duplicate records. Currently Im
accomplishing this by using two views.
Veiw1 looks like this
SELECT BoxId, COUNT(BoxId) AS Expr1
FROM dbo.tblInvCount
GROUP BY BoxId
HAVING (COUNT(BoxId) > 1)
View2 looks like this
SELECT ...more >>
databse from SQL2000 to MSDE Posted by np at 6/13/2005 12:00:00 AM Hi,
I need to move a database from SQL2000 to MSDE.
I've googled for it and figured out I should use DTS to do so, however I
can't seem to find the procedure on the MSDE side to "restore" the data
base.
any help would be kindly appriciated :)...more >>
Limiting data to certain years Posted by et at 6/12/2005 2:44:37 PM Is there a way to limit a column to a set of years, including the current
year, whatever that may be?
for instance, a column can only contain years 1950 to currentyear, without
me having to change the currentyear every year?
Would I do this through a rule/user defined type? If So, can you...more >>
Advice needed Posted by S W at 6/11/2005 9:45:26 PM Hi,
What is the best practice for virus checking and backup of a W2003 server
hosting SQL2000?
Virus checker is CA eTrust, backup is Veritas 9.1 (without the SQL agent)
I occasionally have problems with a SQL app "hanging" for a couple of
minutes which I think could be due to realtime v...more >>
Saving/Retrieving DTS Package Posted by et at 6/10/2005 12:26:33 PM I have saved my DTS package, selected SQL server, gave it a name, and it
runs.
Now I want to run it again. Where do I find it?
...more >>
test of sa login Posted by carnold at 6/10/2005 9:31:00 AM How do i test the sa login.....I'm not sure if I know the password and I want
to test the login to see if I know what it is....more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Date and Time Posted by dthmtlgod at 6/9/2005 2:26:41 PM In database design.
I have a field called ActDate and ActTime, the DataType is datetime. I want
the default value to be the Current Date and Current Time. In Access it is
Now() and Time(). I tried that but it didn't work.
Could someone please assist.
Thanks,
Doug
...more >>
Combine Columns Posted by Usarian Skiff at 6/9/2005 12:32:12 PM I am querying a SQL Server database that is set up with three columns that
really should be one. Basically, each row in this table consists of up to
three seperate entries. I need to take each entry and show detail pulled
from another table, converting the whole thing to list vertically. Is th...more >>
delete query? Posted by r at 6/9/2005 12:21:03 PM I want to delete a set of records in one table where they have a matching
criteria in another table. Problem is, I guess, because of the join I'm
using to determine the criteria, the delete can't be performed.
I have Table1 which contains the records to be deleted, which is joined to
Table2 b...more >>
Database and performance Posted by troutman at 6/9/2005 8:46:10 AM Is there a performance difference between 5000 people accessing a single
database versus 5000 accessing 50 differnet databases (same Box in both)
Thanks...more >>
At least one record has a specific value Posted by Lorraine at 6/9/2005 7:21:03 AM I am trying to figure out a way to find a count of records for a person where
at least one record has a regionid = 4
The way my query is currently set up it is giving me only records where the
regionid =4 not where at least one of them is a 4
join tblds on
ds.siteid= dh.siteid
and ds.reg...more >>
listing a table or view structure Posted by Gary Rynearson at 6/9/2005 12:00:00 AM Does anyone know the command (used in query analyzer) to describe a table or
view structure?
I have used in oracle the command:
desc myTable (or describe myTable, I do not rcall)
Thanks
...more >>
Migrating data from old database structure to new one Posted by Alex Gemmell at 6/9/2005 12:00:00 AM Hello!
I hope someone can help me with this problem:
I have been tasked with improving our company's old database. The
current MSSQL database structure is full of columns/tables we don't need
anymore. There are large tables that would be much better split into
separate smaller tables s...more >>
Storing XML data natively in SQL2000 Posted by single threaded at 6/8/2005 9:16:05 PM I need to store some semi-structured data (XML) in SQL 2000 db. Creating
relational tables is definitely not the best option. I was wondering if
storing it natively is a good option. How mature is the idea ? Is this still
too early to venture into this unchartered territory ? We would probably...more >>
AutoIncrement Primary Key Posted by Gabe Matteson at 6/8/2005 12:48:20 PM Is there anyway to auto increment the primary key column like you can in
access but for SQL 2000? Thanks,
- Gabe
...more >>
Looking for a FAQ or Article recommendation for optimization. Posted by John at 6/8/2005 10:58:15 AM Hi,
Can anybody point me in the direction of a good SQLServer query optimization
online article?
Basically, I know a bit, but there are definitely holes in my knowledge
which I would like to fill.
Thanks in advance.
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |