TelegramCrawlerBot/SQLQuery-StoredProcedure.sql at master · tayyebi/TelegramCrawlerBot · 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
61
62
63
64
/****** Object:  StoredProcedure [dbo].[CrawlerInsert]    Script Date: 5/19/2017 9:14:49 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[CrawlerInsert]

@User_Id  nvarchar(300) ,
@User_Firstname  nvarchar(300) ,
@User_Lastname  nvarchar(300) ,
@User_Username  nvarchar(300) ,
@User_LanguageCode  nvarchar(300) ,
@Chat_Id  nvarchar(300) ,
@Chat_Title  nvarchar(300) ,
@Chat_Firstname  nvarchar(300) ,
@Chat_Lastname  nvarchar(300) ,
@Chat_Username  nvarchar(300) ,
@Chat_Type  nvarchar(300) ,
@Message_Id  nvarchar(300) ,
@Message_Date  nvarchar(300) ,
@Chat_MembersCount  nvarchar(300) ,
@Message_Text  nvarchar(max)


AS
BEGIN
INSERT INTO [dbo].[Users]
           ([User_Id]
           ,[User_Firstname]
           ,[User_Lastname]
           ,[User_Username]
           ,[User_LanguageCode]
           ,[Chat_Id]
           ,[Chat_Title]
           ,[Chat_Firstname]
           ,[Chat_Lastname]
           ,[Chat_Username]
           ,[Chat_Type]
           ,[Message_Id]
           ,[Message_Date]
           ,[Chat_MembersCount]
           ,[Message_Text])
     VALUES
           (@User_Id,
           @User_Firstname,
           @User_Lastname,
           @User_Username,
           @User_LanguageCode,
           @Chat_Id,
           @Chat_Title,
           @Chat_Firstname,
           @Chat_Lastname,
           @Chat_Username,
           @Chat_Type,
           @Message_Id,
           @Message_Date,
           @Chat_MembersCount,
           @Message_Text)

		   END

GO