Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Giddygoat

    Unit Testing

    I'm working on a small php mysql project for a local university, I'm really keen to use the project to test out some agile development practices, particularly iterative development and test driven development. I'm looking for advise on unit testing tools, which ones are out there, which are...
  2. Giddygoat

    Running Rules on the Server?

    Please excuse my ignorance, I'm proberbly using all the wrong terms. I have rule set up in Outlook that are triggered when I send or recieve an email, what I'd like to do is trigger a rule when an email is recieved by exchange. I want to send a copy of all email sent to or recieved from anyone...
  3. Giddygoat

    All my tasks

    If I've been tasked to do something at Site 1, Site 2 and Site 125 can I get a single view of all my tasks? Ideally I'd like to see it all in "My Site
  4. Giddygoat

    Viewing content from more than one site - posible?

    I'm messing around with sharepoint with the goal of trying to organise a group of sites so that it mirrors the operationals and project views of our team. Thinking about documents only.... I want to have a site for each project which stores all project documentation (in my case requirements...
  5. Giddygoat

    HTML tags in excel

    Hello I generating an excel worksheet from via a web application. Some data is "rich text" and stored with html tags. When I open the spreadsheet the tags are shoen in plain text i.e. <b>Look at this</b> instead of Look at this Is there a setting in excel that can cause the html tags to be...
  6. Giddygoat

    Generate Table Script

    I need to generate insert statements. I've found tools to do it for Oracle and My SQL but not SQL Server
  7. Giddygoat

    Generate Table Script

    In Enterprise Manager I can create a SQL scripted version of my schema. I.e. the script will generate CREATE TABLE and constraints, indexes etc. What I'd like to do is create the schema along with its data. INSERT INTO myTable ...... for all of the data in the schema. Any ideas?
  8. Giddygoat

    Supressing Query Output

    I'm creating a database upgrade script. I want to output a header line for each item in the upgrade script and turn off all other output except errors. Some of the people who run the upgrade scripts get nervous when they see warnings etc. And it is also a pain for our tech support to have to...
  9. Giddygoat

    Supressing Query Output

    Hello I was wondering if it is possible to suppress the following output when I run an "EXEC sp_rename ......" The COLUMN was renamed to 'Baseline_Value' My aim is to suppress all messages except for error messages. I already use SET NOCOUNT ON. Any ideas?? John
  10. Giddygoat

    Sql- Column Headers

    Can this be done programmatically, like SET NOCOUNT removes the rows affected output, is there anything to remove the column headers?
  11. Giddygoat

    IMP - Importing a table.

    Thanks for your replies. Our problem is that our clients have production databases that where upgraded a while ago, unfortunately we made a bit off a gaff and need to cleanse the live data in a table using data from a table in the export file that the clients made before the last upgrade. We...
  12. Giddygoat

    IMP - Importing a table.

    Hi I want to import a table from an old version of our database into our current version. imp <user>/<password>@<oraname> file=<exportfile> tables=table1 full=n The problem is that I want to import the table with a new name. i.e. table2. The most obvious solution is to rename the table once it...
  13. Giddygoat

    Performance loss when upgrading v7 to 2000

    tlbroadbent, our right I didnt mean to put the cross join in, I can't use INNER JOINS and EXISTS because the SQL must also work in ORACLE. I have run sp_updatestats and it did make a difference. I did change the &quot;OR b in (SELECT b&quot; on line 7 of the origanal query with &quot;UNION...
  14. Giddygoat

    Performance loss when upgrading v7 to 2000

    I have some queries that look something like this. SELECT a, b, c, d..... FROM table1, table2 WHERE a = 1 AND b in (SELECT x FROM table3 WHERE x = i) OR b in (SELECT y FROM table4 WHERE y = j AND k in (SELECT x FROM table5...
  15. Giddygoat

    HELP 'Warning: Procedure created with compilation errors.'

    Why do I get a warning when I run this code? CREATE OR REPLACE PROCEDURE EnvoyDropTable (envoy_table_name in varchar2) AS v_rows NUMBER; BEGIN select count(*) into v_rows from all_tables where table_name = envoy_table_name AND owner = 'ENVOY'; if v_rows <> 0 then drop...
  16. Giddygoat

    Can I suppress output from SQL statements?

    Is there a way to suppress the output from statements such as SP_RENAME and CREATE INDEX. I am using SET NOCOUNT ON to suppress some of the output in my scripts. Ideally I only want errors to be reported back when the script is run. Can anyone help? John
  17. Giddygoat

    Oracle equivalent of SQL Server NOCOUNT?

    Is there such a thing?. For those who dont know what SQL Server SET NOCOUNT ON does, it stops the positive messages such as the '3 rows updated.' from the output. Cheers John
  18. Giddygoat

    Opening a Recorset with adCmdTable option

    When I open a recordset with the adCmdTable option does the whole table get loaded into memory? With rs .CursorType = adOpenKeyset .LockType = adLockOptimistic .Open &quot;A_BIG_TABLE&quot;, sConnect, , , adCmdTable End With Or does ADO only get the daya when I...
  19. Giddygoat

    Validate string as a Meta Tag

    Hi I need an algorithm to check a text string is a valid <Meta> tag. Has anyone come across scripts which validate HTML? Cheers John
  20. Giddygoat

    Can I Query which tables have columns with a CLOB data type?

    Great stuff. Thanks John

Part and Inventory Search

Back
Top