Whats new in Microsoft Sql Server 7 – Development

This is third and final part of Whats new in microsoft Sql Server 7:
c. Development:
 

 
Sql Server 6x Sql Server 7  
Development     Remark
    English Query  
    OLE DB  
T-Sql      
Unicode data type NA new…  nchar, nvarchar and ntext 2 bytes
    TOP n [percent]  
    improve cursor  
    multiple triggers and recursive triggers  
identifier 30 character 128 character  
  [] [] and "" delimiting identifiers
can   change the data type of existing column  
  nullable column can be added into table non nullable column can be added into table  
       
char and binary data limit 255 bytes 8000 bytes  
    uniqueidentifier (GUID ) data type  
ANSI NULL default is OFF ON  
quoted identified OFF ON  
       
       
New T-SQL   alter procedure  
    alter trigger  
    alter view  
    alter table  
    bulk insert  
    commit work and rollback work  
    deny  
    restore  
    restore filelistonly/headeronly/labelonly/verifyonly  
Cursor   local and cursor variable & parameter  

 
Thanx.
Vinay
 
 
Referrance
Advertisements
This entry was posted in Whats New. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s