SQL Server Coding Standards: About Object Identifiers

Prepared by Bihag Thaker There are various types of objects in SQL Server like Tables, Views, Stored Procedures, User Defined Functions, Triggers, Constraints, Indexes, Schemas and Variables and so on. These objects should be assigned appropriate identifiers with which they are referenced in the database. Object Identifiers are of two types in SQL Server: (1) […]

May 16, 2018 SQL Server, SQL Server Coding Standards

May 15, 2018 3

SQL Puzzle: Generate Calendar Data for 19th Century

May 14, 2018 3

SQL Puzzle: Use Recursive CTE, and list out the Years from Dates

May 13, 2018

SQL Server: Set the default value to IMAGE Column or Binary Data

May 12, 2018 2

SQL Puzzle: Calculate the Power of Three

May 11, 2018

SQL Server: Do the Schema Compare between two Tables

May 10, 2018

SQL Server Interview: How to insert the data into Multiple Tables?

May 9, 2018 3

SQL Puzzle: Find the Median Value from the Given Number

May 8, 2018

SQL Puzzle: Use Group By, Find MIN MAX unit sold of a Month

May 7, 2018

SQL Server Interview: Is NULL = NULL valid condition?

Older posts Newer posts

About Me!