What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-09-13 18:16:02
MySQL DELETE JOIN
MySQL also allows you to use the INNER JOIN clause in the DELETE statement to delete rows from a table and the matching rows in another table. For example, to delete rows from both T1 and T2 tables that meet a specified condition, you use the following s... Add solution -
SQL 2021-09-12 17:08:03
buscar nombre de columna en todas las tablas sql server
SELECT sysobjects.name AS table_name, syscolumns.name AS column_name, systypes.name AS datatype, syscolumns.LENGTH AS LENGTH FROM sysobjects INNER JOIN syscolumns ON sysobjects.id = syscolumns.id INNER JOIN ... Add solution -
Other 2021-09-10 03:42:01
trncate table with relationships
SET NOCOUNT ON GO DECLARE @table TABLE( RowId INT PRIMARY KEY IDENTITY(1, 1), ForeignKeyConstraintName NVARCHAR(200), ForeignKeyConstraintTableSchema NVARCHAR(200), ForeignKeyConstraintTableName NVARCHAR(200), ForeignKeyConstraintColumnName NVARCHAR(200)... Add solution
Best helpers
Ranking is empty