DataBase
SqlServer Cash Dependencies
Using SQL Cache Dependencies This is the C# tutorial (Switch to the Visual Basic tutorial) The simplest caching strategy is to allow cached data to expire after a specified period of time. But this simple approach means that the cached data maintains no association with its underlying data source, resulting in stale data that is held [...]
Read Full Post | Make a Comment ( None so far )using Functions
/*This fuction we use it almost with lookup table to return the name it takes two parameters first one display the table and the second one display the id that we want to return its related name*/ USE [databaseName] GO SET /****** Object: UserDefinedFunction [dbo].[GetName] **/ ANSI_NULLS ONGO SET QUOTED_IDENTIFIER [...]
Read Full Post | Make a Comment ( None so far )Oracle create a sequence
CREATE SEQUENCE supplier_seq MINVALUE 1 MAXVALUE 999999999999999999999999999 START WITH 1 INCREMENT BY 1 CACHE 20; http://psoug.org/reference/sequences.html
Read Full Post | Make a Comment ( None so far )Oracle (Create sequence)
CREATE SEQUENCE supplier_seq MINVALUE 1 MAXVALUE 999999999999999999999999999 START WITH 1 INCREMENT BY 1 CACHE 20; http://psoug.org/reference/sequences.html
Read Full Post | Make a Comment ( None so far )Rename A column name in sql query (Oracle VS Sqlserver)
Oracle (select studentName as “Student Name” ) SqlServer (select studentName as [Student Name])
Read Full Post | Make a Comment ( None so far )
