Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Create Table dbo.TestTable (TestID int, TestValue varchar(5))
- Go
- Create Function dbo.TestTVF ()
- Returns Table
- As
- Return (Select * From dbo.TestTable)
- Go
- Select *
- From dbo.TestTVF();
- Go
- Alter Table dbo.TestTable Add TestValue2 varchar(5);
- Go
- Exec sp_refreshsqlmodule 'dbo.TestTVF';
- go
- Select *
- From dbo.TestTVF();
- Go
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement