In SSMS I would like to include square brackets for schema. If dbo is schema name is dbo otherwise the schema name is xxxx.yyyy
dbo.spSomeName should be replaced as [dbo].[spSomeName]
dbo.tSomeName should be replaced as [dbo].[tSomeName]
MyDB.AnySchema.spSomeName should be replaced as [MyDB.AnySchema].[spSomeName]
MyDB.AnySchema.tSomeName should be replaced as [MyDB.AnySchema].[tSomeName]
How to achieve this using Regex replace? Please suggest
Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted? Many believe this is the case.
Let us try to examine for ourselves with an example.
To get started, use the following script, wh…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory.
NOTE: For Outlook 2016 and 2013 perform the exact same steps.
Open a new email: Click the New email button in Outlook.
Start typing the address: …