sql-server-2017 Questions
3
Solved
MSDN on this article says:
CLR uses Code Access Security (CAS) in the .NET Framework, which is no
longer supported as a security boundary. A CLR assembly created with
PERMISSION_SET = SAFE may...
Ephesian asked 20/5, 2017 at 7:23
6
I have a problem during the installation of SQL Server Data Tools for Visual Studio 2017
I get the following error (translated):
The requested meta file operation is not supported (0x800707D3)
...
Hypanthium asked 19/12, 2017 at 10:13
2
Encountered interesting problem after migrating to SQL Server 2017.
Absolute path test
backup database master to disk = 'C:\Temp\1\2\3\master.bak'
Backup is created in C:\Temp\1\2\3\ as expecte...
Scrimpy asked 6/12, 2017 at 0:57
5
Solved
I have a query on the SQL server
I want to display as below:
CDATE | CDAY
2019-04-01 | Monday
2019-04-02 | Tuesday
... | ......
2019-04-30 | Tuesday
But I found error as below:
Conversion fa...
Chronometer asked 26/4, 2019 at 11:17
3
Solved
Use case 1:
DECLARE @Geom TABLE
(
shape geometry,
shapeType nvarchar(50)
);
INSERT INTO @Geom(shape,shapeType)
VALUES('LINESTRING(1 2, 3 4)', 'A'),
('LINESTRING(3.2 4, 7 8)', 'B');
SEL...
Candida asked 18/2, 2019 at 4:38
9
I create temporal table in order to set level :
CREATE TABLE [#DesignLvl]
(
[DesignKey] INT,
[DesignLevel] INT
);
WITH RCTE AS
(
SELECT
*,
1 AS [Lvl]
FROM
[Design]
WHERE
[ParentDesign...
Unoccupied asked 4/3, 2019 at 18:49
3
Solved
I observed some strange behavior in MS SQL Server 2017.
+= in select acts as aggregator ('concatenate values from all rows') when on the right is a constant.
+= in select acts as 'just set ...
Penninite asked 27/2, 2019 at 6:39
0
I have a NVARCHAR(MAX) column that I use to store json data in.
What is the best way to enforce that data to comply to some json schema?
I know I can put a check constraint with a function to che...
Interfluent asked 27/2, 2019 at 10:20
3
Solved
I need to get a maximum of 3 distinct records from the same table, so currently I'm doing:
SELECT 1, mycolumn FROM mytable WHERE id = @firstId
UNION ALL
SELECT 2, mycolumn FROM mytable WHERE id = ...
Pedant asked 11/2, 2019 at 8:7
6
Solved
I'm unable to pass below rule while installing SQL Server 2017 Developer edition on windows 10 machine on Feature Rules screen:
Oracle JRE 7 Update 51 (64-bit) or higher is required for Polybase
...
Reflation asked 20/11, 2017 at 6:11
1
Solved
SQL Server objects i.e. tables and indexes have their own namespaces. So it is possible to have the same name for index and table(but it's not a common/good practice):
CREATE TABLE t(id INT PRIMAR...
Dyna asked 9/1, 2019 at 21:51
1
Say I have a column in my database called attributes which has this value as an example:
{"pages":["Page1"]}
How can I do a where clause so I can filter down rows that have "Page1" in it.
sel...
Erelia asked 3/1, 2019 at 0:6
1
Solved
I need to debug stored procedure on the local SQL Server using data stored in this server.
I have on my device:
Microsoft SQL Server 2017 Standard
Microsoft SQL Server Management Studio 2014
Mic...
Fates asked 3/12, 2018 at 14:47
2
Solved
I have a problem that I feel could be solved using lag/lead + partitions but I can't wrap my head around it.
Clients are invited to participate in research-projects every two years (aprox.).
A num...
Pogge asked 14/11, 2018 at 10:49
1
Solved
I have the following query:
WITH cteCountryLanguageMapping AS (
SELECT * FROM (
VALUES
('Spain', 'English'),
('Spain', 'Spanish'),
('Sweden', 'English'),
('Switzerland', 'English'),
('Switz...
Mitchelmitchell asked 27/9, 2018 at 9:14
2
After overcoming this and this issue my hurdles don't seem to be coming to an end.
SQL Server 2017 Developer edition installation is going on endlessly. The installer isn't coming to an end and see...
Hypogynous asked 22/11, 2017 at 10:32
4
Solved
At some point soon I'll have to prepare a list of prices of items on days. The granularity is 1 day and on days when there are sales of an item, I'll average the prices to get that day's average. T...
Lewallen asked 18/9, 2018 at 13:20
2
Solved
I set up a local database (SQL Server 2017 Express). Everything works fine, but I'm getting errors when creating even a simple stored procedure in SSMS.
For example, this
CREATE PROCEDURE [dbo]...
Observance asked 19/4, 2018 at 15:52
1
Solved
Is it possible to create a table with a column that has type DATETIME and give it a default value such as CURRENT_TIMESTAMP or GETDATE()? Is there another way to do this?
Screenshot from SSMS 2017...
Cleanly asked 23/7, 2018 at 17:54
1
Solved
I have tables that list a user's sales by Categories (each sale has at least one and may have several categories).
I can get the top categories for a user, but I need statistics for a user by both...
Entwistle asked 10/7, 2018 at 3:49
2
Solved
I've been using (localdb)\ProjectsV13 as part of my VS 2017 installation, however, I recently needed to access some SQL Server 2017 features during development, so I installed SQL Server 2017 Local...
Messenia asked 23/3, 2018 at 21:33
1
Solved
Screenshot above is from my SSMS 2017.
I want begin to use tfs on SQL server and I googled how to use it and apparently there should be an option for source control in tools-->option but there i...
Primipara asked 15/2, 2018 at 7:57
1
Solved
SSMS 17.4, SQL Server 2017 Developer's Edition on Win10 1709
I have installed the WorldWideImporters sample database. One of the tables, Sales.Customers, has several foreign keys AND several forei...
Pome asked 13/2, 2018 at 0:49
1
Solved
MS SQL Server 2017 (developer edition) is connected and running on my PC. However, when I want to start the develop process in MS Visual studio 2017, it is giving me the following error:
You canno...
Nausea asked 25/1, 2018 at 23:11
1
Solved
I have the following SQL Server 2017 container up and running as per -
https://learn.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker
CONTAINER ID IMAGE COMMAND CREATED STATUS PORT...
Teddytedeschi asked 28/11, 2017 at 8:58
© 2022 - 2024 — McMap. All rights reserved.