Microsoft SQL – Mike Colbert Online

Create Microsoft SQL Azure Database Read-Only User

November 30, 2016 by Mike

To create a login (server wide account) which uses a simple username + password combination for SQL authentication: CREATE LOGIN ReadOnlyUserName WITH PASSWORD = ‘strong_password’; NOTE: This allows the user to connect using SQL Management Studio. It is not required if the user only needs to connect to a specific database. To create a user to … Read more

Count Number of Rows In Microsoft SQL Table

February 16, 2016 by Mike

To count the number of rows in a Microsoft SQL database table: SELECT COUNT(*) FROM dbo.table_name;

Reset Identity Seed in Microsoft SQL

April 22, 2015 by Mike

After you delete records from a table, if you want to set the Identity Seed back to zero: DBCC CHECKIDENT(‘msci3025_f14.dbo.msci3025_surveyData’, RESEED, 0)

Delete all rows from a Microsoft SQL table

April 22, 2015 by Mike

To delete all rows from a table: DELETE FROM msci3025_f14.dbo.msci3025_surveyData

MS SQL script to create database and add data

April 9, 2015 by Mike

This Microsoft SQL script was used to create a database table named colbert_stateFacts with fields stID, state_name, state_capital, state_code, state_bird and state_flower. The script then inserted records into the new table. CREATE TABLE [dbo].[colbert_stateFacts] ( [stID] [int] IDENTITY(1,1) NOT NULL, [state_name] [nvarchar](50) NOT NULL, [state_capital] [nvarchar](50) NOT NULL, [state_code] [nvarchar](2) NOT NULL, [state_bird] [nvarchar](50) NULL, … Read more