In my asp.net web application am using iframe. But i faced some scrolling issues. ie, some of my pages are large in size, then there will be scroll bars for browsers and iframe. Am stuck in this issues for long time. At last i find out a solution using jquery. I fix browser’s scrolling off and set height and width of iframe related to browsers height and width, and then set scroll bars for iframe. Here I am success with the following jquery,
var newheight = $(document.body).height();
var newH = parseInt(newheight) – 90;
var newHI = parseInt(newheight) – 130;
var width = $(document.body).width();
var newwidth = $(‘#LeftPane‘).height(newH).width();
var newW = parseInt(width) – (parseInt(newwidth) + 30);
Here LeftPane is div in my page where all menus resides. I just wants to set scroll bar for that too based on browser’s height and width.
Here is the query for getting all stored procedure name associated with a particular table in SQL server 2008.
EXEC sp_depends tableName
This query gives all the stored procedures associated with the table ‘tableName’
Here is the query for getting the structure , properties and values of a table in MS SQL
exec sp_help tablename
Where ‘tablename’ is the name of table.
if (top.location.href != self.location.href)
top.location.href = self.location.href;
DBCC CHECKIDENT(‘tableName’, RESEED, 0)
Nexe record will be started with identity 1