Click here to Skip to main content
Click here to Skip to main content

Default keyword in SQL Server

, 12 Jun 2011 CPOL
Rate this:
Please Sign up or sign in to vote.
Default keyword in SQL Server
I discovered a handy little trick today with regard to calling SQL Server objects:
 
http://www.dba-sql-server.com/sql_server_tips/t_super_sql_439_default_keyword.htm[^]
 
You can use this in a database where you have many, many nested function calls. Essentially, if you have a default specified on a parameter in the middle of the parameter list, you can call that default using the "default" keyword. So if it changes later, you don't have to go searching for references to the function and change them all back.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Mel Padden
Architect UBS AG
Switzerland Switzerland
Mel Padden:
 
Musician, papier maché guru, international authority on the modern crisp, and sometime software developer based in Zurich, Switzerland and Dublin, Ireland.
 
http://www.linkedin.com/in/melpadden
Follow on   Twitter

Comments and Discussions

 
GeneralNice PinmemberShahriar Iqbal Chowdhury12-Jun-11 21:27 
GeneralReason for my vote of 5 Nice PinmemberShahriar Iqbal Chowdhury12-Jun-11 21:27 
Generalnice link, my 5. PinmemberMonjurul Habib9-Jun-11 11:44 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.141223.1 | Last Updated 12 Jun 2011
Article Copyright 2011 by Mel Padden
Everything else Copyright © CodeProject, 1999-2014
Layout: fixed | fluid