Softminer.Net

Start with Latex

Posted on 2:33 AM by Softminer and filed under Latex

Update 2023 VS code can be used as Editor Installation

Prequisit:Basic Miktext arround 138 MB

VS Code

VS extension: Latext Workshop

Hint: Run VS as Administrator & No need for PERL

1.Download TexMaker ( Free Latex Editor ) from http://www.xm1math.net/texmaker/download.html

2.Download "Basic MiKTeX 2.7" Installer Size: 82.33 MB from http://miktex.org/2.7/setup

3. Run TexMaker and Set the configuration of MikTex ( by default every thing should work)

PS: I tested all in Windows XP and I just installed and run

How to add Created and Modified to SQL server tables using Trigger

Posted on 1:49 AM by Softminer and filed under SQL

1. to add Created and Modified column to Table
2. add Update trigger
3. add Insert trigger

ALTER TABLE Table1
ADD Created datetime null,Modified datetime null
go

CREATE TRIGGER [TriggerUpdate]
ON [dbo].[Table1]
FOR UPDATE
AS
update Table1 set Modified = getdate() where Id in (SELECT Id FROM inserted)
go

CREATE TRIGGER [TriggerInsert]
ON [dbo].[Table1]
FOR INSERT
AS
update Table1 set Created= getdate() where Id in (SELECT Id FROM inserted)