Activity overview
Latest activity by BPYMKJ
If you use SQL search to do an exact search for “INSERT dbo.Person†/ comments
If you use SQL search to do an exact search for “INSERT dbo.Personâ€
Here is how to reproduce my bug. You will need to create the following objects in a test database (I just used AdventureWorks for convenience).
USE [AdventureWorks2012]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Person](
[person_id] [int] IDENTITY(1,1) NOT NULL,
[first_name] [varchar](50) NOT NULL,
[last_name] [varchar](50) NOT NULL,
CONSTRAINT [PK_Person] PRIMARY KEY CLUSTERED
(
[person_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
USE [AdventureWorks2012]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Quick_Note](
[quick_note_id] [int] IDENTITY(1,1) NOT NULL,
[note] [varchar](255) NOT NULL,
CONSTRAINT [PK_Quick_Note] PRIMARY KEY CLUSTERED
(
[quick_note_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
USE [AdventureWorks2012]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[usp_Create_Person] @first_name VARCHAR(50), @last_name VARCHAR(50)
AS
BEGIN
INSERT dbo.Person (first_name, last_name) VALUES (@first_name, @last_name)
END
GO
USE [AdventureWorks2012]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[usp_Create_Quick_Note] @note VARCHAR(255)
AS
BEGIN
INSERT dbo.Quick_Note (note) VALUES (@note)
END
GO / comments
Here is how to reproduce my bug. You will need to create the following objects in a test database (I just used AdventureWorks for convenience).
USE [AdventureWorks2012]
GO
SET ANSI_NULLS ON
GO
SET ...
Different Results on Different Machines
Hello,
I am having difficulty regarding SQL Search. I am trying to perform an exact search for a string with a space:
“insert dbo.MYTABLENAMEâ€