In Microsoft SQL Server Reporting Services did you know that we can display html text as well ? Why should you be even excited about the ability to display HTML in the reports, well here are the reasons It will let you display HTML mark up text like Bold text, colored text and much more. … Continue reading How to display HTML content in Microsoft Reporting Services report
Database(s)
Table variable based Template to iterate through the default constraints of the tables
Get a list of default value constraints in sql server and replace them to your wish
One day, while working on a project. I hit a wall. The wall says, the date and time should be displayed according to the local datetime settings. E.g: A visitor while visiting the site, should display the US date and time (dd/mm/yyyy), where as a user visiting the site from india, should have india date … Continue reading Get a list of default value constraints in sql server and replace them to your wish
The OLE DB provider “OraOLEDB.Oracle” for linked server “” returned a “NON-CLUSTERED and NOT INTEGRATED” index “” with the incorrect bookmark ordinal 0
The good thing with linked servers is, you can write queries to fetch the data from a remote server (via linked) in your sql procedures and more. We happened to test the connectivity of a oracle server due to an upgrade. When a new Linked server connection is created using the UI and ran a … Continue reading The OLE DB provider “OraOLEDB.Oracle” for linked server “” returned a “NON-CLUSTERED and NOT INTEGRATED” index “” with the incorrect bookmark ordinal 0
SQL SERVER Cursor Template
A sql code pasted here so it can be referred easily. /***************************************************************** Cursor Template ****************************************************************/ Declare @vendor_id int; Declare @vendor_name varchar(10); DECLARE curName CURSOR FOR SELECT BusinessEntityID, Name FROM Purchasing.Vendor WHERE PreferredVendorStatus = 1 ORDER BY BusinessEntityID; --Replace this line to suit your needs OPEN curName; FETCH NEXT FROM curName INTO @vendor_id, @vendor_name; WHILE @@FETCH_STATUS … Continue reading SQL SERVER Cursor Template
Devakumar Sai Chinthala 