Database

David Skelly wrote:

SQLite datatypes are a bit weird because you don't tell it in advance what the datatype of a column will be.

David Skelly wrote:

The biggest potential problem is that it is a single user database.

David Skelly wrote:

Personally, I don't like SQLite

I are troll

select cola, colb
from(
   select cola, colb from table1
   union all
   select cola, colb from table2
) d
order by cola

select disk_reads,sql_text 
from v$sqlarea 
where disk_reads > 10000 
order by disk_reads desc

if not exists(select * from tblStafff where StaffID = @StaffID)
Begin
   -- Add record
End

ALTER PROCEDURE SP_CHECKDUPLICATEID
	-- Add the parameters for the stored procedure here
	(@ID INT)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here

	-- VARIABLE DECLARATIONS
	
    IF ( (SELECT COUNT(*) FROM TBLSTAFF WHERE ID=@ID) = 0 )

	BEGIN

		INSERT INTO TBLSTAFF(ID) VALUES(@ID)

	END
END
GO