If cleansing is done in front-end, it would be better...

If take it a bit more serious, you better to be careful...

The given definition of the table has Column(varchar(20). Is any guarantee that the values there will contain only...

SQL does exactly what should be done in mathematics:

5 - 2 + 3 = 5 + (-2) + 3

Now you can see that it's absolutely doesn't mater what...

And if the BIGINT is not big enough for you, use DECIMAL(38)

It can handle numbers upto:

99,999,999,999,999,999,999,999,999,999,999,999,999

🙂

This one should work in SQL, you may have something else wrong in the query. Try to clear everything before and after your statement...

Jeff Moden (7/4/2012)

---

craig-962225 (7/4/2012)

---

I don't have access to the function right now but will try to post it later... When I say simple I really mean the call is simple....

Also to note from MS:

Using SET ROWCOUNT will not affect DELETE, INSERT, and UPDATE statements in the next release of SQL Server. Avoid using SET ROWCOUNT with DELETE, INSERT, and...

Agree, but that is impossible with "raw native SQL" at the moment as there is no such "raw native" in-build...

I would suggest creating and using CLR function. The base for it you can find here:

http://www.c-sharpcorner.com/uploadfile/b942f9/converting-numbers-to-words-in-C-Sharp/

You can enhance it to support any numbering style. Also, it's possible to reuse ...

Large? May be. But definitely not an international ones. Otherwise you would...

From that:

and that:

...need a query, where I pass on a list of Subjects, and the minimum number of students...

Another version will work for any DBName and any combination of object name parts used:

CREATE FUNCTION dbo.f_DBRenameX ( @OrigString VARCHAR(100)

...

What about this one:

CREATE FUNCTION dbo.f_DBRename ( @OrigString VARCHAR(100)

...

SELECT REPLACE('Newdb.[DBName].dbo.TableName','DBName','ReplacedDBName')

Or it's something else you are after?

ANSI-92