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

1,909 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

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

345 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,522 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

Backup/Restore permission

  • Topic

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

You rated this post out of 5. Change rating

2008-06-30

8,560 reads

Technical Article

Missing SSISDBBackup.bak

  • Topic

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

You rated this post out of 5. Change rating

2017-05-08

21,195 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

470 reads

Blogs

Writing Parquet Files – #SQLNewBlogger

By

Recently I’ve been looking at archiving some data at SQL Saturday, possibly querying it,...

A word about IT/cybersecurity and mental health

By

Just as it's important to take care of our physical health (and I'm guilty...

Are ABORT_AFTER_WAIT's victims logged?

By

In SQL Server, using the KILL command to terminate a session results in an...

Read the latest Blogs

Forums

Can you connect Power Apps to SQL Server if you work in the government?

By JJ B

My agency has been using the combo of on-premises SQL Server for the back...

Unable to connect to SQL 2019 using Pyodbc

By yyang5823

Development Environment I am learning how to use pyodbc and accessing database in SQL...

Multiple deadlocks occurring with contentious code

By zoggling

We are seeing multiple frequent deadlocks occurring with the following extract of code, which...

Visit the forum

Question of the Day

Multiple Query Trace Flags

I want to enable two trace flags, 4199 and 4137, for a single query. How should I do this:

-- A
SELECT
  a.AddressID
, a.AddressLine1
, a.AddressLine2
, a.City
, a.StateProvinceID
, a.PostalCode
, p.FirstName
, p.LastName
FROM
  Person.Address a
  INNER JOIN person.Person AS p
    ON p.rowguid = a.rowguid
WHERE
  City           = 'SEATTLE'
  AND PostalCode = 98104
OPTION (QUERYTRACEON 4199, 4137);

-- B
SELECT
  a.AddressID
, a.AddressLine1
, a.AddressLine2
, a.City
, a.StateProvinceID
, a.PostalCode
, p.FirstName
, p.LastName
FROM
  Person.Address a
  INNER JOIN person.Person AS p
    ON p.rowguid = a.rowguid
WHERE
  City           = 'SEATTLE'
  AND PostalCode = 98104
OPTION (QUERYTRACEON 4199, QUERYTRACEON 4137);

-- C
SELECT
  a.AddressID
, a.AddressLine1
, a.AddressLine2
, a.City
, a.StateProvinceID
, a.PostalCode
, p.FirstName
, p.LastName
FROM
  Person.Address a
  INNER JOIN person.Person AS p
    ON p.rowguid = a.rowguid
WHERE
  City           = 'SEATTLE'
  AND PostalCode = 98104
OPTION (QUERYTRACEON 4199), (QUERYTRACEON 4137);

See possible answers