Manage PlItems
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.
Advanced SearchDisplaying 221-230 of 300 results.
| ID | PlCodelang | PlGroup | PlItemTitle | Code | |
|---|---|---|---|---|---|
| 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 | |
| 63 | T-SQL | Datenbank | Tabellenstruktur kopieren | Select * INTO SQL2.dbo.NeueTabelle FROM SQL1.dbo.AlteTabelle WHERE 0=1 | |
| 64 | T-SQL | Datenbank | Prüfen ob temporäre Tabelle existiert | SELECT OBJECT_ID ('tempdb..#myTableTable1') | |
| 65 | T-SQL | Datenbank | Prüfen welche/ob Tabelle ein AutoIncrement/Identiy Spalte hat | -- Welche Tabellen ... select o.name, c.name, from sys.objects o inner join sys.columns c on o.object_id = c.object_id where c.is_identity = 1 -- -------------------------------------- -- Hat diese Tabelle ... IF ((SELECT OBJECTPROPERTY( OBJECT_ID(N'dbo.myTable'), 'TableHasIdentity')) = 1) PRINT 'Yes' ELSE PRINT 'No' | |
| 66 | T-SQL | Datenbank | Ausführen von SQL-Code per Aufruf | http://www.databasejournal.com/features/mssql/article.php/3286501/T-SQL-Programming-Part-4---Setting-Variables-in-Calling-T-SQL-Code-While-Using-spexecutesql.htm use Northwind go declare @RECCNT int declare @ORDID varchar(10) declare @CMD Nvarchar(100) set @ORDID = 10436 SET @CMD = 'SELECT @RECORDCNT=count(*) from [Orders]' + ' where OrderId < @ORDERID' print @CMD exec sp_executesql @CMD, N'@RECORDCNT int out, @ORDERID int', @RECCNT out, @ORDID print 'The number of records that have an OrderId' + ' greater than ' + @ORDID + ' is ' + cast(@RECCNT as char(5)) | |
| 67 | T-SQL | Datenbank | Tabellenzeile mit FK's löschen | -- Siehe auch: http://www.sqlteam.com/article/performing-a-cascade-delete-in-sql-server-7 CREATE Procedure spDeleteRows -- Recursive row delete procedure. -- It deletes all rows in the table specified that conform to the criteria selected, -- while also deleting any child/grandchild records and so on. This is designed to do the -- same sort of thing as Access's cascade delete function. It first reads the sysforeignkeys -- table to find any child tables, then deletes the soon-to-be orphan records from them using -- recursive calls to this procedure. Once all child records are gone, the rows are deleted -- from the selected table. It is designed at this time to be run at the command line. It could -- also be used in code, but the printed output will not be available. ( @cTableName varchar(50), -- name of the table where rows are to be deleted @cCriteria nvarchar(1000), -- criteria used to delete the rows required @iRowsAffected int OUTPUT -- number of records affected by the delete ) As set nocount on declare @cTab varchar(255), -- name of the child table @cCol varchar(255), -- name of the linking field on the child table @cRefTab varchar(255), -- name of the parent table @cRefCol varchar(255), -- name of the linking field in the parent table @cFKName varchar(255), -- name of the foreign key @cSQL nvarchar(1000), -- query string passed to the sp_ExecuteSQL procedure @cChildCriteria nvarchar(1000), -- criteria to be used to delete -- records from the child table @iChildRows int -- number of rows deleted from the child table -- declare the cursor containing the foreign key constraint information DECLARE cFKey CURSOR LOCAL FOR SELECT SO1.name AS Tab, SC1.name AS Col, SO2.name AS RefTab, SC2.name AS RefCol, FO.name AS FKName FROM dbo.sysforeignkeys FK INNER JOIN dbo.syscolumns SC1 ON FK.fkeyid = SC1.id AND FK.fkey = SC1.colid INNER JOIN dbo.syscolumns SC2 ON FK.rkeyid = SC2.id AND FK.rkey = SC2.colid INNER JOIN dbo.sysobjects SO1 ON FK.fkeyid = SO1.id INNER JOIN dbo.sysobjects SO2 ON FK.rkeyid = SO2.id INNER JOIN dbo.sysobjects FO ON FK.constid = FO.id WHERE SO2.Name = @cTableName OPEN cFKey FETCH NEXT FROM cFKey INTO @cTab, @cCol, @cRefTab, @cRefCol, @cFKName WHILE @@FETCH_STATUS = 0 BEGIN -- build the criteria to delete rows from the child table. As it uses the -- criteria passed to this procedure, it gets progressively larger with -- recursive calls SET @cChildCriteria = @cCol + ' in (SELECT [' + @cRefCol + '] FROM [' + @cRefTab +'] WHERE ' + @cCriteria + ')' print 'Deleting records from table ' + @cTab -- call this procedure to delete the child rows EXEC spDeleteRows @cTab, @cChildCriteria, @iChildRows OUTPUT FETCH NEXT FROM cFKey INTO @cTab, @cCol, @cRefTab, @cRefCol, @cFKName END Close cFKey DeAllocate cFKey -- finally delete the rows from this table and display the rows affected SET @cSQL = 'DELETE FROM [' + @cTableName + '] WHERE ' + @cCriteria print @cSQL EXEC sp_ExecuteSQL @cSQL print 'Deleted ' + CONVERT(varchar, @@ROWCOUNT) + ' records from table ' + @cTableName | |
| 83 | MySQL | Datenbank | Tabellenstruktur kopieren | CREATE TABLE zieltabelle SELECT * FROM quelltabelle WHERE ID=-1; | |
| 117 | T-SQL | Datenbank | CSV erstellen | SELECT SUBSTRING( (SELECT ',' + CSVItem FROM TableWithItems s ORDER BY s.Name FOR XML PATH('')),2,200000) GO | |
| 130 | MySQL | Datenbank | CSV erstellen | -- http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_group-concat SELECT R.TITEL AS TITEL ,R.ANLEITUNG AS ANLEITUNG ,GROUP_CONCAT(CONCAT(CAST(RZ.MENGE AS CHAR),' ',RZ.EINHEIT,' ' ,Z.ZUTAT) SEPARATOR ',') AS ZUTATEN ,R.NOTIZ AS NOTIZ FROM REZEPT AS R LEFT JOIN REZEPT_HAS_ZUTAT AS RZ ON R.ID=RZ.REZEPT_ID LEFT JOIN ZUTAT AS Z ON RZ.ZUTAT_ID=Z.ID AND RZ.REZEPT_ID=R.ID | |