Refresher in SQL basics in under 30 minutes Mountain Computers MTNCOMP GGPCTU 775-287-9552

use test1

		      sp_tables



		  
	create table testc (

		row_id    int identity,

		num1    int null,

		num2    float null

		)

		

		-- alter table testc add num3 money null

		-- drop table testc 

		

		declare @i int

		select @i = 1

		

		while @i < 100

		begin

		insert into testc (num1, num2, num3) values (rand() * 10000, rand(), rand() * 100000)

		select @i = @i + 1

		end

		

		-- create index myindex_testc on testc (row_id)

		-- select count(*) from testc

		-- delete from testc

		-- select * from testc

		-- select * from testc order by row_id desc

That's it! the results look like this.

select * from testc order by row_id desc

if you found this article helpful, consider contributing $10, 20 an Andrew Jackson or so..to the author. more authors coming soon

FYI we use paypal or patreon, patreon has 3x the transaction fees, so we don't, not yet.

Refresher in SQL basics in under 30 minutes

by Mountain Computers Inc, Publication Date: Saturday, December 9, 2023

View Count: 592, Keywords: SQL, Basics, 30 minutes, Hashtags: #SQL #Basics #30minutes

if you found this article helpful, consider contributing $10, 20 an Andrew Jackson or so..to the author. more authors coming soon

FYI we use paypal or patreon, patreon has 3x the transaction fees, so we don't, not yet.