Visage/UsefulSQLQueries.sql at main · HackerspaceMumbai/Visage · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
select * from [registrationdb].[dbo].[Registrants]

DELETE  FROM [registrationdb].[dbo].[Registrants]


SELECT TOP (1000) [Id]
      ,[FirstName]
      ,[MiddleName]
      ,[LastName]
      ,[Address]
      ,[AddressLine1]
      ,[AddressLine2]
      ,[City]
      ,[State]
      ,[PostalCode]
      ,[Email]
      ,[MobileNumber]
      ,[GovtId]
      ,[GovtIdLast4Digits]
      ,[OccupationStatus]
      ,[CompanyName]
      ,[LinkedInProfile]
      ,[GitHubProfile]
      ,[EducationalInstituteName]
      ,[GenderIdentity]
      ,[SelfDescribeGender]
      ,[AgeRange]
      ,[Ethnicity]
      ,[SelfDescribeEthnicity]
      ,[LanguageProficiency]
      ,[SelfDescribeLanguage]
      ,[EducationalBackground]
      ,[SelfDescribeEducation]
      ,[Disability]
      ,[DisabilityDetails]
      ,[DietaryRequirements]
      ,[SelfDescribeDietary]
      ,[LgbtqIdentity]
      ,[ParentalStatus]
      ,[FirstTimeAttendee]
      ,[HowDidYouHear]
      ,[SelfDescribeHowDidYouHear]
      ,[AreasOfInterest]
      ,[SelfDescribeAreasOfInterest]
      ,[VolunteerOpportunities]
      ,[AdditionalSupport]
      ,[Religion]
      ,[Caste]
      ,[Neighborhood]
      ,[ModeOfTransportation]
      ,[IsProfileComplete]
      ,[ProfileCompletedAt]
      ,[IsAideProfileComplete]
      ,[AideProfileCompletedAt]
      ,[GovtIdType]
  FROM [registrationdb].[dbo].[Registrants]


  DELETE FROM [registrationdb].[dbo].[Registrants]
  WHERE [Id] = <ID>';