Activity overview
Latest activity by _Stefan_
[image] Hello @cperez, Unfortunately, it doesn't work with double quotes. I believe double quotes are not allowed in SQL Server. Is there another option to fix this problem? [image] / comments
Hello @cperez,Unfortunately, it doesn't work with double quotes. I believe double quotes are not allowed in SQL Server.Is there another option to fix this problem?
Hello @cperez,
Thank you for your quick response. I use dynamic SQL. This is the TSQL: DECLARE @TabellenName NVARCHAR(100);
DECLARE @SchlüsselFeld NVARCHAR(100);
DECLARE @sql NVARCHAR(MAX);
DECLARE @Kommentar NVARCHAR(MAX);
DECLARE @Datum NVARCHAR(50);
DECLARE @Autor NVARCHAR(100);
DECLARE @Tabellen TABLE (
TabellenName NVARCHAR(100)
);
INSERT INTO @Tabellen (TabellenName)
VALUES ('[schema].[table_name]');
/ comments
Hello @cperez,
Thank you for your quick response. I use dynamic SQL. This is the TSQL:DECLARE @TabellenName NVARCHAR(100);
DECLARE @SchlüsselFeld NVARCHAR(100);
DECLARE @sql NVARCHAR(MAX);
DECLARE ...
Hello @cperez,
Thank you for your quick response. I use dynamic SQL. This is the TSQL: DECLARE @SchlüsselFeld NVARCHAR(100);
DECLARE @sql NVARCHAR(MAX);
DECLARE @Kommentar NVARCHAR(MAX);
DECLARE @Datum NVARCHAR(50);
DECLARE @Autor NVARCHAR(100);
DECLARE @Tabellen TABLE (
TabellenName NVARCHAR(100)
);
-- Fügen Sie den/die Tabellennamen hinzu
INSERT INTO @Tabellen (TabellenName)
VALUES ('[schema].[table_name]');DECLARE @TabellenName NVARCHAR(100);
/ comments
Hello @cperez,
Thank you for your quick response. I use dynamic SQL.This is the TSQL:DECLARE @SchlüsselFeld NVARCHAR(100);
DECLARE @sql NVARCHAR(MAX);
DECLARE @Kommentar NVARCHAR(MAX);
DECLARE @Dat...
SQL Prompt Not Providing Suggestions for Placeholders in Quotes
Hello,I am currently using SQL Prompt version 10.14.21.9884 with SQL Server Management Studio 20.1.10.0 and I’ve encountered an issue that I hope can be addressed.The problem is that SQL Prompt doe...