HTML5 Support for the Visual Studio 2010 Editor
HTML5 moves fast, and this update will aim to keep up with it. It adds support to Visual Studio and the editor for HTML5, CSS3 and new JavaScript features. The goal is perhaps an update every quarter or so as new features or elements emerge. We want ASP.NET web developers to always be able to use the latest standards, as well as being able to choose from existing standards. Remember that you can use HTML5 today along with JavaScript libraries like Modernizr that allow you to create pages that work across nearly all browsers, including old crappy ones.
OBIEE - Passing Filters through an URL
An URL must be encoded before that you can use it.
■All spaces must be replace with the %20 sign
■When you cast a number as char, you may have to trim it to suppress the blank character
■When you pass a string variable, you may have to replace the blank character by %20
SQL Server does not provide an internal method of securing individual rows in the database. However, by using SQL Server views, it's possible to provide row-level security without too much effort. The primary component in a row-level security system is the use of views. Creating a view that resides on top of the table and giving the user access to the view but not the underlying table can enforce an effective row-level security system.
http://www.techrepublic.com/article/locking-down-microsoft-sql-server/5031954
CREATE FUNCTION [dbo].[JDT_GTJ] (@DATE datetime)
RETURNS varchar(12)
AS
BEGIN
declare @y as varchar(10)
declare @dy as varchar(10)
declare @date1 as datetime
declare @szupmj as varchar(10)
if(@DATE='')
Begin
set @date1= getdate()
End
if(@DATE<>'')
Begin
set @date1= @DATE
End
set @y =(datepart(yy,@date1) - 1900) * 1000;
set @dy = datepart(dy,@date1);
set @szupmj = @y + cast(@dy as int);
RETURN(@szupmj);
END;
CREATE FUNCTION [dbo].[JDT_JTG] (@DATE int)
RETURNS varchar(20)
AS
BEGIN
declare @rpdivj as int
declare @datea as datetime
declare @szupmj as varchar(10)
set @rpdivj=@DATE
set @datea= DATEADD(dy, @rpdivj % 1000, DATEADD(yy, @rpdivj / 1000,-1))
set @szupmj=convert(varchar,@datea,101) --DATEADD(dy, @rpdivj % 1000, DATEADD(yy, @rpdivj / 1000, -1))
RETURN(@szupmj);
END;
