#mssqlUnmoderated tagAll postsTrending CommunitiesSteemitCryptoAcademyNewcomers' Communityআমার বাংলা ব্লগKorea • 한국 • KR • KOWORLD OF XPILARAVLE 일상STEEM CN/中文Steem POD TeamBeauty of CreativityComunidad LatinaSteem AllianceUkraine on SteemExplore Communities...#mssqlTrendingNewPayoutsMutedfederico-r (36)in #databases • 4 months agoPostgreSQL vs SQL Server: What Are the Differences?In today’s business landscape, effective management and storage of data are more crucial than ever. As a result…justyy (82)in #mssql • 2 years agoMS SQL Server Database: Is It Possible to Identify the Corruption?MS SQL Server Database: Is It Possible to Identify the Corruption? MS SQL Server, also known as a Relational Database…rnkchr0 (35)in #sql • 2 years agoSELECT and JOIN From multiple Tables – SQLThe SELECT statement is used to retrieve fields from various tables. We need to utilize JOIN query to obtain data from…goldgrenade (25)in #sql • 3 years agoSQL Training CourseI've added this here in case someone would like a guided SQL training course. This will better familiarize you with…manardiab (4)in DLIKE • 4 years agoKingMiner botnet brute-forces MSSQL databases to install cryptocurrency miner | ZDNetOwners of MSSQL databases are advised to secure their servers, UK cyber-security firm Sophos said in a report…virajtakke09 (43)in #sql • 6 years agoDTUBE #38 :- HOW TO USE HAVING CLAUSE IN MSSQLDTUBE 38 :- HOW TO USE HAVING CLAUSE IN MSSQL ▶️ DTube ▶️ IPFSarunvk (25)in #sqlserver • 6 years agoHOW TO ACCESS MS SQL IN WINDOWS SERVER FROM A REMOTE SQL SERVER MANAGEMENT STUDIOIt is always troublesome to access MS SQL running in windows server from a location system. In this post I am…arunvk (25)in #mssql • 6 years ago[deleted][Empty]arunvk (25)in #sqlserver • 6 years agoAdd/Remove automatic password expiration of MS SQL userMS SQL has a automatic password expiration feature for database users. Which has both advantage and disadvantage.…virajtakke09 (43)in #database • 6 years agoHow To Create Database And Table In MssqlHello Friend Today In This Blog I Will Show You How To Create Database And Table In Mssql.The CREATE DATABASE…virajtakke09 (43)in #database • 6 years agoHow To Use Different Type Of Mssql JoinsHello Friend Today In This Blog I Will Show You How To Use Different Type Of Mssql Joins .A JOIN clause is used to…virajtakke09 (43)in #database • 6 years agoHow To Use Getdate() and Getutcdate() Functionality In MssqlHello Friend Today In This Blog I Will Show You How To Use Getdate() and Getutcdate() Functionality In Mssql.In SQL…virajtakke09 (43)in #dtube • 6 years ago DTUBE #21 :- HOW TO USE GROUP BY FUNCTIONALITY IN MSSQLDTUBE #21 :- HOW TO USE GROUP BY FUNCTIONALITY IN MSSQL ▶️ DTube ▶️ IPFSforensicmon (27)in #kr • 6 years agoMSSQL Forensic을 위한 Query데이터베이스는 그 양이 방대하여 삭제된 영역의 복구가 쉽지 않다. Apex라는 툴을 MS-SQL에서 제공하기는 하나, 이는 서버 관리 차원에서의 도구로 디지털 포렌식에 십분 활요하기 어렵다. 데이터베이스…ohk5004 (43)in #docker • 6 years agoDocker를 이용하여 멀티플랫폼에서 MSSQL + Laravel을 개발해보자.지인이 새로운 프로젝트를 시작하면서 Stack을 설계해주었다. Database는 Oracle로 정해진 상황에서 빠른 진행을 위해 Python을 사용하기로 하고 개발환경을 구축하였다. 하지만 갑작스럽게…dailystudy (41)in #mssql • 6 years agomssql错误Error8120:分组必须只能查询分组字段和其他字段的聚合平时都是使用myssql的我,最近不得不开始学习mssql了。 在mysql下: select author, Datepart(hour, created) as hh from comments tvb (65)in #mssql • 6 years ago在steemsql(mssql)下如何获得上一个周六的指定时间How to get the certain time of last Saturday in Steemsql(mssql)最近我每周都要去统计“华语好声音”和“三个一”活动的一周文章列表。所以在条件语句中,总是少不了限制时间。例如,上周统计“华语好声音”的一个条件子句就是 DATEADD(hour,7, created)>='2018-01-27 00:00:00'dailystudy (41)in #mssql • 6 years ago在steemsql(mssql)中搜索字符中含有中文我想搜索一下本年发表的和中文诗有关的文章,于是我在linqpad中使用sql语句 select * from comments where created>='2018-01-01 00:00:00' and title like '%诗%'dailystudy (41)in #mssql • 6 years ago在mssql下先排序再分组SQL语句在mysql下,我会使用select ... from (select ... from... ... order by ) tmp group by ... 无奈呀,在mssql下,子句中不支持order by 最后,在偶像…dailystudy (41)in #mssql • 6 years agomssql和mssql的时间移动函数SQL函数 | different function in mssql and mysql for time inverval平时都是用mysql多, 无奈steemit上还是mssql数据库更好用,只好开始研究: 平时在mysql下想要移动时间都是需要date_add()函数的。它的用法是 date_add(原时间字段或常量, interval…