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,846 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
679 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
337 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,511 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,497 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,108 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,349 reads
2018-04-04
389 reads
Blogs
Bicep Your Elastic Jobs
I posted on Terraform and Azure SQL last year but wanted to see what...
3rd Party Applications Have Issues
By Kevin3NF
As a SQL DBA, what do you do when a vendor application has performance...
Check Azure SQL DB Space Used
A couple of days ago I was doing some cleaning on some Azure SQL...
Forums
Database Dashboards in Azure Data Studio
Comments posted to this topic are about the item Database Dashboards in Azure Data...
SSRS Web Service URL - getting rid of HTTP
Not sure if this is the place to ask, but will give it a...
SQL Server software and windows version compatibility level
Is there a specific platform or website where I can verify the compatibility between...
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