2003-05-02
2 reads
editorial
RE: Wholsesale conversion of char to varchar?
(deleted duplicate post) Edited by - JCMichael on 05/02/2003 09:09:55 AM
2003-05-02
RE: Wholsesale conversion of char to varchar?
(deleted duplicate post) Edited by - JCMichael on 05/02/2003 09:09:20 AM
2003-05-02
RE: Connecting from Crystal Reports
Build the SQL String using the SP name and all parameters then put where you normally insert the Query string in the code. Works just fine.
2003-05-02
1 reads
RE: Wholsesale conversion of char to varchar?
I once wrote scripts to do this. At the moment I can only find the trim script: select 'update ' + o.name + ' set ' + c.name + '=RTRIM(' + c.name + ')' from syscolumns c, sysobjects o where o.id=c.id and c.xtype=167 and o.type='U' order by o.name,c.name This generates the script that does the […]
2003-05-02
Blogs
T-SQL Tuesday #176: That Piece of Technical Advice for the Past Me
By DataOnWheels
DIVERSIFY! We devote a lot of time to mastering the technology that we are...
So You Want to Deploy Power BI Project files (PBIPs)?
By Angela-Henry
Have you heard the news about the new Power BI Project files? Okay, maybe...
DBAs, Organizing Your SQL Scripts in Git
By Steve Jones
I wrote an article that was published on SQL Server Central on how to...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers