C Net Code
A blog about Microsoft Technology like ASP.NET,C#.NET,SQL Server, Ajax that majorly focus on code, tips ,tweaks and tricks.
Sunday, July 29, 2012
Thursday, July 26, 2012
Alter Encrypted Stored Procedure
How to Alter Encrypted Stored Procedure ?
Yesterday i wrote about how to write a Stored procedure in a encrypted manner. If Stored Procedure or User Defined Function are created WITH ENCRYPTION keyword then is not possible to decrypt it using SQL Server commands. It is always advised to save a copy of the script used to create the SP or UDF on other media source than SQL Server.
Yesterday i wrote about how to write a Stored procedure in a encrypted manner. If Stored Procedure or User Defined Function are created WITH ENCRYPTION keyword then is not possible to decrypt it using SQL Server commands. It is always advised to save a copy of the script used to create the SP or UDF on other media source than SQL Server.
Encrypted Stored Procedure
How to write a encrypted Stored Procedure?
Sometimes we need to write a stored procedure so that alternative user cannot see written text within Stored Procedure.
Even you may be ineffective to see the text of the encrypted Stored Procedure in SQL Server Activity Monitor moreover as by using Sp_helptext SpName methodology.
So what's the command to write encrypted stored procedure.
Let See
Sometimes we need to write a stored procedure so that alternative user cannot see written text within Stored Procedure.
Even you may be ineffective to see the text of the encrypted Stored Procedure in SQL Server Activity Monitor moreover as by using Sp_helptext SpName methodology.
So what's the command to write encrypted stored procedure.
Let See
Tuesday, July 24, 2012
What's New in ASP.NET 4.5 and Visual Web Developer 11 Developer Preview
This document lists options and enhancements that are being introduced in ASP.NET 4.5. It conjointly lists enhancements being created for internet development in Visual Studio (Visual internet Developer).
- ASP.NET Core Runtime and Framework
- Asynchronously Reading and Writing HTTP Requests and Responses.
- Enhancements to HttpRequest handling
- Asynchronously flushing a response
- Support for await and Task-Based Asynchronous Modules and Handlers
- Asynchronous HTTP modules
- Asynchronous HTTP handlers
- New ASP.NET Request Validation options
- Deferred ("lazy") request validation
- Support for unvalidated requests.
Monday, July 23, 2012
UNION VS UNION ALL
UNION VS UNION ALL
UNION
The UNION command is employed to pick connected info from 2 tables, very similar to the be a part of command. However, when using the UNION command all selected columns have to be compelled to be of constant knowledge kind. With UNION, solely distinct values are selected.
UNION ALL
The UNION ALL command is equal to the UNION command, except that UNION ALL selects all values.
The distinction between Union and Union all is that Union all won't eliminate duplicate rows, instead it simply pulls all rows from all tables fitting your question specifics and combines them into a table.
A UNION statement effectively will a pick DISTINCT on the results set. If you recognize that each one the records came back are distinctive from your union, use UNION ALL instead, it offers faster results.
UNION
The UNION command is employed to pick connected info from 2 tables, very similar to the be a part of command. However, when using the UNION command all selected columns have to be compelled to be of constant knowledge kind. With UNION, solely distinct values are selected.
UNION ALL
The UNION ALL command is equal to the UNION command, except that UNION ALL selects all values.
The distinction between Union and Union all is that Union all won't eliminate duplicate rows, instead it simply pulls all rows from all tables fitting your question specifics and combines them into a table.
A UNION statement effectively will a pick DISTINCT on the results set. If you recognize that each one the records came back are distinctive from your union, use UNION ALL instead, it offers faster results.
Subscribe to:
Posts (Atom)