Microsoft SQL Server is a relational database server, developed by Microsoft: it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet).
Azure MSSQL: Create read only user
26 Jan, 2021
How to create reader / read-only user in azure database.
Set smalldatetime default value to current date/time
25 Jan, 2021
This example shows how to set the default value of a smalldatetime column to current date time.
Get MSSQL column / field information
17 Feb, 2012
Running the query in this snippet will get MSSQL column information. it fetches and displays information about all columns in the specified table, including details such as column name, data type,...
Get all tables from database in MSSQL
17 Feb, 2012
MSSQL query that gets all database tables. To get a list of all tables in a MSSQL database, you can use a SQL query to retrieve the table names from the system objects.