2004510482307createpic.sql

居于C charp的企业信息化平台软件。

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);