vcV1fWNJ

1IF EXISTS (SELECT * FROM sys.tables WHERE name = 'Phones')
2BEGIN
3    DROP TABLE Phones
4END
5GO
6
7CREATE TABLE [dbo].[Phones]
8(
9    [ID] [int] IDENTITY(1,1) NOT NULL,
10    [Mobile] [nvarchar](50) NOT NULL,
11    CONSTRAINT [PK_Phones] PRIMARY KEY CLUSTERED 
12    ( [ID] ASC )
13    WITH (
14      PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, 
15      IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, 
16      ALLOW_PAGE_LOCKS = ON ) ON [PRIMARY]
17) ON [PRIMARY]
18GO
19
20DECLARE @biMobile_1 bigint
21DECLARE @biMobile_2 bigint
22SET @biMobile_1 = 12121111111
23SET @biMobile_2 = 12129999999
24
25Print 'Inserting Phone Number'
26INSERT INTO Phones (Mobile) VALUES ('12121111111')
27
28Print 'Selecting Phone Number'
29SELECT * FROM Phones WHERE Mobile = @biMobile_1 --Select #1
30
31Print 'Inserting Junk Data'
32INSERT INTO Phones (Mobile) VALUES ('JUNK DATA')
33INSERT INTO Phones (Mobile) VALUES ('12129999999')
34
35Print 'Selecting From Table Containing Junk'
36SELECT * FROM Phones WHERE Mobile = @biMobile_1 -- Select #2
37SELECT * FROM Phones WHERE Mobile = @biMobile_2 -- Select #3
38	
39Error converting data type nvarchar to bigint.
40	
41SELECT * FROM Phones WHERE Mobile = cast(@biMobile_1 as varchar(50))
42	
43SELECT * FROM Phones WHERE Mobile = convert(nvarchar,@biMobile_2)