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

1 comment:

  1. nice blog it is very useful blog for .net learners.very informative and recommanded one thank you author best regards from sbr thak you for giving such valuabble info

    .net online training in hyderabad

    ReplyDelete