Database

Dmitry Khudorozhkov wrote:

First question: is this a good db structure?

Select *
From Users
 inner join Addresses on Addresses.UserID = User.ID
where Users.ID = @IDno

declare @t table(somevalue varchar(100),startdate datetime, enddate datetime)
insert into @t 
	select 'somevalue1','01/14/2009', '01/20/2009' union all
	select 'somevalue2','01/15/2009', '01/22/2009' union all
	select 'somevalue3','01/18/2009', '01/31/2009' union all
	select 'somevalue4','02/01/2009', '02/10/2009' union all
	select 'somevalue5','05/14/2009', '05/20/2009' 

select * from @t
where startdate >='01/14/2009' and enddate <='02/01/2009'

somevalue1	2009-01-14 00:00:00.000	2009-01-20 00:00:00.000
somevalue2	2009-01-15 00:00:00.000	2009-01-22 00:00:00.000
somevalue3	2009-01-18 00:00:00.000	2009-01-31 00:00:00.000

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER PROCEDURE [dbo].[sp_ClearDatabaseConnections] 

@DBNAME VARCHAR(255)

AS

SET NOCOUNT ON

DECLARE @SPID INT, @STR VARCHAR(255)

DECLARE USERS CURSOR FOR
	SELECT SPID
	FROM MASTER..SYSPROCESSES
	WHERE DB_NAME(DBID) = @DBNAME

OPEN USERS
FETCH NEXT FROM USERS INTO @SPID

WHILE @@FETCH_STATUS <> -1
BEGIN
   IF @@FETCH_STATUS = 0
   BEGIN
      SET @STR = 'KILL ' + CONVERT(VARCHAR, @SPID)
      EXEC (@STR)
   END
   FETCH NEXT FROM USERS INTO @SPID
END

DEALLOCATE USERS