Search results for query: *

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...

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...

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

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...

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...

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

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?

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...

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

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

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...

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...

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...

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...

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...

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

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

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...

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

Great stuff. Thanks John