|
|
|
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 INSTEAD OF trigger not quite working ... Posted by Chris Smith at 12/26/2005 11:07:17 PM I am trying to create an INSTEAD OF trigger on a table that only has two
fields: an ID and a description. The following code is not quite doing,
well, anything that I have been able to figure out ...
CREATE TRIGGER InsteadInsertTrigger_BookTypes on BookTypes
INSTEAD OF INSERT
AS
BEGI...more >>
Reporting Services Posted by dreammunna NO[at]SPAM gmail.com at 12/26/2005 10:39:31 PM Hi,
I am new for the Reporting Services. I need to generate a reports
based on a stored procedure. When we call the stored procedure it says
Invalid object name '#LType'. (Microsoft SQL SERVER, Error:208)
If we see the stored procedure, we find that there is a temporary table
'#LType' where ...more >>
A hashtable that contains millions of records Posted by Lang at 12/26/2005 9:10:04 PM My database has a hash table that contains millions of records.
Each day thousands of records will be inserted/updated/deleted/read from
this table.
Are there potential problems that I should be awared of?
Is there a better solution not to use just one table?...more >>
Problem with Insert in to IP to Microsoft Acess by ASP Posted by minhadd NO[at]SPAM gmail.com at 12/26/2005 8:45:33 PM Hello
Would Anyone help me ??
I want insert into Microsoft Acess visitor's IP by ASP. But It is not
working
---------------------------------------------------------------------------=
=AD-------------------------------
NOT WORK
<%
..=2E.....
time =3D now()
ipp =3...more >>
Custom Weeks Posted by Scott at 12/26/2005 6:00:01 PM In CODE section below, I'm grouping the Sum of Freight by the week/year. We
have a custom year begin and end year table that the DDL section will
create. Thus, I use the t_week table to calculate our custom weeks with week
1 of any year starting with the date in the week_beginyeardate field an...more >>
select question Posted by Rick at 12/26/2005 4:40:10 PM I have a table with 3 columns and some simple data.
RefID - EntityRefID - Date
1 abc 12/20/2005
2 cde 12/19/2005
3 def 12/20/2005
4 abc 12/19/2005
RefID is unique, EntityRefID and Date are not unique.
I ...more >>
Convert question Posted by Javier at 12/26/2005 4:19:14 PM Hi,
I am importing data form a text file and I have a problem with a column
format
In the file, the numbers are are stored with this format: -54.565,49
Now I have to change the format to -54565.49 to store this value into a
decimal using DTS
Could you help me ?
Thanks ...more >>
Copy Database Wizard never finishes Posted by Marco Napoli at 12/26/2005 3:01:14 PM I am trying to use the Copy Database Wizard to copy about 240 databases on
Server1 with With SQL Server 2000 to Server2 with SQL Server 2005 64 bit.
The Copy Database Wizard starts and is successfull with the first 4 steps
but the last 5th step never finishes. I have tried moving all of the
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Format of DateTime types in Select vs Open Table Posted by michael at 12/26/2005 2:07:01 PM From within the SQL Server Management Studio, if I select a table and display
it (right click Open Table), columns of type DateTime are displayed with the
mm/dd/yyyy hh:mm:ss format. However, if I SELECT * FROM the same table from a
query in the Query Analyzer (or New Query in 2005), the same ...more >>
Very big table performance problem Posted by Feches at 12/26/2005 1:39:02 PM Hi all,
I have a problems with a table of 26 millions (26,000,000) rows.
I made several index but continuous slow.
It’s an historical stock table.
Can I fragment this table into tables per quarter and have one view to
query the information?
How can I do this?
THX
...more >>
How to retrieve rows with no Duplicate in this case? Posted by Mike9900 at 12/26/2005 12:11:02 PM I need to get rows without dupicate ProductID. In the below query, the
subquery returns 1 row, which is fine. But the query itself returns 2 rows
because the TransactionDate has two same date. I want the quesry to return
only one row if it has the same ProductID.
TransactionID is the prim...more >>
New release of SqlClrProject Posted by Niels Berglund at 12/26/2005 5:54:49 AM I thought I better post before this year ends. :-)
Anyway, you may know that I have developed a MSBUILD task dll for
deployment of SQLCLR assemblies. I also created some templates for use
from with Visual Studio 2005, the SQLCLRProject.
I have re-created this as an Add-In for VS, so you no...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |