|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |||||||||||||||||||||||||||||
The Long String | |||||||||||||||||||||||||||||
I have a table (dbo.beer) with this data:
CREATE TABLE [dbo].[Beer] ( [BeerID] [int] NOT NULL IDENTITY(1, 1), [BeerName] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [brewer] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [beerdescription] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GOI run this code: SET TEXTSIZE 20; SELECT b2.BeerName , b2.beerdescription FROM dbo.Beer AS b2; GOWhat is returned? | |||||||||||||||||||||||||||||
Think you know the answer? Click here, and find out if you are right. |
Yesterday's Question of the Day (by Steve Jones - SSC Editor) |
The User Login When I create a user in a SQL Server 2022 database, on which types of logins in the master database can it be based? Answer: a Windows AD account, a Windows AD Group, a SQL Auth login, or a Microsoft Entra login (email) only Explanation: In the master database, these types of logins are supported as the basis for creating a user.
A user based on a certificate can't log in but can be granted permissions and can sign modules. Ref: CREATE USER - https://learn.microsoft.com/en-us/sql/t-sql/statements/create-user-transact-sql?view=sql-server-ver16 |
Database Pros Who Need Your Help |
Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2016 - Administration |
Changing Machine Type - Hi, presently my azure server running under Standard_D64ds_v4 .i am planning to upgrade the server . can you please help me what is next configuration . |
SQL Server 2016 - Development and T-SQL |
How to get result from deleted row - Hi Guys I have a store proc that delete a row from a and I would like to get the result of the deleted row whether be =1 or True in order to execute another store proc. Could this be possible? ---- I am aware this code won't work I am trying to explain what […] |
Joining against min date only - This is one of those things very hard (for me)to explain in words. See image below, the requirement is assign all of the sales with Reqdate prior to the "Best Before Date" but ONLY the earliest "Best Before Date." I am trying to do this only with T-SQL. My full scenario is of course more […] |
Union where it matches against only one shared column - Hi folks I have two tables, both with a NAME, START and END fields I'd like to list all of the rows from Table A, and then only the rows from Table B where only the START does not exist in Table A. The NAMES in Table B will ALWAYS be different from those in […] |
Administration - SQL Server 2014 |
sqlagent issue - could not find the procedure msdb.dbo.sp_get_sqlagent_properties agent not visible |
sql agent issue - getting this error. could not find the procedure msdb.dbo.sp_get_sqlagent_properties and also this error cannot find column msdb or user defined function or aggregate msdb.dbo.fn_syspolicy_is_automation_enabled or name is ambiguous. how to fix this |
SQL Server 2019 - Development |
what etl tool are folks moving toward? - Hi as we replace on prem machines , sometimes not with vm's, what should we be thinking about for etl? from my little corner of the world where we use both talend and ssis, and where talend is getting costly, and where ssis is slowly being squeezed into a call from data factory to an […] |
How to update using data from three tables? - I am in the process of migrating from MySQL to SQL Server. I have tables like this: create table OldTable ( id int primary key, tagpath varchar(255), retired bigint ) create table DataTable ( tagid int not null, tagValue float ) create table NewTable( id int primary key, tagpath varchar(255), retired bigint ) The DataTable.tagid […] |
temp table columns not showing up in CTE - I'm new to the development side of the house and stuck on a CTE issue. In the CTE data is pulled from a temp table. There was a request for more columns, so I added them. Everything works, but the columns don't show up in my CTE results? What am I overlooking here? Thank you […] |
General |
Count of Distinct Values - Hi If value is 21000030 it should return 4 not 5 . In first record 21000030 exists 2 times 21000032 then it should return 3 not 4. USE [Live] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[OCRD]( [CardCode] [nvarchar](15) NOT NULL, [Emp_1] [nvarchar](10) NULL, [Emp_2] [nvarchar](10) NULL, […] |
Analysis Services |
SSAS Cube Migration to Azure cloud - Dear All, I am currently working on a Proof of Concept (POC) where I have developed an SSAS cube with an Oracle (On-prem) source and deployed it to the SSAS server. The SQL DBA team is now planning to migrate the SQL server to the Azure cloud. I would appreciate your suggestions and best practices […] |
SQL Server 2022 - Administration |
Sever Migration - Hi, one of my server configured with Standard_D64ds_v4 what is next level of version is it Standard_D98ds_v4 or Standard_D128ds_v4 |
How to check if credential password for TDE matches the secret key of Key Vault - Hi all, In my company we have many databases encrypted with TDE and there is some automatic process or pipeline that is not working correctly and updates the secret key in the Key Vault without applying the change also in the credential password in the SQL server. I need some help while we found this […] |
SQL Server 2022 - Development |
Select Returning Blank Rows - I have the following select statement --#1 Select supplier, s.refnum, desc from supplier as S Where s.refnum = '123456' This brings back records for me. But when I use the field name instead like in #2, I get zero rows --#2 Select supplier, s.refnum, desc from supplier as S where s.refnum in (select refnum from […] |
How to update a history table with changes. - Good morning to all. I am a novice when it comes to SQL so my question is TSQL related on how to update a history table with changes to thousands of records without a cursor. Currently here is my code with cursor. I know I can update the price for all the parts in one […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |