Microsoft SQL Server

157K

Solutions

184

Articles & Videos

43K

Contributors

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Related Topics

  1. Microsoft SQL Server 2005
  2. Microsoft SQL Server 2008
  3. Query Syntax
  4. Databases
  5. .NET Programming
  6. Microsoft Access
  7. Microsoft Development
  8. ASP.NET
  9. SSRS
  10. Visual Basic.NET
Refine results

Hello.  I'm looking for the correct way to locate and then delete some records in my database, and need help with forming the SQL.  What I have are some records that have an "item code" and a "barcode…

632 views
Efficient way to get backups off site to Azure
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

I am creating a report with a table that is grouped company. Each company is on a separate page and the grouping is by company.  I need to print the company name in the header of the page.  Currently …

220 views

hi i am trying to install sql server manager on windows 8.1 64 bit machine
but the system keeps throwing up and error
sql server has encounted the following error:
invoke or begin invoke cannot be…

323 views

Hi,
We use SSRS in SQL2012 and we have several demands from the users to embedded the report with the formula, the formula given by users is looks complexs and I wonder if we can do this  with ssrs ?

213 views

I have been tasked with creating a rudimentary change tracking system for tables in our databases. There are about a dozen tables to be  checked with anywhere from 20 - 100 fields per table. In each …

416 views

Hi experts

What is the advantage or disadvantage of creating database user that comes from user of windows login or sql server login.
In which scenarios is it convenient to use each?

318 views

When I do this:
(CODE)

I get this output:
(CODE)

I want to get this part for an array for each day "protien_id['mon'][THISPART]
But only if the "qty" is greater than 0 , for example
(CODE)…

220 views

I have a ms sql server management studio r2 at work, and was if I can do the following below?
1) Can I connect to an Oracle database warehouse, and create queries from this tool? Example, from an …

424 views

This sql was authored for me by someone on this site.  It works well as a stored procedure and it returns the correct records in SSMS but as a sql query in a classic asp page it returns no data.  I am…

518 views

I have the below code.  I am testing a script before I run it in production.  The Table variable @PART is populated with data.  I'm using a loop to populate @PART2.

I'm receiving an error here -> …

212 views
The Eight Noble Truths of Backup and Recovery
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

I have a table that looks like this

FacID    EmployeeID       WorkDate           StartTime         EndTime
1101            150                    04/01/2017          8:00                   13:00

915 views

I developing my first access application with a SQL Server back end. I've not used SQL before and I'm exploring the functionalities that come with the SQL backend.  With help from EE I developed a VBA…

824 views

I am a NUB to SQL Server, developing an Access 2013 back end DB in SQL 14.0 Developer.

I see that it is very easy to implement compression on both tables and indexes to reduce the size of the …

537 views

Hi experts,
I am currently using the code below to specify a time period for retrieving data for an incremental load of a data warehouse. I have manage to get this to specify a 24 hour period. I …

252 views

Jim Dettman provided a potential solution here: -
https://www.experts-exchange.com/questions/28583375/Why-is-it-showing-Deleted-in-all-fields-and-records-in-my-Access-2010-linked-table.html#a40506986…

2035 views

I have a transaction log file of 306 MB for an old SQL Server 2000 database (unfortunately still needed to support a package from external supplier). Over the last couple of days the transaction log …

320 views

Hi, im getting following Error message in SQL server
Exactly one record not found for buffer(s): apttbl (Table name) in LineSp (Stored Procedure name)

313 views

Please provide syntax

254 views

Hi getting  error while running below query  any idea how can it be fixed..

Subquery returned more  than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the …

621 views
Visualize your virtual and backup environments
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

I am trying to do a silent install of the SQL Native Client 11 64-bit to a 64-bit computer. I am building an install with Inno Setup and everything is working as desired except this one item. …

214 views

I am having issues with a crystal report not displaying values, not because of the crystal report, rather the SQL is missing in my file to populate the report.

Essentially, what I need in my SQL …

515 views

Hello ,

Im looking to find a nice easy way of running a script across multiple sql servers from one server which has a table with all the sql server connection details?

I dont want to add them …

414 views

Hey there!

Something I come across frequently is having to take relational data and place it in a "rectangular" format for analysts.  

Take the following tables for example:

PersonTable:

424 views

Hello,

If a stored procedure is added to a publication, is it necessary to do a snapshot with sp_startpublication_snapshot
use [dbtest]
GO

exec sp_addarticle @publication = …

415 views

I need to get a count of values groups by year, based on the value of a certain date field.

What's the query?

Thanks

325 views
Show more content
201506-LO-Top-001

Microsoft SQL Server

157K

Solutions

184

Articles & Videos

43K

Contributors

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Related Topics

  1. Microsoft SQL Server 2005
  2. Microsoft SQL Server 2008
  3. Query Syntax
  4. Databases
  5. .NET Programming
  6. Microsoft Access