|
|
|
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 August 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 SQL 2005 Reporting Services Posted by Just Me at 8/18/2007 8:53:11 PM Hey Peeps,
My exisiting scenario is SQL2000 with no reporting services, and we use
Microsoft .NET 2003 and Crystal reports to report. This works reasonably ok.
As the ASP.NET application uses one account to access the database, then the
security for who can see a report is managed by the appli...more >>
bulk-logged recovery model Posted by Roy Goldhammer at 8/18/2007 8:13:07 PM Hello there
For my informantion if i Insert/Update/delete more then one record the
performance of changes decreased (according to amount of data I change).
and in order to cause less decrease I should use bulk-logged recovery model
in order not to write huge amount of data.
About this i h...more >>
Collation Conflict Error Posted by Terrance at 8/18/2007 7:54:05 PM I'm currently testing a stored procedure that someone wrote for a Sql Server
2000 database. When I attempt to log into a ASP.NET application that runs
this store procedure I receive the following Sql Exception: Cannot resolve
collation conflict for equal to operation.
I believe the problem ...more >>
advice on creating ad-hoc report via stored procedure Posted by Derek at 8/18/2007 7:40:03 AM sql server 2000
i have a stored proc that has dynamic sql in it like this (queries are
illustrative and may not be 100% bug free). The user can search
person table by lastname, lastname/firstname, firstname or for all
persons. There are indexes on both lastname and firstname.
select @sqls...more >>
I haven't noticed this before Posted by beginner16 at 8/18/2007 7:04:29 AM Hello
I haven't noticed this before. Conceptually, the the following inner
statement is executed for each row, thus if A has 20 rows, then inner
statement will be executed 20 times
SELECT a1, a2
FROM A
WHERE ( SELECT COUNT(*)
FROM B
...more >>
Bulk Insert Posted by zwieback89 at 8/18/2007 4:59:22 AM Hi,
This question is about Bulk Insert in SQL Server 2000.
I tried this code. I do not get any errors related to the code:
--Declare a variable to hold the count for the rows in the above table.
DECLARE @CountOfRows int
SET @CountOfRows = (Select Count(*) From tblVideoStatistics)
Print...more >>
How can I return value Temperature in MS SQL when RowID is Maximun for every HeatNo Posted by Eng Teng at 8/18/2007 12:00:00 AM Anyone please help ?
How can I return value Temperature in MS SQL when RowID is Maximun for every
HeatNo
Example : Tbl
HeatNo Temperature RowID
132178 1515 1
132178 1535 2
132178 1552 3
132178 1540 ...more >>
Getting enviroment variable in TSQL script Posted by Steve at 8/18/2007 12:00:00 AM Hi All
How do you pass a drive letter etc to a TSQL script? (SQL Server 2005
express)
I attach a database during installation of my windows program, however I
don't always know which drive MS windows is installed on
The following code works fine if windows is on C drive
How can I ens...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Divide text into vchar Posted by mos at 8/18/2007 12:00:00 AM Hi!
I have a data of text£¬it's size below 16k, but vchar's max length is 8k,
so I choose sqlserver's TEXT. but sometimes(may be 5%) update this data is
slow -- in 200,000 rows update a row will cost 200ms-600ms. through select
is always fast.
name vchar index
data TEXT
and sql...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |