New: mssqlAll contenthive-129948hive-196917krzzansteemhive-183959hive-180932hive-185836photographyuncommonlabhive-166405hive-188619bitcoinhive-183397hive-144064hive-150122hive-184714hive-145157lifehive-109690hive-124908hive-139150krsuccesshive-193186hive-103599TrendingNewHotLikersfederico-r (37)in mssql • 19 days agoLevel Up SQL Server Efficiency With the Newest Version of dbForge EdgeDevart has released a major update for dbForge Edge (v3.0) , a comprehensive multidatabase solution designed to simplify and streamline database management, development, and administration across…federico-r (37)in databases • 6 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, selecting the appropriate database management system for each particular project can…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 Management System, developed by MS software developers, is probably the best…rnkchr0 (35)in sql • 3 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 multiple tables. A JOIN clause joins rows from two or more tables based on a…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 database schema and how to manipulate data. To begin training make an account on…manardiab (4)in hive-116221 • 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 today.The company says it detected a botnet operation that targets MSSQL databases with…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 explaining how to do it easily in less time. The main things to be done are first we…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. Advantage is that it provides security. When we use the same password for same…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 statement is used to create a new SQL database.The CREATE TABLE statement is used to…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 combine rows from two or more tables, based on a related column between them.The…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 Server (Transact-SQL), the GETDATE function returns the current date and…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에서 제공하기는 하나, 이는 서버 관리 차원에서의 도구로 디지털 포렌식에 십분 활요하기 어렵다. 데이터베이스 내에서 삭제된 레코드를 복구하는 방법은 크게 다음 네 단계로 나눌 수 있다. Table List 획득 Scheme 획득…ohk5004 (43)in docker • 6 years agoDocker를 이용하여 멀티플랫폼에서 MSSQL + Laravel을 개발해보자.지인이 새로운 프로젝트를 시작하면서 Stack을 설계해주었다. Database는 Oracle로 정해진 상황에서 빠른 진행을 위해 Python을 사용하기로 하고 개발환경을 구축하였다. 하지만 갑작스럽게 Database가 MSSQL로 변경되면서 Language를 변경하게 되었는데 그나마 Linux에서 오랫동안 MSSQL과 궁합을 맞춰왔던 PHP를 선택하게…dailystudy (41)in mssql • 7 years agomssql错误Error8120:分组必须只能查询分组字段和其他字段的聚合平时都是使用myssql的我，最近不得不开始学习mssql了。 在mysql下： select author, Datepart(hour, created) as hh from comments tvb (65)in mssql • 7 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 • 7 years ago在steemsql(mssql)中搜索字符中含有中文我想搜索一下本年发表的和中文诗有关的文章，于是我在linqpad中使用sql语句 select * from comments where created>='2018-01-01 00：00：00' and title like '%诗%'dailystudy (41)in mssql • 7 years ago在mssql下先排序再分组SQL语句在mysql下，我会使用select ... from (select ... from... ... order by ) tmp group by ... 无奈呀，在mssql下，子句中不支持order by 最后，在偶像 @justyy的帮助下，学会了OVER(PARTITION BY)的用法 partition by…
