Friday, 7 December 2018

Last Created Store Procedure SQL Server


SELECT * FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE = N'PROCEDURE' and ROUTINE_SCHEMA = N'dbo'
order by last_altered desc


Monday, 26 November 2018

Get input type file size in KB


HTML

<input type="file" class="upload" onchange="readURL(this)" id="file" accept="image/x-
png,image/jpeg" />

<input type="button" value="Upload" class="btn btn-default" style="margin:auto;display:block" onclick="UploadPaper()" />

Java Script


function UploadPaper()
{
    ValidatePaper();

Saturday, 10 November 2018

Alter Table SQL Server

Making Unique key


Syntax :

alter table your_table add constraint constraint_Name  unique(yourcolumn);