this is typically how i do it.

1. do a full backup, just in case.

2. SELECT the rows that in theory, should be affected...we might get a specific row count...

Shadab Shah (12/21/2012)

---

Al right .But they are totally different object . I mean to say one is a table and another SP. So that means you are saying that i...

That is an expected error that you will get used to once you get started with SQL.

object names must be unique, otherwise the system cannot map your queries to the...

wow, thats going to be tough;

the only thing i could think of was a combination of opc.three's example, and joining it against a list of common suffixes to find potential...

I've seen that situation where they are using CHAR(160) , which is a fixed width character that *looks* like a space, but isn't a REAL space (CHAR(32))

if you use that,...

there's a couple of script contributions:

there's several threads on the same subject as well.

http://www.sqlservercentral.com/search/?q=number+to+words

garth i could not get a result to work the way you said; we would need something equivilent to this to test with:

With TableA (,col)

AS

(SELECT 1,'1308064*8' UNION ALL

SELECT 2,...

UPDATE SET [col] = [col]

Seriously? that is the trigger body? updating the column to itself, with referencing the INSERTED virtual table?

Remember we are not in your cube looking...

Minnu (12/20/2012)

---

Am having a table called products with 4 columns, whenever any new insert or update happens,

column "Product_Name_Expiry" will be udpated with prouduct_Name : Product_expriry_date.

IDProduct_NameProduct_Expiry_Date ...

something like this?

note you have to modify the role everytime a proc/function is dropped and created, or new ones added.

CREATE ROLE MyExecProcRole;

CREATE ROLE MyExecFuncRole;

--GRANT EXEC permissions to all SPs and...

If the Mayans were so good at predicting the future, wouldn't there still be Mayans left?

yes exactly...listing the specific columns, which would of course be unique to your table and text files.

for your other question, i don't see any value to fiddling with the data...

well, one way is to use the delimitedSplit8K function to chop the string into bitesize peices.

from there, you might need to cross apply, modifying the WHERE statement to limit it...

well it depends on the details Brian;

in situations where the target table does not exactly match the columns (different column order, subset of columns)

you can attack it a different way:...

BULK INSERT works well, BCP IN,The Import DaTa Wizard or a full blown SSIS package are your options I can think of offhand.

here's a simple example of bulk insert:

CREATE TABLE...