|
|
|
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 odd TEXT type field problem Posted by Janos Horanszky at 2/12/2005 11:39:49 PM Hi,
There is a db with 200GB, with ~160 GB data in it. Most of the data was a
TEXT type field in a table. That field has been dropped and added back with
default NULL but it appears I still have ~160 GB of data.
How is that possible?
updatestats would help?
The table in question has a two ...more >>
Syntax for Index Posted by Ed at 2/12/2005 5:45:01 PM hi,
Is that possible I can use Information_Schema to find out all the index
name(s) in the table???
So far I have looked at all Information_Schema, but no luck and I have to
use sp_helpindex.
Thanks for any help
Ed...more >>
OPENROWSET issue Posted by Lee Tudor at 2/12/2005 5:24:24 PM I have an issue with openrowset:
I'm trying to access data through the EXOLEDB provider with OPENROWSET, but
I get a cannot create new session on OLEDB provider error
IDBCreateSession::CreateSession 0x80040e19. (authentication definately
suceeds because I tried this with an invalid password...more >>
How to Truncate The Transaction Log ? Posted by IMRAN SAROIA at 2/12/2005 4:58:53 PM Hi !
I want to truncate one of the transaction logs of my test database.
Please advise !
...more >>
Text, ntext, and image datatypes cannot be sorted Posted by Spencer H. Prue at 2/12/2005 4:13:01 PM or compared, except when using ISNULL or LIKE operator. I am using ntext as a
MSDE column. I hace tried other data types and found that the data was
truncated. When I use ntext the string doesn't get truncated, but I get the
above error. When I run the sqldataadapterwizard the wizard doesn't g...more >>
How could I use row as columns? Posted by XXY at 2/12/2005 3:39:01 PM create table t2
(
umc varchar(20),
outdate datetime,
outnumber int
)
insert t2 values (1,'2005-2-5',1)
insert t2 values (2,'2005-2-5',1)
insert t2 values (2,'2005-2-6',1)
insert t2 values (3,'2005-2-5',2)
insert t2 values (3,'2005-2-6',1)
insert t2 values (4,'2005-2-7',1)
I hope the ...more >>
Time query Posted by Henry at 2/12/2005 10:58:02 AM Hi
I have been struggling with a query where I need to summerize per quarter
(15minuts) , I have made this query which almost works
select digits, cast(cast(DATEPART (hour , DATECALLINITIATED ) as
varchar(2))+':'+ cast((DATEPART ( minute , DATECALLINITIATED )/15 )*15 as
char(2))+':00' as sm...more >>
String Search Posted by RichieRich at 2/12/2005 10:27:21 AM Need help to compare the values between two columns in two tables. Example:
Table1 has column with string '1,4,12,18'
Table2 has column with string '2,5,6,12,18'
If Table1 column has at least one match to Table2 column then return true.
Any ideas?
Thanks....more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQl Query Posted by Sam Uncle at 2/12/2005 9:57:36 AM
Hi I am writing to know answer to some of my questions.
My Data looks like following
ID Month_year Sales
24 Sept 02 100
24 oct 02 120
..
..
..
..
24 dec 03 150
150 sept 02 200
150 oct 02 220
..
..
..
..
150 dec 03 500
...more >>
Advice requested - How do I convert a Base36 number to SQL int ????? Posted by Russell Mangel at 2/12/2005 9:45:54 AM Hi,
Does anyone know if it is possible to create a Stored Procedure in
SQL7.0/2000 to do the following:
I need to convert an SQL int value to a Base36 value, and the other
direction Base36 to SQL int.
Example:
Take the (Base10) number 22, and convert to "M".
Take the (Base36) number "...more >>
Week no query Posted by Henry at 2/12/2005 9:05:33 AM Hello
I'm looking for a query which can select and group by week no
I have query for a SQLBase which gives me this but I cannot translate it to
MSSQL?
select Some_Date, (@weekbeg(Some_Date) - @weekbeg(@date(@yearno(Some_Date),
1, 1))) / 7 + 1 as Week_Number
from Some_Table;
Here's...more >>
Getting resuls asynchronous from SQL Server Posted by B.J. at 2/12/2005 6:07:03 AM Hi,
Suppose I have following T-SQL statements :
INSERT #T SELECT ... -- takes c. 10 minutes
SELECT * FROM #T
-- Calculation in cycle over #T
-- on end of cycle will be inserted new row to #NextTable
-- end of cycle
SELECT * FROM #NextTable;
All this I run as batch.
Can I get results...more >>
How do I create a system stored procedure Posted by sim kin at 2/12/2005 5:12:09 AM How do I create a system stored procedure?
Thanks
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!...more >>
duplicate error report Posted by souris at 2/12/2005 1:23:28 AM I have an app which downloads data from mainframe daily.
Because the primary key definition is different, I have to verify duplicates
before import to my local table.
I would like to know that is it possible to insert duplicates into a table
to investigate later on.
If yes, where is the bes...more >>
Connecting to Access Posted by Andrew Clark at 2/12/2005 12:31:05 AM Hello,
I am trying to connect to an Access database though Query Analyzer. The
help file is minimally helpful on this. This is what I have so far:
-- add the database as a linked server
execute sp_addlinkedserver Library,
'Access 2002',
'Microsoft.Jet.OLEDB.4.0',
'D:\today\Andrew\Libr...more >>
Incorrect syntax near 'use ' Posted by Robert Richards via SQLMonster.com at 2/12/2005 12:15:54 AM I am trying to run the following three line statement and I get an error
stating: "Line 3: Incorrect syntax near 'use '."
The database name is correct, "cms user messaging"
declare @dbname sysname
set @dbname = 'cms user messaging'
'use ' + @dbname + ' DBCC SHOWFILESTATS with no_infomsgs'
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |