|
|
|
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 Analysing Execution plan Posted by Ramnadh at 3/21/2004 11:02:35 PM Hi,
I am new in the SQL Server 2000. As i am writing the
Stored Procedures for the tables that contains millions of
rows in them those stored procedures were taking lot of
time. To evaluate where the time is taking, i doesn't
understand the Query execution plan properly. can anyone
sugg...more >>
specifying date param values in dynamic sql Posted by John A Grandy at 3/21/2004 9:43:29 PM when building a t-sql string , what is the preferred method to convert a
datetime parameter to a string ...
i could imagine doing it like this : (MyDateTimeCol is a table column of
type datetime)
set @sql = @sql + 'MyDateTimeCol = ''' +
convert(varchar(10),@MyDateTimeParam,101) + ''''
i...more >>
Follow up query from Fresher - Aaron Bertrand Posted by Alok at 3/21/2004 9:19:26 PM Hi Aaron,
Thanks for the URL and the inputs. What do you think is a
good book to learn **Basic Relational Database
Theory**.please suggest in view that I am a Bran New guy
for SQL and RDBMS.
Regards
Alok
>-----Original Message-----
>For SQL Server, see http://www.aspfaq.com/2423
>
...more >>
Sort of a loop in SQL - how to do it Posted by Franz Haberl at 3/21/2004 8:21:56 PM Hello!
I have a table with just a few fields like this:
Name ActionID TimeInterval (seconds)
---------------------------------------------
x 1 20
y 2 10
z 3 15
q 3 ...more >>
Stored Procedures WITH ENCRYPTION Posted by Chip at 3/21/2004 8:13:00 PM Dear folks,
I am planning to Encrypt all the user Stored Procedures
for protecting my code, as the Database is running at a
client site. What are the pros and cons.
Thanks for your valuable time.
Regards
Chip...more >>
share using SQL Server Posted by Frank Dulk at 3/21/2004 7:03:49 PM Do I have a server with fixed IP working and did need to configure SQL
Server so that other personal computer accessed base of data it is REMOTELY,
for the what do I know two forms they exist, do the famous and simple "
REMOTE CONNECTION OF AREA OF WORK " put quite slow OR does share using SQL
S...more >>
Probably simple question. Posted by Vlad at 3/21/2004 4:42:24 PM I need to create Crystal Report based on SQL Server stored procedure which
accepts 3 parameters (@AccountID INT, @DateMinimum SMALLDATETIME,
@DateMaximum SMALLDATETIME) and returns records from several tables. On
report I need to display the Name of Account (Actually in this case it's
Supplier) ...more >>
Stored Procedure Resultsets? Posted by SMK at 3/21/2004 4:26:07 PM Hello
I am having a problem with the performance with when calling store
procedures. I have to do a large number of inserts/updates to a table, s
speed is a big factor. Here is one of my simplified stored procedures I a
using for testing
ALTER PROCEDURE dbo.I7PROCaddAnalog(@p_Analog_Id CH...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Increment int values Posted by Andrew Banks at 3/21/2004 3:24:58 PM Is it possible to increase an int value in SQL without having to read the
current value first.
I know I could reade the current value, add 1 to it and UPDATE with the new
value but this involves multiple queries to the DB.
Is it possible to just increment the value through SQL?
Thanks,
A...more >>
Loop for Quantity Posted by Mike at 3/21/2004 12:57:37 PM This is a continuation of the post yesterday. I think I
need to do a While statement somehow, but there isn't
enough info in the HELP. Any code help is greatly
apprecianted.
Here is the senerio i'm dealing with...
If someone buys 3 tickets it only creates one line. The
report writer...more >>
Copy/move data from TableA in DB1 to TableB in DB2 within the same SQL Server Posted by omooba at 3/21/2004 12:11:07 PM Hallo
I thouhgt it would be easily done, but no. I have a copy of data i saved in another DB while laying out the original Database i want to use in producton Envi. The Prodution DB is finally ready and i want to move the 3 columns of data in the first Databse into a table in the new database. ...more >>
Sql 7.0 -> 2000 update query hangs Posted by Dave at 3/21/2004 12:07:32 PM Hi,
We have just upgraded a server from SQL7.0 to SQl2000. Now, select queries
through a SQL7.0 linked server to this server work very fast but any update
query, no matter how simple, hang indeterminately.
Does anyone have any experience of this - is there a simple solution?
Thanks,
Dav...more >>
Calling SQL SP from VB code Posted by Mario Splivalo at 3/21/2004 11:35:33 AM What is the best way on calling the parametrized stored procedures that
reside on MS SQL server from Visual Basic. Stored procedure returns a
recordset (used by report)
I'm using Visual Basic 6 SP5 with MDAC 2.8 on WinXP.
I know I can just open the Connection object, and then do the .Execute...more >>
sybase newsgroup Posted by sam at 3/21/2004 10:51:07 AM Good afternoon,
I am a sql server 2000 developer, and since while working
on sybase, and having very hard time configuring sybase
user group, if anybody here familiar with sybase.
Any help is highly appreciated.
Thanks,
sam...more >>
Help with SET NOEXEC in a SPROC Posted by paul reed at 3/21/2004 8:10:25 AM Hello,
I need to validate whether a dynamically generated SQL statement is valid or
not. In another post it was suggested I use SET NOEXEC ON. I have tried this
but I must be doing something wrong. My sproc is below. I am not clear where
and how I return the error message back so my business l...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |