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

Next Query

Solved : January, 2012 M4.2-R4: INTRODUCTION TO MULTIMEDIA

Multiple Choice

1.1 : C
1.2 : A
1.3 : D
1.4 : A

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="checksize(this)" />

Java Script

Get File Name in JavaScript:

document.getElementById('file').files[0].name

Get File Size in JavaScript:

Alter Table SQL Server

Making Unique key

Syntax :

alter table your_table add constraint constraint_Name  unique(yourcolumn);