Format to title case
I need to convert all the columns in a table from upper case to title case. Does anyone know how to do this? I know Access has a format function but I haven't found a way to do this in SQL. Thanks Angela
2003-01-29
1,847 reads
Search results for "title"
Your search for "title" returned 100 results:
Adding Report parameter to Chart Title
Not sure whether it’s possible in SSRS 2005 to add Report parameter (like Customer name) to Chart Title? Thanks
2007-12-13
680 reads
SQL Data puller - good job title?
Hi all! I'm having some trouble finding the correct terminology for the job that I do. Basically, I use sql to pull and organize data for a team of analysts. We are called Data Analysts here, but looking around the job world, that's not really what we do. Dats Puller isn't a popular title with […]
2017-02-02
96 reads
how do I show sub report title on the main report?
I sure hope this makes sense: I have one main report with three sub reports. There are three links on the main report to each of the sub reports. Clicking one of the links will display that sub report within the main report and only one sub report can be displayed at a time. I […]
2018-08-01
338 reads
Chart Title font-different styles (SSRS)
Just got new request from Management- apply different fonts (size/color) for different Chart Title parts. For example, chart title is "Report Chart Title". Can we show word "Title" in different color and size? There is function button but frankly I have no clue how can I use it in this case? Any help is much […]
2010-08-04
155 reads
Restarting SQL Server Instance from SSMS Error
Just installed a new SQL Server 2014 instance. When I try to restart the sql server instance in SSMS by right-clicking and choosing restart, I get the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Unable to restart service MSSQL$SQLSERVER on server SQLSERVER. (mscorlib) ------------------------------ ADDITIONAL INFORMATION: The object invoked has disconnected from its […]
2016-10-14
1,512 reads
Backup/Restore permission
Hi there, I want to dedicate a person (eg. 'BackupManager') who can only performce backup and restore certain databases. At BackupManager's properties I had checked db_backupoperator. When I login using BackupManager and perform backup, at the add backup destination I receieve an error message like below (similarly to restore), Can anyone help? TIA
2008-06-30
8,507 reads
Missing SSISDBBackup.bak
Hello Team, My concern is as followed:I've built a project with SSDT 2015 then I would like to deploy the package it in SSMS 2016. However, the error message was that there was no SSISDB.I went to SSMS2016 to create the catalog (right-clicking - Integration Services Catalog). The error message was: TITLE: Microsoft SQL Server Management […]
2017-05-08
21,113 reads
Transactional Replication :: Error Creating New Publication
Attempting to create a new publication and received this error: Ran a DBCC OPENTRAN on both the server that's creating the publisher and on the distribution server - there were no open transactions. Any ideas out there?
2011-12-16
4,351 reads
2018-04-04
389 reads
Blogs
Migrate datetime data to datetimeoffset with AT TIME ZONE
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
The Comprehensive Guide to Mastering Your SQL DBA Skills
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
Friday Basics: Authentication vs. Authorization
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Forums
The OS returned the error '(null)' while attempting 'DeleteFile' filestream.hdr
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Performance
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
Question of the Day
Two Table Hints
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers