Thursday, March 24, 2011

Students Of MingalSpot

Hi to all
Please copy and paste this query in your database. Paste this in new query editor window of Mingalspot Db it's is the entity and sp for Videos.
Create Table TblVideos
(
VideoId BigInt Primary Key Identity(01,01),
VideoName Varchar(500),
Video VarBinary(max),
Fpath Varchar(500)
)
Create Procedure Sp_UploadVideo
(
@vname Varchar(500),
@video VarBinary(max),
@fpath Varchar(500)
)
as
Begin
Insert Into TblVideos(VideoName,Video,Fpath)Values(@vname,@video,@fpath)
End

Create Procedure Sp_Videos
As
Begin
Select VideoName,Fpath From TblVideos
End

No comments:

Post a Comment