I've been working with SQL Views for a while now, and I recently read that something that I want to do requires that one of my views be created with schemabinding. That sounds fine, but I get a syntax error when I try to follow along with an example:
CREATE VIEW dbo.MyView WTIH SCHEMABINDING AS SELECT t1.a, t2.b FROM dbo.Table1 t1 INNER JOIN dbo.Table2 t2 ON t1.x = t2.x;
I get the following error in SQL Server Management Studio 2012:
Msg 102, Level 15, State 1, Procedure DHRA_Appointment, Line 2 Incorrect syntax near 'WTIH'.
This looks like some simple error in my SQL. What am I doing wrong?