Sarang S Babusstechie.hashnode.net·Nov 18, 2022SQL vs T-SQL vs PL/SQLOverview SQL (Structured Query Language) is an ANSI standard adopted in 1986. Many RDBMS (relational database management system) vendors have used it as a foundation. At the same time, PL/ SQL stands for Procedural Language Extensions SQL, an Oracle...Discuss·1 like·53 readsSQL
Emmanuel Tisseraemmti.hashnode.net·Jul 3, 2013T-SQL - Integer Array - Condition basedT-SQL - Integer Array - Condition based Yesterday, I was presented with a simple problem by a colleague to be completed in SQL Server 2005 Transact SQL. We need to write a complex SELECT statement which will take in some parameters conditionally. ...DiscussT-SQL
Emmanuel Tisseraemmti.hashnode.net·Oct 14, 2015T-SQL for restoring a databaseBits and pieces of SQL code were gathered for my own use when restoring a database. Best used when back-porting data. Posted as a helper for myself - But feel free to modify and use it. -- INSTRUCTIONS: -- 1. Replace custom_database with the actual...DiscussSQL
Sarang S Babusstechie.hashnode.net·Nov 18, 2022SQL vs T-SQL vs PL/SQLOverview SQL (Structured Query Language) is an ANSI standard adopted in 1986. Many RDBMS (relational database management system) vendors have used it as a foundation. At the same time, PL/ SQL stands for Procedural Language Extensions SQL, an Oracle...Discuss·1 like·53 readsSQL
Emmanuel Tisseraemmti.hashnode.net·Oct 14, 2015T-SQL for restoring a databaseBits and pieces of SQL code were gathered for my own use when restoring a database. Best used when back-porting data. Posted as a helper for myself - But feel free to modify and use it. -- INSTRUCTIONS: -- 1. Replace custom_database with the actual...DiscussSQL
Emmanuel Tisseraemmti.hashnode.net·Jul 3, 2013T-SQL - Integer Array - Condition basedT-SQL - Integer Array - Condition based Yesterday, I was presented with a simple problem by a colleague to be completed in SQL Server 2005 Transact SQL. We need to write a complex SELECT statement which will take in some parameters conditionally. ...DiscussT-SQL
