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回答·643浏览

咨询一下，如何在库中查询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回答·728浏览

啃啃

安装完后不是全部都success怎么办，有4到5个failed了

可以忽略，一般不影响学习使用

2018-03-26 1回答·967浏览
qq_TOP杀戮10_04089145

C盘里面有 Management studio 为什么开始里面没有？怎么打开？

你这个不是打开了吗

2018-03-06 1回答·1212浏览
慕盖茨3430869

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

应该是安装错误

2018-02-16 1回答·2608浏览
豆腐小丸子

附加数据库的时候出现错误

删除附加数据库下面的日志文件就行了

2017-12-22 1回答·1353浏览
_喧嚣的张小货_

连接到服务器无法连接到 3RZOJ6WNLO8NXI2。

我开始也是这样不知道为什么第二次就可以了下次账号连接的时候默认就行

2017-11-09 1回答·1198浏览
qq_临时登录专用_0

SQL server安装了中文版的，怎么更改成英文版的？

2017-08-03 1回答·6453浏览
Hum_Drum

无法连接到自定义名称的服务器？

是电脑主机名称没有修改与服务器名称一致不是密码不对

2017-08-02 2回答·1116浏览
不负如来不负卿1994

SQL Server学习

安装的是SQL2005吗，是不是没有企业管理器

2017-06-22 1回答·1018浏览
慕粉1414018001

sql 备份

通过任务计划制定CMD命令，实现每天自动备份数据库和自动删除

2017-04-20 1回答·677浏览
qq_是野生的吗_0

电脑已经安装过数据库还能再安装吗

可以，例如因已经安装了SQL2012,安装SQL2005时无法使用默认实例名,安装时需新创建一个SQL实例.

连接时,用[机器名]\[实例名]或[机器名],[端口号]连接.

2017-03-09 1回答·1331浏览
慕粉3602640

日志找不到怎么办

可以进行搜索，搜索到你所要找的日志。
若是日志丢失，SQL Server 有恢复功能，可以使用恢复功能找回丢失的日志。

2017-03-04 2回答·764浏览
慕粉1316492501

谁能帮忙在win10上下载spl

什么问题

2017-03-01 3回答·851浏览
littlepython

课程资料在哪里下载？

视频右下角资料下载

2017-02-19 1回答·879浏览
qq_百草_0

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

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

2016-11-28 2回答·2485浏览
zhlimi

怎么复制某库一个的数据复制另一个库中的一个表中。

已采纳三打孙八戒的回答

例子：SELECT * INTO [A].[dbo].[A1] FROM [B].[dbo].[A1]

2016-11-22 2回答·1351浏览
慕粉3811742

小雨老师，本人初学者，请问下数据库是如何开发，然后数据是如何存储进数据库的。开发的工具和语言是什么？前端的和后台的数据如何进行连接？

学jsp课程

2016-11-15 1回答·689浏览
郑慤

用户sa登录失败

框架均有相通之处，把偏底层的抽象封装出来，更好的为快速开发服务，ruby也很灵巧，喜欢我编写的 g r i d —c e l l 这个在 c s s 里面怎么写了它的格式运行的时候怎么不对勒？

2016-11-13 3回答·647浏览
慕少3655993

数据库引擎安装失败怎么办

2016-11-03 2回答·985浏览
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回答·1192浏览
qq_ZHANGTONG_03338388

我安装sqlserver的时候,点开setup 他闪一下就没了。

请问问题解决了吗？

2016-09-14 2回答·7126浏览
bike1994

Sql serve身份验证

一种是用计算机用户进行登录另外一种是你自己定义的数据专用的密码。这两种的一种就可以实现登录操作

2016-03-21 1回答·683浏览
kallisher小尾巴

不能附加数据库

2016-03-14 6回答·1166浏览
四灬阿哥

安装时候的问题

2015-10-19 3回答·1035浏览
sunwenju1991

SQL Server 2012 如何换成中文版

2015-09-15 4回答·4539浏览
超人7号

大师们请指导一下，我在登陆上就卡住了怎么输入localhost连接时报错？

计算机名称更改了吧，直接输入 . 应该可以，你试一试

2015-08-22 4回答·998浏览
程曦i

登路报错问题

已采纳 FFD_ 的回答

可以看看，我也出现过类似问题 http://wenku.baidu.com/view/04f6c139b90d6c85ec3ac6f5.html

2015-08-11 2回答·983浏览
慕斯5143065

为什么不用中文版教学呢？

因为这些东西都是外国人创造的，有些是没有翻译文档的或者破解版的，要想深入的学习就必须自己能看懂英文版，自己能看懂帮助文档

2015-07-26 1回答·1011浏览

数据加载中...