Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
asm
Posting Yak Master
140 Posts |
 Posted - 2014-10-04 : 03:43:19
|
| Hi,Trying to create a view in SQL Server 2014, like create view testasselect billno, CONVERT(char(10), billdt, 103) from BILL but view not created, error Msg 4511, Level 16, State 1, Procedure test, Line 8Create View or Function failed because no column name was specified for column 2. |
|
|
asm
Posting Yak Master
140 Posts |
Posted - 2014-10-04 : 04:40:37
|
| ok , done its required alias name in last. |
 |
|
|
|
|
|
View