{"id":"https://openalex.org/W1545366303","doi":null,"title":"SQL Server 2000 Stored Procedure Programming","display_name":"SQL Server 2000 Stored Procedure Programming","alternate_titles":[],"publication_year":2001,"publication_date":"2001-01-01","ids":{"openalex":"https://openalex.org/W1545366303","mag":"1545366303"},"language":"en","primary_location":{"id":"mag:1545366303","doi":null,"is_oa":false,"landing_page_url":"http://dl.acm.org/citation.cfm?id=560106","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W1545366303"],"child_works_count":0,"type":"book","is_traditional":true,"indexed_in":[],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5035293842","display_name":"Dejan Sunderic","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Dejan Sunderic","raw_affiliation_strings":["Trigon Blue, Inc.#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Trigon Blue, Inc.#TAB#","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5076354425","display_name":"Tom Woodhead","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Tom Woodhead","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.1141,"has_fulltext":false,"cited_by_count":6,"reviewed_by_count":0,"citation_normalized_percentile":{"value":0.82790698,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":87,"max":92},"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.7383000254631042,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.7383000254631042,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T13681","display_name":"Engineering and Information Technology","score":0.24449999630451202,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10430","display_name":"Software Engineering Techniques and Practices","score":0.0012000000569969416,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/microsoft-sql-server-2000","display_name":"SQL Server 2000","score":0.9649999737739563},{"id":"https://openalex.org/keywords/stored-procedures","display_name":"stored procedures","score":0.9810000061988831},{"id":"https://openalex.org/keywords/t-sql","display_name":"T-SQL","score":0.9380000233650208},{"id":"https://openalex.org/keywords/precipitating-factors","display_name":"precipitating factors","score":0.4869999885559082},{"id":"https://openalex.org/keywords/user-defined-functions","display_name":"user-defined functions","score":0.8389999866485596},{"id":"https://openalex.org/keywords/error-handling","display_name":"error handling","score":0.6000000238418579},{"id":"https://openalex.org/keywords/debugging","display_name":"debugging","score":0.32499998807907104},{"id":"https://openalex.org/keywords/cursor","display_name":"Cursor","score":0.6190000176429749},{"id":"https://openalex.org/keywords/temporary-tables","display_name":"temporary tables","score":0.6159999966621399},{"id":"https://openalex.org/keywords/xml","display_name":"XML","score":0.3190000057220459},{"id":"https://openalex.org/keywords/software-security","display_name":"software security","score":0.6159999966621399},{"id":"https://openalex.org/keywords/database-administration","display_name":"database administration","score":0.4699999988079071}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7631397247314453},{"id":"https://openalex.org/C141589383","wikidata":"https://www.wikidata.org/wiki/Q644775","display_name":"Data Transformation Services","level":5,"score":0.7186757326126099},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.6870801448822021},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6418126821517944},{"id":"https://openalex.org/C206384180","wikidata":"https://www.wikidata.org/wiki/Q599380","display_name":"User-defined function","level":5,"score":0.6384062767028809},{"id":"https://openalex.org/C114724005","wikidata":"https://www.wikidata.org/wiki/Q5001740","display_name":"Business Intelligence Markup Language","level":5,"score":0.6315647959709167},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5440226793289185},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.5131927132606506},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.4856216013431549},{"id":"https://openalex.org/C150451098","wikidata":"https://www.wikidata.org/wiki/Q506059","display_name":"SQL injection","level":5,"score":0.4581015408039093},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.4557669758796692},{"id":"https://openalex.org/C70236469","wikidata":"https://www.wikidata.org/wiki/Q1078262","display_name":"Database administrator","level":2,"score":0.443627268075943},{"id":"https://openalex.org/C168065819","wikidata":"https://www.wikidata.org/wiki/Q845566","display_name":"Debugging","level":2,"score":0.4333202838897705},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.3975265324115753},{"id":"https://openalex.org/C166930804","wikidata":"https://www.wikidata.org/wiki/Q573731","display_name":"Internet Authentication Service","level":3,"score":0.2904365658760071},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.25796639919281006},{"id":"https://openalex.org/C94925161","wikidata":"https://www.wikidata.org/wiki/Q6666854","display_name":"Log shipping","level":4,"score":0.2508063316345215},{"id":"https://openalex.org/C164554305","wikidata":"https://www.wikidata.org/wiki/Q71550","display_name":"Application server","level":2,"score":0.22352448105812073},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:1545366303","doi":null,"is_oa":false,"landing_page_url":"http://dl.acm.org/citation.cfm?id=560106","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2747066406","https://openalex.org/W2566535651","https://openalex.org/W565760824","https://openalex.org/W7098321576","https://openalex.org/W2410386247","https://openalex.org/W617510824","https://openalex.org/W2494626703","https://openalex.org/W2735667226","https://openalex.org/W2512476881","https://openalex.org/W86965572"],"abstract_inverted_index":{"From":[0],"the":[1,56,124],"Publisher:\r\nTired":[2],"of":[3,8,113],"pubs":[4],"and":[5,26,64,152,155,164,167,191,208,230,234],"Northwind?":[6],"Tired":[7],"books":[9],"that":[10],"just":[11,145],"lie":[12],"there?":[13],"This":[14,39,136],"book":[15,40],"will":[16],"engage":[17],"you":[18,91,127],"interactively":[19],"with":[20,149,202],"its":[21],"sample":[22],"Asset":[23],"tracking":[24],"database":[25],"end-of-chapter":[27],"exercises.":[28],"You'll":[29,103],"learn":[30,104],"by":[31],"doing.":[32],"\r\n\u0097Karen":[33],"Watterson,Editor,Pinnacle":[34],"Publishing's":[35],"SQL":[36,66,84,107,133,160,172,239],"Server":[37,67,85,108,134,161,173],"Professional\r\nFinally!":[38],"dedicated":[41],"to":[42,93,96,105,129,147,200],"T-SQL":[43],"Stored":[44,87],"Procedure":[45,88],"development":[46],"is":[47,59],"long":[48],"overdue.":[49],".":[50,51],"a":[52,180],"must":[53],"have":[54],"for":[55,141,157,169],"developer":[57],"who":[58,143],"serious":[60],"about":[61],"creating":[62],"powerful":[63],"scalable":[65],"2000":[68,86],"architectures.":[69],"\r\n\u0097Ed":[70],"Musters,Chief":[71],"Technology":[72],"Officer,Sage":[73],"Information":[74],"Consultants,Inc.":[75],"\r\nDesign,deploy,and":[76],"manage":[77,98,106],"stored":[78,100,150,162,188],"procedures":[79,151,163],"in":[80,215],"enterprise":[81],"data":[82],"applications":[83,237],"Programming":[89],"shows":[90],"how":[92],"use":[94],"Transact-SQL":[95],"design,debug,and":[97],"custom":[99],"procedures,functions,and":[101],"triggers.":[102],"resources":[109],"using":[110,193,212,221,238],"new":[111],"features":[112],"Enterprise":[114],"Manager,Query":[115],"analyzer,Visual":[116],"Basic,and":[117],"Visual":[118,219],"Studio,implement":[119],"robust":[120],"error":[121],"handling,and":[122],"establish":[123],"professional":[125],"habits":[126],"need":[128],"become":[130],"an":[131],"expert":[132],"developer.":[135],"guide":[137],"contains":[138],"simple":[139],"explanations":[140],"developers":[142],"are":[144],"starting":[146],"work":[148],"advanced":[153,165],"recommendations":[154,166],"techniques":[156,168],"experienced":[158,170],"DBAs.":[159,171],"experts":[174],"provide":[175],"concise":[176],"explanations,design":[177],"recommendations,many":[178],"examples,and":[179],"real-world":[181],"case":[182],"study.":[183],"\r\n\r\nDesign":[184],"user-defined,system,temporary,global":[185],"temporary,extended,remote,and":[186],"nested":[187],"proceduresAdopt":[189],"tips":[190],"tricks":[192],"identity,timestamp,sql_variant,uniqueidentifier,optimistic":[194],"locking,dynamically":[195],"constructed":[196],"queries,temporary":[197],"tables,andcursorsWrite":[198],"code":[199],"interact":[201],"COM,mai,executables,the":[203],"Registry,jobs,and":[204],"securityManage":[205],"application":[206],"securityLocate":[207],"fix":[209],"semantic":[210],"errors":[211],"TSQL":[213],"Debugger":[214],"Query":[216],"Analyzer,Visual":[217],"Basic,or":[218],"Studio,and":[220],"manual":[222],"debugging":[223],"techniquesCreate":[224],"user-defined,table-valued,and":[225],"in-line":[226],"functionsDesign":[227],"instead-of":[228],"triggers":[229],"after":[231],"triggersManage":[232],"transactions":[233],"locksDevelop":[235],"dynamic,Web-based":[236],"Server's":[240],"XML":[241],"capabilities":[242]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W1545366303","counts_by_year":[{"year":2014,"cited_by_count":1}],"updated_date":"2025-11-06T04:12:42.849631","created_date":"2016-06-24T00:00:00"}
