MSSQL

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).

MSSql

Azure MSSQL: Create read only user

26 Jan, 2021
How to create reader / read-only user in azure database.
MSSql

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.
MSSql

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,...
MSSql

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.