SQL Server Management Studio – tips for improving the TSQL coding process -

-

i used work in place common practice use pair programming. remember how many small things learn each other when working on code. picking new shortcuts, code snippets etc. time improved our efficiency of writing code.

since started working sql server have been left on own. best habits pick working other people cannot now.

so here question:

  • what tips on efficiently writing tsql code using sql server management studio?
  • please keep tips 2 – 3 things/shortcuts think improve speed of coding
  • please stay within scope of tsql , sql server management studio 2005/2008 if feature specific version of management studio please indicate: e.g. “works sql server 2008 only"

edit:

i afraid have been misunderstood of you. not looking tips writing efficient tsql code rather advice on how efficiently use management studio speed coding process itself.

the type of answers looking are:

  • use of templates,
  • keyboard-shortcuts,
  • use of intellisense plugins etc.

basically little things make coding experience bit more efficient , pleasant.

take @ red gate's sql prompt - it's great product (as of red gate's contributions)

sql inform great free (online) tool formatting long procedures can out of hand.

apart that, i've learned painful experience it's thing precede any delete statement a begin transaction. once you're sure statement deleting should, can commit.

saved me on number of occasions ;-)


Comments

Post a Comment

Popular posts from this blog

c++ - How do I get a multi line tooltip in MFC -

-
right now, have tool tip pops when hover on edit box. problem tool tip contains multiple error messages , in 1 long line. need have each error message on own line. error messages contained in cstring new line seperating them. my existing code below. bool ontooltiptext(uint, nmhdr* pnmhdr, lresult* presult) { assert(pnmhdr->code == ttn_needtexta || pnmhdr->code == ttn_needtextw); // need handle both ansi , unicode versions of message tooltiptexta* pttta = (tooltiptexta*)pnmhdr; tooltiptextw* ptttw = (tooltiptextw*)pnmhdr; // tchar szfulltext[256]; cstring strtiptext=_t(""); uint nid = pnmhdr->idfrom; if (pnmhdr->code == ttn_needtexta && (pttta->uflags & ttf_idishwnd) || pnmhdr->code == ttn_needtextw && (ptttw->uflags & ttf_idishwnd)) { // idfrom hwnd of tool nid = ::getdlgctrlid((hwnd)nid); } //m_errprojaccel[ch] contains 1 or more error messages each...
Read more

asp.net - In javascript how to find the height and width -

-
i having .aspx , masterpage page. in masterpage loading aspx page . in aspx page design using generating table structure using code-behind server in javascript how find height , width . regards, kumar if you're looking table height , width, should it var tbl = document.getelementbyid('tbldemo'); alert(tbl.offsetwidth + '\n' + tbl.offsetheight);
Read more

c# - DataTable to EnumerableRowCollection -

-
i have datatable according client requirement can contain invalid date "00/00/1999",null,empty string.(typed datset) when collect them enumerables wish convert of invalid forms empty string. (i.e) enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || (how check date invalid date) ? string.empty : order.field<datetime>("orderdate") } how check whether date valid date or not? datetime.tryparse...like given current code: datetime date; enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || !datetime.tryparse(convert.tostring(order.field<datetime...
Read more