If you want to restrict other developers from using your Stored Procedures that returns a huge amount of data which affects server performance and Application Performance weather it is a Windows or Web Application.You can use the following idea when you create Stored Procedures:-- ============================================= -- Author: ...
XML is a platform-independent data representation format based originally on SGML. Since its popularization, it is becoming used as a data storage format. It has its own type system, based on the XML Schema Definition language (XSD). Both XML and XSD are W3C standards at the Recommendation level. An XML...
If you are a SQL Server developer or database administrator, you might just be inclined to use the new Common Language Runtime (CLR) hosting feature to write stored procedures in C# or VB.NET without knowing how it works. But you should care. SQL Server is an enterprise application, perhaps one...
Information about assemblies as well as the assembly code itself and the dependencies is stored in the system metadata tables, which, in general, store information about SQL Server database objects, such as tables and indexes. Some metadata tables store information for the entire database instance and exist only in the ...
It is a way of hacking on a database driven application in which the hacker executes unauthorized SQL commands by taking advantage of insecure code on a system connected to the Internet, bypassing the firewall.SQL injection hackers are used to steal information from a database from which the data would...
Introduction:When you try to connect to an instance of Microsoft SQL Server from a remote computer, you may receive an error message. This problem may occur when you use any program to connect to SQL Server.For example, you receive the following error message when you use the SQL Management Studio...
We were working on a database which has a column for storing an image path. The path has been changed and we need now to update that column with the new path.Please find below a simple SQL update statement that replaces text, you may use it with any column that...
Sometimes you may want to get rid of all the open connections to a database for many reasons. One of the reasons could be delete the database or detach the database in order to move it to another server.But you will not be able to do that if there are...
