Search results for "title"

Your search for "title" returned 100 results:

Technical Article

Format to title case

  • Topic

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

You rated this post out of 5. Change rating

2003-01-29

2,015 reads

Technical Article

how do I show sub report title on the main report?

  • Topic

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 […]

You rated this post out of 5. Change rating

2018-08-01

352 reads

Technical Article

SQL Data puller - good job title?

  • Topic

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 […]

You rated this post out of 5. Change rating

2017-02-02

98 reads

Technical Article

Restarting SQL Server Instance from SSMS Error

  • Topic

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 […]

You rated this post out of 5. Change rating

2016-10-14

1,551 reads

Technical Article

Chart Title font-different styles (SSRS)

  • Topic

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 […]

You rated this post out of 5. Change rating

2010-08-04

157 reads

Technical Article

easy, very easy to answer

  • Topic

STEP 2 (THIS IS FROM KHANACADEMY) Maybe your friends only like singing either recent songs or truly epic songs. Add another SELECT that uses OR to show the titles of the songs that have an 'epic' mood or a release date after 1990. CREATE TABLE songs ( id INTEGER PRIMARY KEY, title TEXT, artist TEXT, […]

You rated this post out of 5. Change rating

2015-10-02

472 reads

Blogs

Query deadlock info in Azure SQL DB

By

A couple of weeks ago, a developer came to me and wanted to know...

MSSQL Database Property LastGoodCheckDbTime to Get the Last Successful DBCC CHECKDB on a Database

By

Database Property LastGoodCheckDbTime to Get the Last Successful DBCC CHECKDB on a Database As one...

Dynamic Warehouse & Lakehouse Connections in Microsoft Fabric Data Pipelines

By

When you develop data pipelines in Microsoft Fabric (the Azure Data Factory equivalent in...

Read the latest Blogs

Forums

Baseball Everywhere

By Ryan Booz

Comments posted to this topic are about the item Baseball Everywhere

How to run custom python module on SQL Server?

By yyang5823

I am working on a small test script on SQL server 2022 using python...

Upgrade to SQL2019 from 2012 Query is taking time, Need Query Optimization steps

By ralahari

Upgrade to SQL2019 from 2012 Query is taking time, Need Query Optimization steps and...

Visit the forum

Question of the Day

Sensitivity Ranks

I want to use the ADD SENSITIVITY CLASSIFICATION DDL to mark some columns in my SQL Server 2022 database as PII. Can I use this code?

ADD SENSITIVITY CLASSIFICATION TO dbo.sales.price,
    dbo.sales.discount
WITH (
    LABEL = 'Highly Confidential',
    INFORMATION_TYPE = 'Financial',
    RANK = 'INTERNAL ONLY'
);

See possible answers