Viewing 15 posts - 1,381 through 1,395 (of 2,894 total)
...
What you say is true, of course we could hope that the front end would take care of such cleansing issues.
...
If cleansing is done in front-end, it would be better...
August 10, 2012 at 3:41 am
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...
August 10, 2012 at 3:30 am
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...
August 10, 2012 at 3:14 am
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
🙂
August 10, 2012 at 2:55 am
This one should work in SQL, you may have something else wrong in the query. Try to clear everything before and after your statement...
August 10, 2012 at 2:48 am
Jeff Moden (7/4/2012)
craig-962225 (7/4/2012)
July 4, 2012 at 9:22 am
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...
July 4, 2012 at 7:14 am
... Doing it with raw native SQL provides the maximum portability.
Agree, but that is impossible with "raw native SQL" at the moment as there is no such "raw native" in-build...
July 4, 2012 at 7:08 am
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 ...
July 4, 2012 at 6:37 am
... As a result of this approach we were able to convert an 12 large client server style systems....
Large? May be. But definitely not an international ones. Otherwise you would...
July 4, 2012 at 6:30 am
From that:
Kaptnik (7/3/2012)
... Each student can have up to 2 favorite subjects...
and that:
...need a query, where I pass on a list of Subjects, and the minimum number of students...
July 4, 2012 at 6:23 am
Another version will work for any DBName and any combination of object name parts used:
CREATE FUNCTION dbo.f_DBRenameX ( @OrigString VARCHAR(100)
...
July 4, 2012 at 6:11 am
What about this one:
CREATE FUNCTION dbo.f_DBRename ( @OrigString VARCHAR(100)
...
July 4, 2012 at 6:03 am
SELECT REPLACE('Newdb.[DBName].dbo.TableName','DBName','ReplacedDBName')
Or it's something else you are after?
July 4, 2012 at 4:57 am
Viewing 15 posts - 1,381 through 1,395 (of 2,894 total)