Social Website Database -Online application RSS

• • Reply
  

  TimoYang

  Contributor

  3732 Points

  1275 Posts

  Re: Social Website Database -Online application

  Jun 12, 2012 07:45 AM|LINK

  Saby2012

  Now I came back & figur out that the file is not database file.... it look like a script for databse....

  Yes，Plz just open your SQL Management studio first to execute this script to generate your db，and then do connection……

• • Reply
  

  Saby2012

  Member

  160 Points

  150 Posts

  Re: Social Website Database -Online application

  Jun 12, 2012 08:32 PM|LINK

  TimoYang

  Thank u ...

  I try ... but ...when i extend the table folder it show as an empty....:(

  i dont know why :(

  Actally I got the project from this link ....

  http://www.techipost.com/2011/06/03/signupsign-in-for-social-networking-website/

  you can download and let me how to solve the problem.!

• • Reply
  

  TimoYang

  Contributor

  3732 Points

  1275 Posts

  Re: Social Website Database -Online application

  Jun 14, 2012 06:34 AM|LINK

  Saby2012

  when i extend the table folder it show as an empty....:(

  Screenshot, plzzzzzzzzz:D

• • Reply
  

  Saby2012

  Member

  160 Points

  150 Posts

  Re: Social Website Database -Online application

  Jun 14, 2012 09:10 AM|LINK

  TimoYang

  Here the screen shoot :)

  

  

• • Reply
  

  TimoYang

  Contributor

  3732 Points

  1275 Posts

  Re: Social Website Database -Online application

  Jun 15, 2012 06:04 AM|LINK

  Where's your Tables in the "Tables" folder？！ 

• • Reply
  

  Saby2012

  Member

  160 Points

  150 Posts

  Re: Social Website Database -Online application

  Jun 15, 2012 06:10 AM|LINK

  Hi again,...as you told me ...

  I openSQL Management studio first and execute the script to generate  db，and then  i did connection……

   

  but there is no files.....

   

  I got this project fom .. the internet ,,,, It look very professional....

  this is the link:

  http://www.techipost.com/2011/06/03/signupsign-in-for-social-networking-website/#comments

  but i could connect to db !! any help :(

• • Reply
  

  TimoYang

  Contributor

  3732 Points

  1275 Posts

  Re: Social Website Database -Online application

  Jun 15, 2012 06:22 AM|LINK

  Plz make sure that your script must include codes that will generate tables.........

• • Reply
  

  Saby2012

  Member

  160 Points

  150 Posts

  Re: Social Website Database -Online application

  Jun 15, 2012 06:29 AM|LINK

  This my script..

  /****** Object:  Table [dbo].[Grades]    Script Date: 05/31/2011 12:18:02 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  SET ANSI_PADDING ON
  GO
  IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Grades]') AND type in (N'U'))
  BEGIN
  CREATE TABLE [dbo].[Grades](
  	[TransID] [int] IDENTITY(1,1) NOT NULL,
  	[StudentID] [int] NULL,
  	[StudentName] [varchar](100) NULL,
  	[CourseName] [varchar](50) NULL,
  	[Grade] [varchar](10) NULL,
   CONSTRAINT [PK_Grades] PRIMARY KEY CLUSTERED
  (
  	[TransID] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  END
  GO
  SET ANSI_PADDING OFF
  GO
  SET IDENTITY_INSERT [dbo].[Grades] ON
  INSERT [dbo].[Grades] ([TransID], [StudentID], [StudentName], [CourseName], [Grade]) VALUES (1, 1, N'Usman Zubair', N'Software Reuse', N'B')
  SET IDENTITY_INSERT [dbo].[Grades] OFF
  /****** Object:  Table [dbo].[Roles]    Script Date: 05/31/2011 12:18:02 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  SET ANSI_PADDING ON
  GO
  IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Roles]') AND type in (N'U'))
  BEGIN
  CREATE TABLE [dbo].[Roles](
  	[ID] [int] IDENTITY(1,1) NOT NULL,
  	[RoleName] [varchar](50) NOT NULL,
   CONSTRAINT [PK_Roles] PRIMARY KEY CLUSTERED
  (
  	[ID] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  END
  GO
  SET ANSI_PADDING OFF
  GO
  SET IDENTITY_INSERT [dbo].[Roles] ON
  INSERT [dbo].[Roles] ([ID], [RoleName]) VALUES (1, N'Administrator')
  INSERT [dbo].[Roles] ([ID], [RoleName]) VALUES (2, N'Student')
  INSERT [dbo].[Roles] ([ID], [RoleName]) VALUES (3, N'Faculty')
  SET IDENTITY_INSERT [dbo].[Roles] OFF
  /****** Object:  Table [dbo].[Users]    Script Date: 05/31/2011 12:18:02 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  SET ANSI_PADDING ON
  GO
  IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Users]') AND type in (N'U'))
  BEGIN
  CREATE TABLE [dbo].[Users](
  	[ID] [int] IDENTITY(1,1) NOT NULL,
  	[UserName] [varchar](50) NOT NULL,
  	[Password] [varchar](50) NOT NULL,
  	[Gender] [varchar](20) NULL,
  	[FirstName] [varchar](50) NULL,
  	[LastName] [varchar](50) NULL,
  	[DateofBirth] [datetime] NULL,
   CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED
  (
  	[ID] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  END
  GO
  SET ANSI_PADDING OFF
  GO
  SET IDENTITY_INSERT [dbo].[Users] ON
  INSERT [dbo].[Users] ([ID], [UserName], [Password], [Gender], [FirstName], [LastName], [DateofBirth]) VALUES (1, N'Umair Ashraf', N'1234', N'Male', N'Umair', N'Ashraf', CAST(0x00007A1400000000 AS DateTime))
  INSERT [dbo].[Users] ([ID], [UserName], [Password], [Gender], [FirstName], [LastName], [DateofBirth]) VALUES (2, N'Ali Ahmad', N'1234', N'Male', N'Ali', N'Ahmad', CAST(0x00007A1400000000 AS DateTime))
  INSERT [dbo].[Users] ([ID], [UserName], [Password], [Gender], [FirstName], [LastName], [DateofBirth]) VALUES (3, N'Ahsan', N'1234', N'Male', N'Ahsan', N'Riaz', CAST(0x00007A1400000000 AS DateTime))
  INSERT [dbo].[Users] ([ID], [UserName], [Password], [Gender], [FirstName], [LastName], [DateofBirth]) VALUES (4, N'', N'', N'Male', N'Umair', N'Ashraf', CAST(0x00008D3F00000000 AS DateTime))
  SET IDENTITY_INSERT [dbo].[Users] OFF
  /****** Object:  Table [dbo].[Courses]    Script Date: 05/31/2011 12:18:02 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  SET ANSI_PADDING ON
  GO
  IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Courses]') AND type in (N'U'))
  BEGIN
  CREATE TABLE [dbo].[Courses](
  	[CourseID] [int] IDENTITY(1,1) NOT NULL,
  	[CourseCode] [varchar](50) NULL,
  	[CourseName] [varchar](150) NULL,
  	[Semester] [varchar](50) NULL,
  	[InstructorName] [varchar](50) NULL,
  	[CreditHours] [int] NULL,
   CONSTRAINT [PK_Courses] PRIMARY KEY CLUSTERED
  (
  	[CourseID] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  END
  GO
  SET ANSI_PADDING OFF
  GO
  SET IDENTITY_INSERT [dbo].[Courses] ON
  INSERT [dbo].[Courses] ([CourseID], [CourseCode], [CourseName], [Semester], [InstructorName], [CreditHours]) VALUES (1, N'CS536', N'Software Reuse', N'Spring 2010', N'Hamid Basitt', 3)
  INSERT [dbo].[Courses] ([CourseID], [CourseCode], [CourseName], [Semester], [InstructorName], [CreditHours]) VALUES (5, N'ITC', N'Introduction to Computing', N'Spring 2010', N'Omer Saif', 4)
  SET IDENTITY_INSERT [dbo].[Courses] OFF
  /****** Object:  Table [dbo].[Book]    Script Date: 05/31/2011 12:18:02 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  SET ANSI_PADDING ON
  GO
  IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Book]') AND type in (N'U'))
  BEGIN
  CREATE TABLE [dbo].[Book](
  	[BookID] [int] IDENTITY(1,1) NOT NULL,
  	[BookCode] [varchar](50) NOT NULL,
  	[BookName] [varchar](50) NULL,
  	[Author] [varchar](50) NULL,
  	[NoofCopies] [int] NULL,
  	[Publisher] [varchar](50) NULL,
   CONSTRAINT [PK_Book] PRIMARY KEY CLUSTERED
  (
  	[BookID] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  END
  GO
  SET ANSI_PADDING OFF
  GO
  SET IDENTITY_INSERT [dbo].[Book] ON
  INSERT [dbo].[Book] ([BookID], [BookCode], [BookName], [Author], [NoofCopies], [Publisher]) VALUES (1, N'Eco1299', N'Economics', N'Marther', 10, N'Petersons')
  SET IDENTITY_INSERT [dbo].[Book] OFF
  /****** Object:  Table [dbo].[TicketInfo]    Script Date: 05/31/2011 12:18:02 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  SET ANSI_PADDING ON
  GO
  IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TicketInfo]') AND type in (N'U'))
  BEGIN
  CREATE TABLE [dbo].[TicketInfo](
  	[TicketID] [int] IDENTITY(1,1) NOT NULL,
  	[CompanyName] [varchar](100) NULL,
  	[ContactName] [varchar](100) NULL,
  	[ContactPhone] [varchar](20) NULL,
  	[ContactEmail] [varchar](50) NULL,
  	[TicketSummary] [varchar](400) NULL,
  	[TicketDesc] [varchar](400) NULL,
  	[DateAdded] [datetime] NULL,
  	[DateModified] [datetime] NULL
  ) ON [PRIMARY]
  END
  GO
  SET ANSI_PADDING OFF
  GO
  SET IDENTITY_INSERT [dbo].[TicketInfo] ON
  INSERT [dbo].[TicketInfo] ([TicketID], [CompanyName], [ContactName], [ContactPhone], [ContactEmail], [TicketSummary], [TicketDesc], [DateAdded], [DateModified]) VALUES (1, N'Bank of America', N'John Smith', N'+1857325325', N'john@stratasoft.com', N'Dialer Issue', N'Dialer Issue', CAST(0x00009EC900C5C100 AS DateTime), CAST(0x00009EC900C5C100 AS DateTime))
  INSERT [dbo].[TicketInfo] ([TicketID], [CompanyName], [ContactName], [ContactPhone], [ContactEmail], [TicketSummary], [TicketDesc], [DateAdded], [DateModified]) VALUES (2, N'Malabar', N'Ali', N'+1857325325', N'Ali@stratasoft.com', N'Unknown error', N'Unknown error', CAST(0x00009EC900C5C100 AS DateTime), CAST(0x00009EC900C5C100 AS DateTime))
  INSERT [dbo].[TicketInfo] ([TicketID], [CompanyName], [ContactName], [ContactPhone], [ContactEmail], [TicketSummary], [TicketDesc], [DateAdded], [DateModified]) VALUES (8, N'test', N'tess', N'sg', N'asg', N'asg', N'asg', CAST(0x00009EC900F3D9C8 AS DateTime), CAST(0x00009EC900F3D9C8 AS DateTime))
  INSERT [dbo].[TicketInfo] ([TicketID], [CompanyName], [ContactName], [ContactPhone], [ContactEmail], [TicketSummary], [TicketDesc], [DateAdded], [DateModified]) VALUES (9, N'asg', N'asg', N'asg', N'asg', N'asg', N'asg', CAST(0x00009EC900F6FC84 AS DateTime), CAST(0x00009EC900F6FC84 AS DateTime))
  SET IDENTITY_INSERT [dbo].[TicketInfo] OFF
  /****** Object:  StoredProcedure [dbo].[Ticket_insert]    Script Date: 05/31/2011 12:18:01 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Ticket_insert]') AND type in (N'P', N'PC'))
  BEGIN
  EXEC dbo.sp_executesql @statement = N'
  CREATE Procedure [dbo].[Ticket_insert]
  
  @CompanyName varchar(400),
  @ContactName varchar(400),
  @ContactPhone varchar(50),
  @ContactEmail  varchar(50),
  @TicketSummary varchar(400),
  @TicketDesc varchar(400),
  @DateAdded datetime,
  @DateModified datetime
  
  as
  
  INSERT INTO [TicketInfo]
             ([CompanyName]
             ,[ContactName]
             ,[ContactPhone]
             ,[ContactEmail]
             ,[TicketSummary]
             ,[TicketDesc]
             ,[DateAdded]
             ,[DateModified])
       VALUES
             (@CompanyName,@ContactName,@ContactPhone,@ContactEmail,@TicketSummary,@TicketDesc,@DateAdded,@DateModified)
  
  '
  END
  GO
  /****** Object:  StoredProcedure [dbo].[Ticket_Delete]    Script Date: 05/31/2011 12:18:01 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Ticket_Delete]') AND type in (N'P', N'PC'))
  BEGIN
  EXEC dbo.sp_executesql @statement = N'
  /****** Script for SelectTopNRows command from SSMS  ******/
  
  CREATE Procedure  [dbo].[Ticket_Delete]
  
  @TicketID int
  as
  
  
  
  Delete
    FROM [dbo].[Ticketinfo]
    
    where ticketid=@TicketID
  
  '
  END
  GO
  /****** Object:  StoredProcedure [dbo].[Courses_update]    Script Date: 05/31/2011 12:18:01 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Courses_update]') AND type in (N'P', N'PC'))
  BEGIN
  EXEC dbo.sp_executesql @statement = N'Create Procedure [dbo].[Courses_update]
  @courseID int,
  @CourseCode varchar(50),
  @CourseName varchar(150),
  @Semester varchar(50),
  @InstructorName  varchar(50),
  @CreditHours int
  
  as
  
  UPDATE [dbo].[Courses]
     SET [CourseCode] = @CourseCode
        ,[CourseName] = @CourseName
        ,[Semester] = @Semester
        ,[InstructorName] = @InstructorName
        ,[CreditHours] = @CreditHours
   WHERE CourseID=@courseID
  '
  END
  GO
  /****** Object:  StoredProcedure [dbo].[Courses_selectAll]    Script Date: 05/31/2011 12:18:01 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Courses_selectAll]') AND type in (N'P', N'PC'))
  BEGIN
  EXEC dbo.sp_executesql @statement = N'/****** Script for SelectTopNRows command from SSMS  ******/
  
  Create Procedure  [dbo].[Courses_selectAll]
  
  as
  
  SELECT TOP 1000 [CourseID]
        ,[CourseCode]
        ,[CourseName]
        ,[Semester]
        ,[InstructorName]
        ,[CreditHours]
    FROM [dbo].[Courses]
    
  '
  END
  GO
  /****** Object:  StoredProcedure [dbo].[Courses_search]    Script Date: 05/31/2011 12:18:01 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Courses_search]') AND type in (N'P', N'PC'))
  BEGIN
  EXEC dbo.sp_executesql @statement = N'
  
  /****** Script for SelectTopNRows command from SSMS  ******/
  
  
  CREATE Procedure  [dbo].[Courses_search]
  
  @courseid int,
  @coursecode varchar(50),
  @semester varchar(50)
  as
  
  SELECT [CourseID]
        ,[CourseCode]
        ,[CourseName]
        ,[Semester]
        ,[InstructorName]
        ,[CreditHours]
    FROM [dbo].[Courses]
    
    where (CourseID=@courseid and @coursecode=''-1'' and @semester=''-1'')
    or(@courseid=-1 and CourseCode=@coursecode and @semester=''-1'')
  or(@coursecode=''1'' and CourseCode=''-1'' and @semester=Semester)
  or(@courseid=@courseid and CourseCode=@coursecode and @semester=Semester)
  or(@courseid=''-1'' and @CourseCode=''-1'' and @semester=''-1'')
  
  '
  END
  GO
  /****** Object:  StoredProcedure [dbo].[Courses_insert]    Script Date: 05/31/2011 12:18:01 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Courses_insert]') AND type in (N'P', N'PC'))
  BEGIN
  EXEC dbo.sp_executesql @statement = N'Create Procedure [dbo].[Courses_insert]
  
  @CourseCode varchar(50),
  @CourseName varchar(150),
  @Semester varchar(50),
  @InstructorName  varchar(50),
  @CreditHours int
  
  as
  
  INSERT INTO [companydb].[dbo].[Courses]
             ([CourseCode]
             ,[CourseName]
             ,[Semester]
             ,[InstructorName]
             ,[CreditHours])
       VALUES
             (@CourseCode,@CourseName,@Semester,@InstructorName,@CreditHours)
  '
  END
  GO
  /****** Object:  StoredProcedure [dbo].[Courses_Delete]    Script Date: 05/31/2011 12:18:01 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Courses_Delete]') AND type in (N'P', N'PC'))
  BEGIN
  EXEC dbo.sp_executesql @statement = N'/****** Script for SelectTopNRows command from SSMS  ******/
  
  Create Procedure  [dbo].[Courses_Delete]
  
  @CourseID int
  as
  
  
  
  Delete
    FROM [dbo].[Courses]
    
    where CourseID=@CourseID
  '
  END
  GO
  /****** Object:  StoredProcedure [dbo].[AuthenticateUser]    Script Date: 05/31/2011 12:18:01 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AuthenticateUser]') AND type in (N'P', N'PC'))
  BEGIN
  EXEC dbo.sp_executesql @statement = N'-- =============================================
  -- Author: <Umair Ashraf>
  -- Create date: <2-April-2010>
  -- Description: <Authenticate Username and password >
  -- =============================================
  
  --Test Run:
  
  -- Exec AuthenticateUser ''Umair Ashraf'' ,''12345''
  CREATE PROCEDURE [dbo].[AuthenticateUser]
  	-- Add the parameters for the stored procedure here
  	@username varchar(50),
  	@password varchar(50)
  	
  AS
  BEGIN
  	-- SET NOCOUNT ON added to prevent extra result sets from
  	-- interfering with SELECT statements.
  	SET NOCOUNT ON;
  
      -- Insert statements for procedure here
  	select * from Users
  	
  	where [USERNAME]=@username and Password=@password
  END
  '
  END
  GO
  /****** Object:  StoredProcedure [dbo].[books_update]    Script Date: 05/31/2011 12:18:01 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[books_update]') AND type in (N'P', N'PC'))
  BEGIN
  EXEC dbo.sp_executesql @statement = N'
  Create Procedure [dbo].[books_update]
  
  @BookID int,
  @BookCode varchar(50),
  @BookName varchar(150),
  @Author varchar(50),
  @NoofCopies  int ,
  @Publisher varchar(50)
  
  as
  
  UPDATE [dbo].[Book]
     SET [BookCode] = @BookCode
        ,[BookName] = @BookName
        ,[Author] = @Author
        ,[NoofCopies] = @NoofCopies
        ,[Publisher] = @Publisher
   WHERE bookid=@bookID
  
  '
  END
  GO
  /****** Object:  StoredProcedure [dbo].[books_insert]    Script Date: 05/31/2011 12:18:01 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[books_insert]') AND type in (N'P', N'PC'))
  BEGIN
  EXEC dbo.sp_executesql @statement = N'
  Create Procedure [dbo].[books_insert]
  
  @BookCode varchar(50),
  @BookName varchar(150),
  @Author varchar(50),
  @NoofCopies  int ,
  @Publisher varchar(50)
  
  as
  
  INSERT INTO [dbo].[Book]
             ([BookCode]
             ,[BookName]
             ,[Author]
             ,[NoofCopies]
             ,[Publisher])
       VALUES
             (@BookCode,@BookName,@Author,@NoofCopies,@Publisher)
  
  '
  END
  GO
  /****** Object:  StoredProcedure [dbo].[books_Delete]    Script Date: 05/31/2011 12:18:01 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[books_Delete]') AND type in (N'P', N'PC'))
  BEGIN
  EXEC dbo.sp_executesql @statement = N'
  /****** Script for SelectTopNRows command from SSMS  ******/
  
  Create Procedure  [dbo].[books_Delete]
  
  @BookID int
  as
  
  
  
  Delete
    FROM [dbo].[book]
    
    where bookID=@BookID
  
  '
  END
  GO
  /****** Object:  StoredProcedure [dbo].[book_selectAll]    Script Date: 05/31/2011 12:18:01 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[book_selectAll]') AND type in (N'P', N'PC'))
  BEGIN
  EXEC dbo.sp_executesql @statement = N'create procedure [dbo].[book_selectAll]
  
  as
  
  SELECT [BookID]
        ,[BookCode]
        ,[BookName]
        ,[Author]
        ,[NoofCopies]
        ,[Publisher]
    FROM [dbo].[Book]
  '
  END
  GO
  /****** Object:  StoredProcedure [dbo].[Book_search]    Script Date: 05/31/2011 12:18:01 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Book_search]') AND type in (N'P', N'PC'))
  BEGIN
  EXEC dbo.sp_executesql @statement = N'
  
  
  
  /****** Script for SelectTopNRows command from SSMS  ******/
  
  
  CREATE Procedure  [dbo].[Book_search]
  
  @BookID int,
  @BookCode varchar(50),
  @BookName varchar(50)
  as
  
  SELECT [BookID]
        ,[BookCode]
        ,[BookName]
        ,[Author]
        ,[NoofCopies]
        ,[Publisher]
    FROM [dbo].[Book]
    
    where (BookID=@BookID and @bookcode=''-1'' and @BookName=''-1'')
    or(@BookID=-1 and bookcode=@bookcode and BookName=''-1'')
  or(@bookcode=''1'' and bookcode=''-1'' and BookName=BookName)
  or(@BookID=@BookID and bookcode=@bookcode and BookName=BookName)
  or(@BookID=''-1'' and @bookcode=''-1'' and @BookName=''-1'')
  
  
  
  '
  END
  GO
  /****** Object:  Table [dbo].[UserRoles]    Script Date: 05/31/2011 12:18:02 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UserRoles]') AND type in (N'U'))
  BEGIN
  CREATE TABLE [dbo].[UserRoles](
  	[ID] [int] IDENTITY(1,1) NOT NULL,
  	[UserID] [int] NOT NULL,
  	[RoleID] [int] NOT NULL,
   CONSTRAINT [PK_UserRoles] PRIMARY KEY CLUSTERED
  (
  	[ID] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  END
  GO
  SET IDENTITY_INSERT [dbo].[UserRoles] ON
  INSERT [dbo].[UserRoles] ([ID], [UserID], [RoleID]) VALUES (1, 1, 1)
  INSERT [dbo].[UserRoles] ([ID], [UserID], [RoleID]) VALUES (2, 2, 3)
  INSERT [dbo].[UserRoles] ([ID], [UserID], [RoleID]) VALUES (3, 3, 2)
  SET IDENTITY_INSERT [dbo].[UserRoles] OFF
  /****** Object:  StoredProcedure [dbo].[User_insert]    Script Date: 05/31/2011 12:18:01 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[User_insert]') AND type in (N'P', N'PC'))
  BEGIN
  EXEC dbo.sp_executesql @statement = N'
  
  Create Procedure [dbo].[User_insert]
  
   @UserName varchar(50),
   @Password varchar(50),
   @Gender varchar(20),
   @FirstName varchar(50),
   @LastName varchar(50),
   @DateofBirth datetime
  
  as
  
  INSERT INTO [dbo].[Users]
             ([UserName]
             ,[Password]
             ,[Gender]
             ,[FirstName]
             ,[LastName]
             ,[DateofBirth])
       VALUES
            
             (@UserName,@Password,@Gender,@FirstName,@LastName,@DateofBirth)
  
  
  '
  END
  GO
  /****** Object:  StoredProcedure [dbo].[Tickets_selectAll]    Script Date: 05/31/2011 12:18:01 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Tickets_selectAll]') AND type in (N'P', N'PC'))
  BEGIN
  EXEC dbo.sp_executesql @statement = N'
  /****** Script for SelectTopNRows command from SSMS  ******/
  
  Create Procedure  [dbo].[Tickets_selectAll]
  
  as
  
  SELECT * From ticketinfo
    
  
  '
  END
  GO
  /****** Object:  StoredProcedure [dbo].[Grades_selectAll]    Script Date: 05/31/2011 12:18:01 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Grades_selectAll]') AND type in (N'P', N'PC'))
  BEGIN
  EXEC dbo.sp_executesql @statement = N'
  /****** Script for SelectTopNRows command from SSMS  ******/
  CREATE Procedure  [dbo].[Grades_selectAll]
  
  as
  
  SELECT TOP 1000 [TransID]
        ,[StudentID]
        ,[StudentName]
        ,[CourseName]
        ,[Grade]
    FROM [companydb].[dbo].[Grades]
    
  
  '
  END
  GO
  /****** Object:  StoredProcedure [dbo].[GetUsersList]    Script Date: 05/31/2011 12:18:01 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GetUsersList]') AND type in (N'P', N'PC'))
  BEGIN
  EXEC dbo.sp_executesql @statement = N'-- =============================================
  -- Author: <Umair Ashraf>
  -- Create date: <2-April-2010>
  -- Description: <Authenticate Username and password >
  -- =============================================
  
  --Test Run:
  
  -- Exec GetUsersList
  CREATE PROCEDURE [dbo].[GetUsersList]
  	-- Add the parameters for the stored procedure here
  	
  	
  	
  AS
  BEGIN
  	-- SET NOCOUNT ON added to prevent extra result sets from
  	-- interfering with SELECT statements.
  	SET NOCOUNT ON;
  
      -- Insert statements for procedure here
  	select * from users
  END
  '
  END
  GO
  /****** Object:  StoredProcedure [dbo].[GetUserRole]    Script Date: 05/31/2011 12:18:01 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GetUserRole]') AND type in (N'P', N'PC'))
  BEGIN
  EXEC dbo.sp_executesql @statement = N'-- =============================================
  -- Author: <Umair Ashraf>
  -- Create date: <2-April-2010>
  -- Description: <Authenticate Username and password >
  -- =============================================
  
  --Test Run:
  
  -- Exec GetUserRole  ''Umair Ashraf''
  CREATE PROCEDURE [dbo].[GetUserRole]
  	-- Add the parameters for the stored procedure here
  	@username varchar(50)
  	
  	
  AS
  BEGIN
  	-- SET NOCOUNT ON added to prevent extra result sets from
  	-- interfering with SELECT statements.
  	SET NOCOUNT ON;
  
      -- Insert statements for procedure here
  	select Roles.RoleName from Users inner join UserRoles on Users.ID=UserRoles.UserID
  	inner join Roles on Roles.ID=UserRoles.RoleID
  	
  	where Users.UserName=@username
  END
  '
  END
  GO
  /****** Object:  ForeignKey [FK_UserRoles_Roles]    Script Date: 05/31/2011 12:18:02 ******/
  IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_UserRoles_Roles]') AND parent_object_id = OBJECT_ID(N'[dbo].[UserRoles]'))
  ALTER TABLE [dbo].[UserRoles]  WITH CHECK ADD  CONSTRAINT [FK_UserRoles_Roles] FOREIGN KEY([RoleID])
  REFERENCES [dbo].[Roles] ([ID])
  GO
  IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_UserRoles_Roles]') AND parent_object_id = OBJECT_ID(N'[dbo].[UserRoles]'))
  ALTER TABLE [dbo].[UserRoles] CHECK CONSTRAINT [FK_UserRoles_Roles]
  GO
  /****** Object:  ForeignKey [FK_UserRoles_Users]    Script Date: 05/31/2011 12:18:02 ******/
  IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_UserRoles_Users]') AND parent_object_id = OBJECT_ID(N'[dbo].[UserRoles]'))
  ALTER TABLE [dbo].[UserRoles]  WITH CHECK ADD  CONSTRAINT [FK_UserRoles_Users] FOREIGN KEY([UserID])
  REFERENCES [dbo].[Users] ([ID])
  GO
  IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_UserRoles_Users]') AND parent_object_id = OBJECT_ID(N'[dbo].[UserRoles]'))
  ALTER TABLE [dbo].[UserRoles] CHECK CONSTRAINT [FK_UserRoles_Users]
  GO

  
  
  

• • Reply
  

  TimoYang

  Contributor

  3732 Points

  1275 Posts

  Re: Social Website Database -Online application

  Jun 15, 2012 06:31 AM|LINK

  Have you executed it yet directly？

• • Reply
  

  Saby2012

  Member

  160 Points

  150 Posts

  Re: Social Website Database -Online application

  Jun 15, 2012 06:34 AM|LINK

  Yes,

  I open SQL Management studio> file> open > select the file ...

  :(