What do you want to save?
Add Code snippet
New code examples
-
Other 2021-09-26 23:32:02
Mysql2::Error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT)
CREATE PROCEDURE updateProductUsers( IN rUsername VARCHAR(24), IN rProductID INT UNSIGNED, IN rPerm VARCHAR(16)) BEGIN UPDATE productUsers INNER JOIN users ON productUsers.userID = users.userID SET productUsers.perm... Add solution -
SQL 2021-09-06 00:54:01
sql stored procedure for access frontend
CREATE PROCEDURE getContact -- Add the parameters for the stored procedure here @id int = 1 AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert state... Add solution -
SQL 2021-09-02 00:27:01
check index sql server
create procedure _ListIndexes(@tableName nvarchar(200)) as begin /* exec _ListIndexes '<YOUR TABLE NAME>' */ SELECT DB_NAME(DB_ID()) as DBName,SCH.name + '.' + TBL.name AS TableName,IDX.name as IndexName, IDX.type_desc AS IndexType,COL.Name as Colum... Add solution