|
|
|
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 database size is very large Posted by microsoft.public.dotnet.languages.vb at 10/8/2005 7:33:52 PM Hi All,
I ran sp_spaceused and the result is following:
database_name database_size unallocated space
DB1 6462.50 MB 1466.20 MB
reserved data index_size unused
4108216 KB 1889512 KB 298952 KB 19197...more >>
Converting hh.hh to hh:mm Posted by Doug Hood at 10/8/2005 7:03:01 PM Hi,
I am summing an amount of time that is stored in seconds then dividing by
3600.00. The result is correct but in the hh.hh format. I would like to see
the result in the hh:mm format.
i.e 29700 seconds / 3600.00 = 8.25. I would like to see 8:15
Any ideas?
Thanks,
Doug
...more >>
LInked Query Posted by vineetbatta at 10/8/2005 5:30:02 PM I am trying to insert data into to sql server using linked Query
Source Server : S1
Desitination server : S2
Query fired from Soure Server
insert into s1.dbname.dbo.table (col1, Col2)
Select 1, 1
it gives the following error
OLE DB provider "SQLNCLI" for linked server "sa2k3tst1" ret...more >>
DISTINCT Query Posted by Joe Delphi at 10/8/2005 4:21:55 PM Hi,
I want a query to return the values in three columns, but I only
want distinct values in one of the three columns. Is this possible? I
want to do something like this:
SELECT A, DISTINCT(B), C
FROM TABLE Z
but SQL Server doesn't like this syntax.
Any ideas?
JD
...more >>
Creating New tables by copying existing table Posted by Hugh O at 10/8/2005 3:28:45 PM Hi,
Is there any easy way of copying the structure of a table within a single
database and creating a new table with a new name. I have an app that the
structure of several new tables is close enough that it would save time if I
could create one and copy and recreate a new one under a new na...more >>
Importing .prc Files Posted by Joe Delphi at 10/8/2005 10:57:38 AM Hi,
I saved a bunch of stored procedures as .prc files. How do I import
them back into my database using Enterprise Manager?
JD
...more >>
Designing for growith using views Posted by hals_left at 10/8/2005 10:51:38 AM Is it a good idea to create derived views form a single Sales view to
reduce the number of records being searched and increase performance?
e.g
View Sales links Sales, Product, Sales Line, Salesperson Tables
View SalesJon04 Adds "WHERE SalesPerson='Jon' and SalesYear=04
View SalesFred04......more >>
DateTime from txt Posted by Patrice at 10/8/2005 10:43:26 AM I need to convert a txt field to SQL datetime that looks like the following:
199902250215
So it only has the yyyy/mm/dd hh:mm
SQL does not seem to like that it doesn't have the seconds and miliseconds.
How can I do this?
Thank you!
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Exchange/SQL/VB/Outlook (and possibly a little DDE for good measur Posted by Matty B at 10/8/2005 10:01:02 AM Hi Peoples,
- This is also logged in Exchange Server Development Thread -
First let me start by saying I'm not sure if this is in the correct thread -
so a million apologies if it is a little of topic (and for the duplication).
Now...
I have a Windows Server 2003 environment with the fo...more >>
xp_cmdshell and net drive access denided Posted by TdarTdar at 10/8/2005 9:22:02 AM Hello,
First off I am far from a novice in security. I also am Administrator of
the
whole system.
I am tring to run
exec xp_cmdshell 'test.bat'
test.bat
f:\
dir
this batch file that works fine from the local SQL machine command prompt
but if i run it from the QA exec xp_cmdsh...more >>
DATEPART(wk,'dd.mm.yyyy) - how to provide dateformat? Posted by Xavier at 10/8/2005 8:58:02 AM hello,
in a table i have a row of type VarChar where the datevalues are stored in
the format yyyymmdd
example of values
20050924 - the code from the date 24.9.2005
20051001 .......... 1.10.2005
i want to get the weeknr of this dates to make a updat...more >>
Can a commit fail??? Posted by Abdullah Kauchali at 10/8/2005 12:00:00 AM Can an error occur /during/ the process of committing a transaction? So:
BeginTraction();
try {
UpdateTable1();
UpdateTable2();
CommitTransaction(); <-- error here???
} catch(Exception e){
RollbackTransaction();
}
Also, what are the implications in such a situation wher...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |