|
|
|
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 |
Index's Posted by Phil at 1/31/2005 9:13:05 AM Hi All
Another quick question, is it possible to put a index on a temp table and if
so what is the syntax.
Thanks Phil...more >>
Where statement with variables Posted by Phil at 1/31/2005 1:21:02 AM Hi All,
Just a quick question for anyone, I have a stored procedure that uses a lot
of variables in a where statement, the only problem with this is it's very
slow, I am just listing them something like this
WHERE
AND (tblSurvey.disposal_method = @disposalRoute OR @disposalRoute = 'null')...more >>
Timed Triggers Posted by Muhammad Bilal at 1/19/2005 2:37:02 PM Hi.
Is it possible to fire a trigger on a specific time i.e. when the system
time is 1200 hrs(for eg) , trigger fires automatically and run a script
Regards,
Muhammad Bilal...more >>
Parameter Queries in Analyser Posted by Sam at 1/17/2005 6:51:05 AM Real new person question here but during my query practise I created some
parameter queries in the enterprise manager however theses will not work when
I open query analyser. Can anyone tell where I’ve boobed?
Many thanks
Sam
...more >>
Track changes made to existing stored procedure Posted by samy at 1/13/2005 10:59:04 AM how can I keep track of who is making modifications to a existing stored
procedure.
thanks
samy...more >>
Describing a table structure Posted by Jig Bhakta at 1/13/2005 9:11:02 AM Hi,
I would like to know the syntax in MS SQL 2K for describing a table, without
having to expand everything in the object browser.
I know in Oracle it is: desc <table_name>;
Thanks,
Jig....more >>
Update query SQL2000 Posted by Newbie at 1/13/2005 8:55:18 AM Hi
I am trying to write an update query that update the BG1 field in the
Customer table with the BG value in the Agreements Table from a different
database.
Here is what I have so far . . . but it doesn't work - I get the error
Server: Msg 8152, Level 16, State 2, Line 1
String or binar...more >>
Extrating Data from One Database from Another Posted by Steve at 1/10/2005 10:03:03 AM Hello,
I am new to sql (very new).
I have two database, let's call it database1 and database2.
Both database contains last name, first name and address information.
Database1 has approximatley 12000 records and database2 has approximately
2000 records. Here is what I am trying to accompli...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Problem Transact-SQL Statement Posted by Allen Yu at 1/7/2005 12:53:00 AM I've come across a Transact-SQL statement as follows:
-- Statements start here
select 'EXECUTE sp_changeobjectowner ''' + name + ''', ''dbo''' from
sysobjects where type = 'U'
-- end here
Questions:
(1) How should the 'select' statement be interpreted?
(2) What are the rules for u...more >>
Parameter Query Posted by pjscott at 1/4/2005 6:47:03 AM I'm using sql 2000 and Access 2002. I need to create a parameter query that
would ask the following statement: "Enter the work order number".
How would I do this in sql?
Thanks for the help,
Paul...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |