{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 时光不老，我们不散 的问题《T-SQL's equivalent of Oracle's %TYPE opera》','https://www.manongdao.com/q-562876.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
When writing a procedure in PL/SQL, I can declare a parameter's type as myTable.myColumn%TYPE so that when I alter myColumn's type from say varchar2(20) to varchar2(50) I don't have to change the procedure's parameter type. Is there something similar in T-SQL?
相关问题
- sql execution latency when assign to a variable
- What is the best way to cache a table from a (SQL)
- php PDO::FETCH_ASSOC doesnt detect select after ba
- Bulk update SQL Server C#
- SQL to Parse a Key-Value String
相关文章
- node连接远程oracle报错
- oracle 11g expdp导出作业调用失败，提示丢包。
- 执行一复杂的SQL语句效率高，还是执行多少简单的语句效率高
- Entity Framework 4.3.1 failing to create (/open) a
- How to truncate seconds in TSQL?
- Oracle equivalent of PostgreSQL INSERT…RETURNING *
- Code for inserting data into SQL Server database u
- Delete Every Alternate Row in SQL
No, there is no equivalent in T-SQL.
The best that you could do would be to create a user-defined data type, then you could change the underlying UDT and it would take effect in both places.
This would affect it everywhere that you use it, so if you used the type in multiple tables it would affect them all if you changed it.