2004510472336createpic.sql

来自「居于C charp的企业信息化平台软件。」· SQL 代码 · 共 5 行

CREATE PROCEDURE CreatePic(@albumid int, @filename varchar(255), @width int, @height int, @imgdate datetime, @imgsize int) AS

IF NOT EXISTS(SELECT [id] FROM pics WHERE albumid=@albumid AND [filename]=@filename)
  INSERT INTO pics (albumid, [filename], width, height, imgdate, imgsize) values (@albumid, @filename, @width, @height, @imgdate, @imgsize);