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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 HOW TO ADD A NEW FIELD IN A VIEW ON SQL SERVER2005

Author  Topic 

tahseenm
Yak Posting Veteran

64 Posts

Posted - 2010-01-14 : 13:11:25
I ALREADY HAVE A VIEW I.E. QUERY IN MY LIVE DB. ALL I NEED TO ADD A BLANK FIELD ON IT. CAN SOMEBODY KNOW HOW TO ADD. THANKS AND APPRECIATE YOUR QUICK RESPONSE

moetahsen

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-01-14 : 13:13:37
[code]Select your current fields...., '' AS NewfieldNameHere FROM....[/code]
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-01-14 : 13:14:01
ALTER VIEW YourView
AS

SELECT ..., '' AS BlankField
FROM ...
...
GO

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -