SQL Server基础--T-SQL语句_技术问答

weixin_慕姐9552544

连接数据库遇到问题

https://m.vk.com/topic-210967729_48605787

https://m.vk.com/topic-210967729_48605788

https://m.vk.com/topic-210967729_48605789

https://m.vk.com/topic-210967729_48605792

https://m.vk.com/topic-210967729_48605793

https://m.vk.com/topic-210967729_48605796

https://m.vk.com/topic-210967729_48605799

https://m.vk.com/topic-210967729_48605802

https://m.vk.com/topic-210967729_48605805

https://m.vk.com/topic-210967729_48605807

https://m.vk.com/topic-210967729_48605808

https://m.vk.com/topic-210967729_48605809

https://m.vk.com/topic-210967729_48605810

https://m.vk.com/topic-210967729_48605813

https://m.vk.com/topic-210967729_48605815

https://m.vk.com/topic-210967729_48605816

https://m.vk.com/topic-210967729_48605817

https://m.vk.com/topic-210967729_48605819

https://m.vk.com/topic-210967729_48605821

https://m.vk.com/topic-210967729_48605822

https://m.vk.com/topic-210967729_48605824

https://m.vk.com/topic-210967729_48605825

https://m.vk.com/topic-210967729_48605826

https://m.vk.com/topic-210967729_48605828

https://m.vk.com/topic-210967729_48605831

https://m.vk.com/topic-210967729_48605832

https://m.vk.com/topic-210967729_48605833

https://m.vk.com/topic-210967729_48605836

https://m.vk.com/topic-210967729_48605837

https://m.vk.com/topic-210967729_48605839

https://m.vk.com/topic-210967729_48605840

https://m.vk.com/topic-210967729_48605841

https://m.vk.com/topic-210967729_48605844

https://m.vk.com/topic-210967729_48605846

https://m.vk.com/topic-210967729_48605848

https://m.vk.com/topic-210967729_48605851

https://m.vk.com/topic-210967729_48605852

https://m.vk.com/topic-210967729_48605857

https://m.vk.com/topic-210967729_48605858

https://m.vk.com/topic-210967729_48605860

https://m.vk.com/topic-210967729_48605863

https://m.vk.com/topic-210967729_48605864

https://m.vk.com/topic-210967729_48605865

https://m.vk.com/topic-210967729_48605868

https://m.vk.com/topic-210967729_48605869

https://m.vk.com/topic-210967729_48605870

https://m.vk.com/topic-210967729_48605871

https://m.vk.com/topic-210967729_48605873

https://m.vk.com/topic-210967729_48605874

https://m.vk.com/topic-210967729_48605876

https://m.vk.com/topic-210967729_48605877

https://m.vk.com/topic-210967729_48605878

https://m.vk.com/topic-210967729_48605880

https://m.vk.com/topic-210967729_48605882

https://m.vk.com/topic-210967729_48605884

https://m.vk.com/topic-210967729_48605886

https://m.vk.com/topic-210967729_48605887

https://m.vk.com/topic-210967729_48605890

https://m.vk.com/topic-210967729_48605892

https://m.vk.com/topic-210967729_48605893

https://m.vk.com/topic-210967729_48605894

https://m.vk.com/topic-210967729_48605897

https://m.vk.com/topic-210967729_48605900

https://m.vk.com/topic-210967729_48605904

https://m.vk.com/topic-210967729_48605905

https://m.vk.com/topic-210967729_48605908

https://m.vk.com/topic-210967729_48605909

https://m.vk.com/topic-210967729_48605910

https://m.vk.com/topic-210967729_48605912

https://m.vk.com/topic-210967729_48605913

https://m.vk.com/topic-210967729_48605914

https://m.vk.com/topic-210967729_48605915

https://m.vk.com/topic-210967729_48605916

https://m.vk.com/topic-210967729_48605918

https://m.vk.com/topic-210967729_48605919

https://m.vk.com/topic-210967729_48605920

https://m.vk.com/topic-210967729_48605921

https://m.vk.com/topic-210967729_48605923

https://m.vk.com/topic-210967729_48605924

https://m.vk.com/topic-210967729_48605927

https://m.vk.com/topic-210967729_48605929

https://m.vk.com/topic-210967729_48605930

https://m.vk.com/topic-210967729_48605931

https://m.vk.com/topic-210967729_48605932

https://m.vk.com/topic-210967729_48605933

https://m.vk.com/topic-210967729_48605935

https://m.vk.com/topic-210967729_48605937

https://m.vk.com/topic-210967729_48605939

https://m.vk.com/topic-210967729_48605941

https://m.vk.com/topic-210967729_48605943

https://m.vk.com/topic-210967729_48605947

https://m.vk.com/topic-210967729_48605948

https://m.vk.com/topic-210967729_48605950

https://m.vk.com/topic-210967729_48605951

https://m.vk.com/topic-210967729_48605952

https://m.vk.com/topic-210967729_48605954

https://m.vk.com/topic-210967729_48605955

https://m.vk.com/topic-210967729_48605957

https://m.vk.com/topic-210967729_48605958

https://m.vk.com/topic-210967729_48605959

https://m.vk.com/topic-210967729_48605960

https://m.vk.com/topic-210967729_48605962

https://m.vk.com/topic-210967729_48605965

https://m.vk.com/topic-210967729_48605967

https://m.vk.com/topic-210967729_48605969

https://m.vk.com/topic-210967729_48605970

https://m.vk.com/topic-210967729_48605971

https://m.vk.com/topic-210967729_48605972

https://m.vk.com/topic-210967729_48605974

https://m.vk.com/topic-210967729_48605976

https://m.vk.com/topic-210967729_48605978

https://m.vk.com/topic-210967729_48605980

https://m.vk.com/topic-210967729_48605981

https://m.vk.com/topic-210967729_48605982

https://m.vk.com/topic-210967729_48605985

https://m.vk.com/topic-210967729_48605986

https://m.vk.com/topic-210967729_48605990

https://m.vk.com/topic-210967729_48605992

https://m.vk.com/topic-210967729_48605994

https://m.vk.com/topic-210967729_48605996

https://m.vk.com/topic-210967729_48605997

https://m.vk.com/topic-210967729_48605999

https://m.vk.com/topic-210967729_48606005

https://m.vk.com/topic-210967729_48606008

https://m.vk.com/topic-210967729_48606013

https://m.vk.com/topic-210967729_48606015

https://m.vk.com/topic-210967729_48606016

https://m.vk.com/topic-210967729_48606018

https://m.vk.com/topic-210967729_48606019

https://m.vk.com/topic-210967729_48606020

https://m.vk.com/topic-210967729_48606021

https://m.vk.com/topic-210967729_48606022

https://m.vk.com/topic-210967729_48606023

https://m.vk.com/topic-210967729_48606025

https://m.vk.com/topic-210967729_48606026

https://m.vk.com/topic-210967729_48606029

https://m.vk.com/topic-210967729_48606055

https://m.vk.com/topic-210967729_48606067

https://m.vk.com/topic-210967729_48606085

https://m.vk.com/topic-210967729_48606123

https://m.vk.com/topic-210967729_48606132

https://m.vk.com/topic-210967729_48606143

https://m.vk.com/topic-210967729_48606152

https://m.vk.com/topic-210967729_48606164

https://m.vk.com/topic-210967729_48606176

https://m.vk.com/topic-210967729_48606184

https://m.vk.com/topic-210967729_48606196

https://m.vk.com/topic-210967729_48606205

https://m.vk.com/topic-210967729_48606218

https://m.vk.com/topic-210967729_48606221

https://m.vk.com/topic-210967729_48606234

https://m.vk.com/topic-210967729_48606241

https://m.vk.com/topic-210967729_48606251

https://m.vk.com/topic-210967729_48606263

https://m.vk.com/topic-210967729_48606275

https://m.vk.com/topic-210967729_48606289

https://m.vk.com/topic-210967729_48606296

https://m.vk.com/topic-210967729_48606317

https://m.vk.com/topic-210967729_48606324

https://m.vk.com/topic-210967729_48606344

https://m.vk.com/topic-210967729_48606355

https://m.vk.com/topic-210967729_48606366

https://m.vk.com/topic-210967729_48606377

https://m.vk.com/topic-210967729_48606387

https://m.vk.com/topic-210967729_48606401

https://m.vk.com/topic-210967729_48606412

https://m.vk.com/topic-210967729_48606421

https://m.vk.com/topic-210967729_48606431

https://m.vk.com/topic-210967729_48606443

https://m.vk.com/topic-210967729_48606453

https://m.vk.com/topic-210967729_48606467

https://m.vk.com/topic-210967729_48606474

https://m.vk.com/topic-210967729_48606487

https://m.vk.com/topic-210967729_48606501

https://m.vk.com/topic-210967729_48606515

https://m.vk.com/topic-210967729_48606524

https://m.vk.com/topic-210967729_48606536

https://m.vk.com/topic-210967729_48606547

https://m.vk.com/topic-210967729_48606560

https://m.vk.com/topic-210967729_48606571

https://m.vk.com/topic-210967729_48606581

https://m.vk.com/topic-210967729_48606595

https://m.vk.com/topic-210967729_48606605

https://m.vk.com/topic-210967729_48606618

https://m.vk.com/topic-210967729_48606619

https://m.vk.com/topic-210967729_48606625

https://m.vk.com/topic-210967729_48606626

https://m.vk.com/topic-210967729_48606630

https://m.vk.com/topic-210967729_48606637

https://m.vk.com/topic-210967729_48606647

https://m.vk.com/topic-210967729_48606662

https://m.vk.com/topic-210967729_48606668

https://m.vk.com/topic-210967729_48606679

https://m.vk.com/topic-210967729_48606689

https://m.vk.com/topic-210967729_48606701

https://m.vk.com/topic-210967729_48606703

https://m.vk.com/topic-210967729_48606715

https://m.vk.com/topic-210967729_48606723

https://m.vk.com/topic-210967729_48606732

https://m.vk.com/topic-210967729_48606744

2020-10-22 2回答·689浏览

BOSSXL

咨询一下，如何在库中查询lx.FNumber列数据相同时，对应的 t.fipaddress 列数据也相同，但是 ba.fname 列数据不同的所有数据？

https://m.vk.com/topic-210967729_48605960

https://m.vk.com/topic-210967729_48605962

https://m.vk.com/topic-210967729_48605965

https://m.vk.com/topic-210967729_48605967

https://m.vk.com/topic-210967729_48605969

https://m.vk.com/topic-210967729_48605970

https://m.vk.com/topic-210967729_48605971

https://m.vk.com/topic-210967729_48605972

https://m.vk.com/topic-210967729_48605974

https://m.vk.com/topic-210967729_48605976

https://m.vk.com/topic-210967729_48605978

https://m.vk.com/topic-210967729_48605980

https://m.vk.com/topic-210967729_48605981

https://m.vk.com/topic-210967729_48605982

https://m.vk.com/topic-210967729_48605985

https://m.vk.com/topic-210967729_48605986

https://m.vk.com/topic-210967729_48605990

https://m.vk.com/topic-210967729_48605992

https://m.vk.com/topic-210967729_48605994

https://m.vk.com/topic-210967729_48605996

https://m.vk.com/topic-210967729_48605997

https://m.vk.com/topic-210967729_48605999

https://m.vk.com/topic-210967729_48606005

https://m.vk.com/topic-210967729_48606008

https://m.vk.com/topic-210967729_48606013

https://m.vk.com/topic-210967729_48606015

https://m.vk.com/topic-210967729_48606016

https://m.vk.com/topic-210967729_48606018

https://m.vk.com/topic-210967729_48606019

