'Word.Application' is not defined "aspnet_compiler.exe" exited with code 1 "Cannot create ActiveX Component" "Exception from HRESULT: 0x800A03EC" Unable to open excel file "Failed to compare two elements in the array." "Object reference not set to an instance of an object" error which po...
It will send output to the SQL Server Management Studio Message Window! This make is a good tool for general debugging and playing around with stored procedures: Database Cursor Example Output I hope you now have a better appreciate of cursors. In future articles I go into greater depth on...
To better understand and work with GUIDs, you can create SQL functions that decompose GUIDs into their components and show their ordering. To understand how the GUID is decomposed I would like to share this function. CREATEFUNCTIONdbo.DescomponerGUIDString(@guidUNIQUEIDENTIFIER...
nvarchar is suitable for variable-length Unicode text. ntext is a legacy type for large blocks of Unicode text and should be replaced by nvarchar(max). NOTE: SQL Server provides a hybrid model for storing and processing both relational and JSON data. While there is no dedicated SQL Server JS...
In the above example, we have used the ‘SUBSTRING’ function in which the first argument is the string and the second argument is the index of the character from which the string has begun, and the third is the length that we require so it will give the string having email column which...
I am using SSMA for ACCESS and I want to use the console.EXE so that I can automate the migration of ~25 separate databases all to the same SQL Server instance. I am able to use the GUI to achieve the results that I want but I do not want ot have to…
In the above example, you can see that there are 12 bytes in the word Tutorialscan. This also happens to be exactly how many characters are in the string. This SQL serverDATALENGTH() functionis very useful for NVARCHAR, VARCHAR, TEXT, NTEXT, VARBINARY and IMAGE data types because these da...
or the column is NCHAR or NVARCHAR, you can use sql like this: SELECT [customer_name] FROM [customer] WHERE UNICODE( LEFT([customer_name], 1)) = UNICODE( UPPER(LEFT([customer_name], 1))) BUT, those sql might cause index ignored, SO MAY NOT fit on performance sensitive scene ...
What is a heap table, how to create and when to use it. Along the way, we will understand the concept of Table Scan as well. We will also look at a simple example in action, where a full table scan is better from performance standpoint than using a table
of the SQL commands/keywords like SELECT, INSERT, DELETE, DROP, UPDATE, ALTER etc and it end with a semicolon; Example explanation: SELECT column_name from table_name; Now let us know the reason for semicolon being used. Why is semicolon used after SQL statements/commands?