since this is a one time update, i would not create the defaults inside a cursor;

i would just generate the sql, and run it once.

this gets similar results, but without...

well mine calculates the max row size, but it would be misleading for for tables that have a varchar(max) columns, since their size is -1...when it is really what,a...

It sounds like you are thinking every table has an owner the way Oracle works; since SQL 2005, that's not true any more.

now everything is part of a schema, and...

it sounds like you want to know the last command a spid happened to issue...in your case you think it was a stored procedure:

SELECT SDEC.[most_recent_session_id],DEST.TEXT

FROM sys.[dm_exec_connections] SDEC

CROSS APPLY...

i have this saved in my snippets; it is slightly different from the formula you pointed to, but you could change it easily:

select object_name(object_id),sum(max_length) from sys.columns group by object_id

oh you can generate the CREATE TABLE script via TSQL; it's just like so many things in SQL Server, the answers are spread out everywhere, and you have to put...

i think the entire path+file must be in dbl quotes, not just the filename;

copy "c:\SQLOldFiles\TestRemainderFile.txt" c:\SQLNewFiles

interesting David;so it would jsut be the html for <title></title>? and you want to make sure it doesn't have things like > instead of & g t ; in...

here's an example of how two seemingly different queries can be combined as a function without using dynamic sql;

the param being passed decides which results to return. this might give...

i'd want to see the proc, i's quite possible whatever you are doing does not have to be done with dynamic sql.

it's possible to create a view that has...

glad i could help!

yes you can; the correct syntax is below;

note i added a suggestion to make it cleaner and easier to read:

select

CASE

WHEN SCE_AYRC = '05/06' AND C.MAV_BEGW IN('36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52')

THEN '06/07'...

i think this will do what you are after; this leaves 0-9,A-Z,a-z and strips out everything else...commas,punctuation, hi ascii, etc.

select dbo.StripNonAlphaNumeric(address1) from #addr

--results

53240thaveneapt104

1000sectorwaystapt111ac

3333summerpointplace

pobox22000a330042

5566firststettnlot204aapt2c

select ascii('a'),ascii('z'),ascii('A'),ascii('Z')

GO

CREATE FUNCTION StripNonAlphaNumeric(@OriginalText VARCHAR(8000))

RETURNS VARCHAR(8000)

BEGIN...

this is a common security issue. The problem is that when you access any resource OUTSIDE of SQL server, like network shares, local hard drives,sp_OA type functions etc, it doesn't...

mikelordi2 (3/23/2010)

---

We are int he process of implementing a new procedure whereby we take client flat files, perform transformations on the data using both derived functions as well as reference...