https://m.vk.com/topic-210967729_48606020

https://m.vk.com/topic-210967729_48606021

https://m.vk.com/topic-210967729_48606022

https://m.vk.com/topic-210967729_48606023

https://m.vk.com/topic-210967729_48606025

https://m.vk.com/topic-210967729_48606026

https://m.vk.com/topic-210967729_48606029

https://m.vk.com/topic-210967729_48606055

https://m.vk.com/topic-210967729_48606067

https://m.vk.com/topic-210967729_48606085

https://m.vk.com/topic-210967729_48606123

https://m.vk.com/topic-210967729_48606132

https://m.vk.com/topic-210967729_48606143

https://m.vk.com/topic-210967729_48606152

https://m.vk.com/topic-210967729_48606164

https://m.vk.com/topic-210967729_48606176

https://m.vk.com/topic-210967729_48606184

https://m.vk.com/topic-210967729_48606196

https://m.vk.com/topic-210967729_48606205

https://m.vk.com/topic-210967729_48606218

https://m.vk.com/topic-210967729_48606221

https://m.vk.com/topic-210967729_48606234

https://m.vk.com/topic-210967729_48606241

https://m.vk.com/topic-210967729_48606251

https://m.vk.com/topic-210967729_48606263

https://m.vk.com/topic-210967729_48606275

https://m.vk.com/topic-210967729_48606289

https://m.vk.com/topic-210967729_48606296

https://m.vk.com/topic-210967729_48606317

https://m.vk.com/topic-210967729_48606324

https://m.vk.com/topic-210967729_48606344

https://m.vk.com/topic-210967729_48606355

https://m.vk.com/topic-210967729_48606366

https://m.vk.com/topic-210967729_48606377

https://m.vk.com/topic-210967729_48606387

https://m.vk.com/topic-210967729_48606401

https://m.vk.com/topic-210967729_48606412

https://m.vk.com/topic-210967729_48606421

https://m.vk.com/topic-210967729_48606431

https://m.vk.com/topic-210967729_48606443

https://m.vk.com/topic-210967729_48606453

https://m.vk.com/topic-210967729_48606467

https://m.vk.com/topic-210967729_48606474

https://m.vk.com/topic-210967729_48606487

https://m.vk.com/topic-210967729_48606501

https://m.vk.com/topic-210967729_48606515

https://m.vk.com/topic-210967729_48606524

https://m.vk.com/topic-210967729_48606536

https://m.vk.com/topic-210967729_48606547

https://m.vk.com/topic-210967729_48606560

https://m.vk.com/topic-210967729_48606571

https://m.vk.com/topic-210967729_48606581

https://m.vk.com/topic-210967729_48606595

https://m.vk.com/topic-210967729_48606605

https://m.vk.com/topic-210967729_48606618

https://m.vk.com/topic-210967729_48606619

https://m.vk.com/topic-210967729_48606625

https://m.vk.com/topic-210967729_48606626

https://m.vk.com/topic-210967729_48606630

https://m.vk.com/topic-210967729_48606637

https://m.vk.com/topic-210967729_48606647

https://m.vk.com/topic-210967729_48606662

https://m.vk.com/topic-210967729_48606668

https://m.vk.com/topic-210967729_48606679

https://m.vk.com/topic-210967729_48606689

https://m.vk.com/topic-210967729_48606701

https://m.vk.com/topic-210967729_48606703

https://m.vk.com/topic-210967729_48606715

https://m.vk.com/topic-210967729_48606723

https://m.vk.com/topic-210967729_48606732

https://m.vk.com/topic-210967729_48606744

https://m.vk.com/topic-210967729_48606748

2020-08-20 1回答·809浏览

啃啃

安装完后不是全部都success怎么办，有4到5个failed了: 可以忽略，一般不影响学习使用; 2018-03-26 1回答·1058浏览

qq_TOP杀戮10_04089145

