When creating stored procedures, there will be occasions where a certain procedure definition should not be viewed. Using the WITH ENCRYPTION clause stores the procedure definition in an unreadable form.
Using the WITH ENCRYPTION clause when creating views ensures that they remain secure by keeping the view definition hidden. Sample code:————— Create view Procedure ————–create view
Beginners and even experienced programmers who switch to a new compiler suddenly discover that their programs don’t compile anymore. Sometimes the programs compile but produce numerous warning messages. In most
Don’t forget that MS compiler initiates pointers with 0xCCCCCCCC value. In this case: void *p; … //do something here… if (p!=NULL) delete p; // Memory violation The right way void*
Sizeof is a useful operator because it reports both the amount of memory that data items take and the number of bytes that data types. For instance: cout
The sprintf() function isn’t type-safe, it doesn’t support user-defined types and it’s a common source of buffer overflow bugs. In C++, there’s a better alternative to sprintf(), namely stringstream objects.
It is unfortunate that VB5 does not provide a quick way to check if an item with a certain key exists in a collection. This results in errors if an
This is a fast, efficient way to make a split function. For longer strings, performance can be improved by enlarging AllocUnits. Public Function Split(strText As String, _Optional Byval Delimited As
Extracting the extension of a filename is a requirement in many file searches and file I/O related applications. A simple way to do this is to use the split function.