there's a great article on SimpleTalk on the subject.

it's got examples of doing it two ways, via opendatasource and also Excel Automation via sp_OACreate and stuff;

this article is doing it...

man this is really interesting, but the rabbit hole is getting deeper and deeper.

if you send an email via sp_send_mail with SECURE in the subject, does your Exchange Server encrypt...

Micrsofot has a couple of Migration Assistant tools to help you migrate Oracle to SQL Server (and another one for MYSQL to SQL Server)

http://www.microsoft.com/sqlserver/2005/en/us/migration-oracle.aspx

another alternative, if it is just a...

the critical part is adding the WHERE statement...some of your data does not contain a comma...

you want to exclude those items

--items with the offending command and extra data

SELECT LEFT(NAME,CHARINDEX(',',NAME)-1 )

FROM...

here's an example of what Wayne refered to:

With MySampleData as

(

SELECT 'Support Centres , Miscellaneous SC' As TheName UNION ALL

SELECT 'Support Centres , Care of tracey Whitehall' UNION ALL

SELECT 'Support Centres...

i believe the calculated column has to be dropped and recreated as a new calculated column.

i just tried this as a proof of concept, and I get a syntax error...

you might not be able to do this in the trigger; you can get only the first 256 characters of the entire commnad...so a long command would get truncated in...

I think that parameters just adds a little used flag to the headers stating the "sensitivity", like confidential;...

--Midnight for the Current Day

select DATEADD(dd, DATEDIFF(dd,0,getdate()), 0)

I commend you for wanting to stay within the same datatype and not converting to a varchar.

this is one of the coolest things...

one of the companion views is sys.columns; so you can join sys.tables (for jsut tables) or sys.objects if you want views and tables:

select

tab.name as TableName,

col.name...

well, the proc writes to a database, so i guess if you added your extended property info to the master database, you could assume it's for the server, right?

i think it's just a combination of integer division and modulus:

/*--results

MinutesSeconds

2571

210

*/

--example where value is an integer of seconds

...

thank you very much for the feedback and correction;

at one point the original script was pointing at the old compatibility tables like syscolumns; that badly named column is a legacy...

Doc what you want to do is the insert as a single SET based operation, which might insert 5K's worth of records, all in one fell swoop;

It's actually easy, it's...

usually you'll find the ROW_NUMBER function will do the trick for you here;

uncomment out the outer SELECT to limit it to just one row, i left the full results as...