internal.dbsql:customerdbsql:sp.spccpsetsocialnetworkinfo
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
internal.dbsql:customerdbsql:sp.spccpsetsocialnetworkinfo [2024/03/25 13:23] Radu Butarascu |
internal.dbsql:customerdbsql:sp.spccpsetsocialnetworkinfo [2024/04/03 11:09] (current) Radu Butarascu [4/3/2024] |
||
|---|---|---|---|
| Line 3: | Line 3: | ||
| Object type: Stored Procedure (MS-SQL)\\ | Object type: Stored Procedure (MS-SQL)\\ | ||
| Parent: [[internal:dbsql:customerdbsql:start|CustomerDBSQL]] | Parent: [[internal:dbsql:customerdbsql:start|CustomerDBSQL]] | ||
| - | \\ \\ | ||
| + | ===== 4/3/2024 ===== | ||
| + | <code sql> | ||
| + | SET ANSI_NULLS ON | ||
| + | GO | ||
| + | SET QUOTED_IDENTIFIER ON | ||
| + | GO | ||
| + | |||
| + | -- ============================================= | ||
| + | -- Author: www.allshore.us, Radu Butarascu | ||
| + | -- Last update: 9/8/2011, 3/25/2024, 4/3/2024 | ||
| + | -- Description: This procedure saves social media and contact links in CCP legacy. | ||
| + | -- Pages that use this are SocialNetworkingLinks.aspx and AppSocialNetworking.aspx | ||
| + | -- ============================================= | ||
| + | |||
| + | ALTER PROCEDURE [dbo].[spCCPSetSocialNetworkInfo] | ||
| + | ( | ||
| + | @CallLtr varchar(40), | ||
| + | @SocialNetworkFacebook varchar(255), | ||
| + | @SocialNetworkTwitter varchar(255), | ||
| + | @SocialNetworkYouTube varchar(255), | ||
| + | @SocialNetworkInstagram varchar(255), | ||
| + | @SocialNetworkSnapchat varchar(255), | ||
| + | @SocialNetworkTikTok varchar(255), | ||
| + | @RequestEmail varchar(255), | ||
| + | @ContactPhone varchar(15) | ||
| + | ) | ||
| + | AS | ||
| + | BEGIN | ||
| + | |||
| + | UPDATE Stations | ||
| + | SET SocialNetworkFacebook = @SocialNetworkFacebook, | ||
| + | SocialNetworkTwitter = @SocialNetworkTwitter, | ||
| + | SocialNetworkYouTube = @SocialNetworkYouTube, | ||
| + | SocialNetworkInstagram = @SocialNetworkInstagram, | ||
| + | SocialNetworkSnapchat = @SocialNetworkSnapchat, | ||
| + | SocialNetworkTikTok = @SocialNetworkTikTok, | ||
| + | RequestEmail = @RequestEmail, | ||
| + | ContactPhone = @ContactPhone | ||
| + | WHERE [CALL LTR] = @CallLtr | ||
| + | |||
| + | SELECT @@ROWCOUNT | ||
| + | |||
| + | END | ||
| + | GO | ||
| + | </code> | ||
| + | |||
| + | ===== 3/25/2024 ===== | ||
| <code sql> | <code sql> | ||
| Line 13: | Line 59: | ||
| -- ============================================= | -- ============================================= | ||
| - | -- Author: www.allshore.us, Radu Butarascu | + | -- Author: www.allshore.us, Radu Butarascu |
| -- Last update: 9/8/2011, 3/25/2024 | -- Last update: 9/8/2011, 3/25/2024 | ||
| -- Description: This procedure saves social media and contact links in CCP legacy. | -- Description: This procedure saves social media and contact links in CCP legacy. | ||
| Line 67: | Line 113: | ||
| GO | GO | ||
| </code> | </code> | ||
| - | \\ | + | ===== 9/8/2011 ===== |
| - | **PREVIOUS VERSION** | + | |
| <code sql> | <code sql> | ||
| SET ANSI_NULLS ON | SET ANSI_NULLS ON | ||
Last modified: 2024/03/25 13:23 (server time)
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