C盘里面有 Management studio 为什么开始里面没有？怎么打开？: 你这个不是打开了吗; 2018-03-06 1回答·1250浏览

慕盖茨3430869

SQL服务无法启动，提示“系统找不到指定的文件”经查找是因为在SQL的安装目录Bin里面的sqlservr.exe丢失，大小是8.72M，哪位大神可以Copy给我呀？微信 MHZ-080784 记得跟我说一下是慕课网哦··· 谢谢！: 应该是安装错误; 2018-02-16 1回答·2651浏览

慕盖茨3430869

SQL服务无法启动，提示“系统找不到指定的文件”

System.out.print("你应该搞定了吧");

2018-02-16 1回答·963浏览

豆腐小丸子

附加数据库的时候出现错误: 删除附加数据库下面的日志文件就行了; 2017-12-22 1回答·1486浏览

_喧嚣的张小货_

连接到服务器无法连接到 3RZOJ6WNLO8NXI2。: 我开始也是这样不知道为什么第二次就可以了下次账号连接的时候默认就行; 2017-11-09 1回答·1233浏览

qq_临时登录专用_0

SQL server安装了中文版的，怎么更改成英文版的？: 2017-08-03 1回答·6534浏览

Hum_Drum

无法连接到自定义名称的服务器？: 是电脑主机名称没有修改与服务器名称一致不是密码不对; 2017-08-02 2回答·1174浏览

不负如来不负卿1994

SQL Server学习: 安装的是SQL2005吗，是不是没有企业管理器; 2017-06-22 1回答·1069浏览

慕粉1414018001

sql 备份: 通过任务计划制定CMD命令，实现每天自动备份数据库和自动删除; 2017-04-20 1回答·750浏览

qq_是野生的吗_0

电脑已经安装过数据库还能再安装吗: 可以，例如因已经安装了SQL2012,安装SQL2005时无法使用默认实例名,安装时需新创建一个SQL实例.

连接时,用[机器名]\[实例名]或[机器名],[端口号]连接.; 2017-03-09 1回答·1399浏览

慕粉3602640

日志找不到怎么办

可以进行搜索，搜索到你所要找的日志。

若是日志丢失，SQL Server 有恢复功能，可以使用恢复功能找回丢失的日志。

2017-03-04 2回答·804浏览

慕粉1316492501

谁能帮忙在win10上下载spl: 什么问题; 2017-03-01 3回答·894浏览

littlepython

课程资料在哪里下载？: 视频右下角资料下载; 2017-02-19 1回答·929浏览

qq_百草_0

为什么是mdf文件？？打不开啊？

没有sql sever怎么打开mdf文件呀，我就是要安装sqlsever的呀

2016-11-28 2回答·2533浏览

zhlimi

怎么复制某库一个的数据复制另一个库中的一个表中。: 已采纳三打孙八戒的回答; 例子：SELECT * INTO [A].[dbo].[A1] FROM [B].[dbo].[A1]; 2016-11-22 2回答·1392浏览

慕粉3811742

小雨老师，本人初学者，请问下数据库是如何开发，然后数据是如何存储进数据库的。开发的工具和语言是什么？前端的和后台的数据如何进行连接？: 学jsp课程; 2016-11-15 1回答·727浏览

郑慤

用户sa登录失败: 框架均有相通之处，把偏底层的抽象封装出来，更好的为快速开发服务，ruby也很灵巧，喜欢我编写的 g r i d —c e l l 这个在 c s s 里面怎么写了它的格式运行的时候怎么不对勒？; 2016-11-13 3回答·692浏览

慕少3655993

数据库引擎安装失败怎么办: 2016-11-03 2回答·1025浏览

words_木木曰

附加数据库: TITLE: Microsoft SQL Server Management Studio
------------------------------

An error occurred when attaching the database(s). Click the hyperlink in the Message column for details.

------------------------------
BUTTONS:

OK
------------------------------

怎么解决这个error呢？我已经将文件属性设为full control了。; 2016-10-10 2回答·1286浏览