db (18) 썸네일형 리스트형 [Next.js] error - unhandledRejection: MongoServerError: user is not allowed to do action [find] on [test.users] error - unhandledRejection: MongoServerError: user is not allowed to do action [find] on [test.users] at Connection.onMessage (C:\Users\leejoonho) at _write (node:internal/streams/writable:330:10) at MessageStream.Writable.write (node:internal/streams/writable:334:10) at TLSSocket.ondata (node:internal/streams/readable:754:22) at TLSSocket.emit (node:events:527:28) at addChunk (node:internal/str.. MSSQL - 저장프로시저 /트리거 생성 --저장프로시저 --매번 회원 테이블 당탕이의 정보와 제품 테이블의 냉장고 정보를 동시에 조회한독 가정하자. SELECT * FROM memberTbl WHERE memberName ='당탕이' SELECT * FROM productTbl WHERE productName ='냉장고' --저장프로시저 CREATE PROCEDURE myProc AS SELECT * FROM memberTbl WHERE memberName='당탕이' SELECT * FROM productTbl WHERE productName ='냉장고' GO --저장프로시저 실행 EXECUTE myProc --저장프로시저 삭제 DROP PROCEDURE myProc --트리거 : 트리거는 테이블에 부착되어 테이블에 INSERT나 UPDATE.. 이전 1 2 3 다음
