Eingeschränkte Anweisungen – Für die folgenden Anweisungen gelten Einschränkungen. Verwenden Sie sie nicht für Ihre Tabellenschlüssel-Suche:

SELECT INTO -- SELECT Name INTO tablename1 FROM tablename2
NOW -- SELECT Column_name Now() AS PerDate FROM tablename;
FORMAT -- SELECT FORMAT(column_name,Now(),'YYYY-MM-DD') FROM tablename;
for xml path('')
DROP
DELETE
INSERT
UPDATE
ALTER
TRUNCTAE
CREATE
EXEC
XP_
SP_
 --
;

Zulässige Anweisungen – Sie können folgende SQL-Anweisungen ohne Einschränkungen verwenden:

SELECT TOP 2 * FROM [csdb].[csuser].[DTreeCore];

SELECT TOP 5 PERCENT * FROM [csdb].[csuser].[DTreeCore];

SELECT * FROM [csdb].[csuser].[DTreeCore] WHERE Name LIKE 'a%';

SELECT Name FROM [csdb].[csuser].[DTreeCore] WHERE Name LIKE '%s';

SELECT Name FROM [csdb].[csuser].[DTreeCore] WHERE Name LIKE '%prise%';

SELECT Name FROM [csdb].[csuser].[DTreeCore] WHERE Name NOT LIKE '%prise%';

SELECT Name FROM [csdb].[csuser].[DTreeCore] WHERE Name LIKE '_nterprise';

SELECT Name FROM [csdb].[csuser].[DTreeCore] WHERE Name LIKE 'E_t_rpr_se';

SELECT Name FROM [csdb].[csuser].[DTreeCore] WHERE Name LIKE '[bsp]%';

SELECT Name FROM [csdb].[csuser].[DTreeCore] WHERE Name LIKE '[a-c]%';

SELECT Name FROM [csdb].[csuser].[DTreeCore] WHERE Name LIKE '[!bsp]%';

SELECT Name FROM [csdb].[csuser].[DTreeCore] WHERE Name NOT LIKE '[bsp]%';

SELECT Name FROM [csdb].[csuser].[DTreeCore] WHERE Name IN ('Enterprise','Pulse');

SELECT DataID FROM [csdb].[csuser].[DTreeCore] WHERE DataID BETWEEN 1000 AND 5000;

SELECT DataID FROM [csdb].[csuser].[DTreeCore] WHERE DataID NOT BETWEEN 3000 AND 5000;

SELECT DataID FROM [csdb].[csuser].[DTreeCore] WHERE (DataID BETWEEN 3000 AND 5000) AND NOT UserID IN (100,200,3000);

SELECT Name FROM [csdb].[csuser].[DTreeCore] WHERE Name BETWEEN 'A' AND 'C';

SELECT Name FROM [csdb].[csuser].[DTreeCore] WHERE Name NOT BETWEEN 'A' AND 'W';

SELECT Name FROM [csdb].[csuser].[DTreeCore] WHERE CreateDate BETWEEN '2016-01-28' AND '2016-12-21';

SELECT a.Name FROM [csdb].[csuser].[DTreeCore] a INNER JOIN [csdb].[csuser].[DTree] b ON a.DataID = b.DataID;

SELECT a.DataID FROM [csdb].[csuser].[DTreeCore] a JOIN [csdb].[csuser].[DTree] b ON b.DataID = a.DataID;

SELECT a.Name FROM [csdb].[csuser].[DTreeCore] a LEFT JOIN [csdb].[csuser].[DTree] b ON a.UserID = b.UserID ORDER BY a.Name;

SELECT b.Name FROM [csdb].[csuser].[DTreeCore] a RIGHT JOIN [csdb].[csuser].[DTree] b ON a.DataID = b.DataID ORDER BY b.DataID;

SELECT b.UserID FROM [csdb].[csuser].[DTreeCore] a FULL OUTER JOIN [csdb].[csuser].[DTree] b ON a.OwnerID = b.OwnerID  ORDER BY a.OwnerID;

SELECT DataID FROM [csdb].[csuser].[DTreeCore] a UNION SELECT DataID b FROM [csdb].[csuser].[DTree] ORDER BY a.DataID;

SELECT DataID FROM [csdb].[csuser].[DTreeCore] UNION ALL SELECT DataID FROM [csdb].[csuser].[DTree] ORDER BY DataID;

SELECT UserID FROM [csdb].[csuser].[DTreeCore] WHERE Name='Enterprise' UNION ALL SELECT UserID FROM [csdb].[csuser].[DTree] WHERE Name='Enterprise' ORDER BY UserID;

SELECT Name INTO [csdb].[csuser].[CustomDtree] FROM [csdb].[csuser].[DTreeCore];

select * from [csdb].[csuser].[CustomDtree];

SELECT DataID FROM [csdb].[csuser].[DTreeCore] WHERE GroupID IS NULL;

SELECT DataID FROM [csdb].[csuser].[DTreeCore] WHERE GroupID IS NOT NULL;

SELECT  DataID*(OwnerID+ParentID) as  mydb  FROM [csdb].[csuser].[DTreeCore];

SELECT DataID*(OwnerID+ISNULL(UserID,0)) FROM [csdb].[csuser].[DTreeCore];

SELECT DataID*(OwnerID+COALESCE(UserID,0)) FROM [csdb].[csuser].[DTreeCore];

select AVG(ParentID) FROM [csdb].[csuser].[DTreeCore];

SELECT Name FROM [csdb].[csuser].[DTreeCore] WHERE UserID>(SELECT AVG(OwnerID) FROM [csdb].[csuser].[DTree]);

SELECT COUNT(DISTINCT Name) FROM [csdb].[csuser].[DTreeCore];

SELECT TOP 1 Name FROM [csdb].[csuser].[DTreeCore] ORDER BY ParentID ASC;

SELECT TOP 1 Name FROM [csdb].[csuser].[DTreeCore] ORDER BY ParentID DESC;

SELECT MAX(OwnerID) FROM [csdb].[csuser].[DTreeCore];

SELECT MIN(OwnerID) FROM [csdb].[csuser].[DTreeCore];

SELECT SUM(OwnerID) FROM [csdb].[csuser].[DTreeCore];

SELECT  COUNT(b.DataID) AS NumberOfOrders FROM ([csdb].[csuser].[DTree] b INNER JOIN [csdb].[csuser].[DTreeCore] a ON b.UserID=a.UserID) GROUP BY a.Name HAVING   COUNT(b.UserID) > 1000;

SELECT UPPER(Name) FROM [csdb].[csuser].[DTreeCore];

SELECT LOWER(Name) FROM [csdb].[csuser].[DTreeCore];

SELECT SUBSTRING(Name,1,7) AS some_name FROM  [csdb].[csuser].[DTreeCore];

SELECT LEN(Name) FROM [csdb].[csuser].[DTreeCore];

SELECT ROUND(DataID,3) FROM [csdb].[csuser].[DTreeCore];