You may optionally enter a comparison operator (<, <=, >, >=, <> or =) at the beginning of each of your search values to specify how the comparison should be done.
String numberAsString = "";
int number = 1;
numberAsString = String.valueOf(number);
59
T-SQL
Datenbank
Fortlaufende Nummer innerhalb eines ResultSets
-- Beispiel:
-- http://msdn.microsoft.com/de-de/library/ms186734.aspx
SELECT FirstName, LastName, ROW_NUMBER() OVER(ORDER BY SalesYTD DESC) AS 'Row Number', SalesYTD, PostalCode FROM Sales.vSalesPerson
60
T-SQL
Datenbank
Nach Inhalt in Functions/Stored Procedures suchen
-- Durchsucht alle Functions, Stored Procedures, Views nach dem enthaltenen Begriff dbo.table1:
DECLARE @suchbegriff VarChar(50) = '%dbo.table1%'
SELECT
*
FROM
(
SELECT
ROUTINE_SCHEMA AS [Schema]
, ROUTINE_NAME AS [Objectname]
, ROUTINE_DEFINITION AS [Objectdefinition]
, ROUTINE_TYPE AS [Objecttype]
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE @suchbegriff
AND (ROUTINE_TYPE='PROCEDURE' OR ROUTINE_TYPE='FUNCTION')
UNION ALL
SELECT
TABLE_SCHEMA AS [Schema]
, TABLE_NAME AS [Objectname]
, VIEW_DEFINITION AS [Objectdefinition]
, 'VIEW' AS [Objecttype]
FROM
INFORMATION_SCHEMA.VIEWS
WHERE VIEW_DEFINITION LIKE @suchbegriff
) subQuery1
ORDER BY subQuery1.[Objectname]
-- gefunden bei: http://www.mssqltips.com/tip.asp?tip=1419
-- erweitert um View-Definition
257
PowerShell
Schleifen
For-Schleife
$elements ="A;B;C"
$elements.Split(";") | ForEach-Object {
write-host $_
}
Write-Host " - Next example -"
$elements ="D;E;F"
ForEach ($element in $elements.Split(";")) {
Write-Host $element
}
61
VB.NET
Schleifen
For-Schleife
For i As Integer = 0 To 10
Debug.WriteLine(i)
' 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10
Next
For i As Integer = 10 To 5 Step -1
Debug.WriteLine(i)
' 10, 9, 8, 7, 6, 5
Next
71
Delphi
Schleifen
For-Schleife
for i := 0 to 4 do
Writeln(i);
189
Python
Schleifen
For-Schleife
for i in range(0, 10):
i=1
time.sleep(1)
print i
items = ['computer', 'fruits', 'fraggels']
# without indexes
for item in items:
print item
# with indexes
for (i, item) in enumerate(items):
print i, item
63
T-SQL
Datenbank
Tabellenstruktur kopieren
Select *
INTO SQL2.dbo.NeueTabelle
FROM SQL1.dbo.AlteTabelle
WHERE 0=1
83
MySQL
Datenbank
Tabellenstruktur kopieren
CREATE TABLE zieltabelle SELECT * FROM quelltabelle WHERE ID=-1;
