【SQL开源代码栏目提醒】:网学会员为广大网友收集整理了,CreatePic.sql,希望对大家有所帮助!
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);