Activity overview
Latest activity by math1611
Data Diagrams
Is there a way to compare database diagrams using SQL Compare?
1. Create two tables with same Namespace:
CREATE TABLE [dbo].[Base.Department](
[DepartmentID] [int] IDENTITY(1,1) NOT NULL,
[Department] [varchar](50) NULL,
[SortOrder] [tinyint] NULL,
[Active] [bit] NULL)
GO
CREATE TABLE [dbo].[Billing.Country](
[CountryID] [int] IDENTITY(1,1) NOT NULL,
[ISO2] [char](2) NOT NULL,
[CountryName] [varchar](50) NOT NULL,
[PrintableName] [varchar](80) NOT NULL,
[ISO3] [char](3) NULL)
GO
2. Ctrl-Shift-D to refresh suggestions for SQL Prompt
3. Begin typing 'Select * from Billing' - do not type the dot yet.
At this point it shows the two tables in the intellisense
4. Press the dot
The intellisense for the tables goes away and I see the list of code snippets.
Thanks / comments
1. Create two tables with same Namespace:
CREATE TABLE [dbo].[Base.Department](
[DepartmentID] [int] IDENTITY(1,1) NOT NULL,
[Department] [varchar](50) NULL,
[SortOrder] [tinyint] NULL,
[Active] [...
Select statement - tables with a dot in the name
I have several tables that start with 'Billing.'
When I start the select statement 'Select * from Billing' the intellisense is fine. As soon as a press the dot (.) the intellisense disappears.
I h...