【C++、SQL学习笔记3】杂记

最新推荐文章于 2022-08-05 22:01:22 发布

NopDes1re

最新推荐文章于 2022-08-05 22:01:22 发布

阅读量417

点赞数

分类专栏： C#、SQL C/C++

本文链接：https://blog.csdn.net/u013617144/article/details/45134655

版权

C/C++ 同时被 2 个专栏收录

21 篇文章 0 订阅

订阅专栏

C#、SQL

13 篇文章 0 订阅

订阅专栏

2015-4-19 23:09:06

use sun
go
create procedure [dbo].[deleteLoginPic]
@Name nvarchar(50)
as
update facename 
set LoginPicture=null 
where Name=@Name

USE [sun]
GO
/****** Object:  StoredProcedure [dbo].[uploadlogin]    Script Date: 04/18/2015 14:27:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[uploadlogin]
@Name varchar(50),
@LoginPicture image
as
update  facename 
set LoginPicture=@LoginPicture where Name = @Name

============================================================================================

筛选出路径的非法字符
StringBuilder rBuilder = new StringBuilder(saven[i]);
                    foreach (char rInvalidChar in Path.GetInvalidFileNameChars())
                        rBuilder.Replace(rInvalidChar.ToString(), string.Empty);