Microsoft SQL Server

157K

Solutions

184

Articles & Videos

48K

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

In SQL

select (getdate()-1)  will give  a day older ...

I need records .. which is less than 5 mins or 10 mins ..

How do i fetch it from getdate()

215 views
Industry Leaders: We Want Your Opinion!
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

hi there
i have table that hold moves for customer like in the bank
there is withdrawal and deposit this is sample :
from start date : 01/01/2017 to 15/01/2017

MID      MDATE     CID    SUM  …

813 views

I have wrote following trigger after that Sql server not working how to resolve this

I think , this the issue "ROLLBACK; " how to remove the Trigger. so i can't connect the SQL server using …

242 views

Hi

I have this data.  I need to get the 3rd field after the ^ in a SQL statement  I am always sure  the data will have this format. Using SQL server 2012

sc^00001JU4QF^129920189^201211070033

312 views

I am just wondering...

421 views

Hello, I have a Sql Server stored procedure that return a single record with two columns in it (Role_Id and Program_Id). I currently have a function in Asp.Net VB.Net that will execute the Stored …

210 views

I have the following sql update statement but need to get the minimum receipt date

(CODE)
I tried to finish the statement but don't know if I am on the right track.  I have multiple lines that …

410 views

How can I do a select that replaces all carriage returns and tabbed sections in the data?

27 views

I have a dataset similar to the following:

ID      Color
1      Blue
1      Red
2      Blue
2      Yellow
3      Blue
3      Red
3      Green
4      Blue
4      Red
5      Blue
5      Red
5      Pink
5      Yellow

I want to find all the IDs that have …

714 views

I need to query a huge Log table that has years of data, and have a plan to improve performance.

I want to create a Map table with one column only, would be a foreign key and it would contain the …

520 views
Use Case: Protecting a Hybrid Cloud Infrastructure
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Please view the following T-SQL code and tell what I am doing wrong PLEASE.

DECLARE @dbname varchar(100)
         set  @dbName = 'TSQL2012'
         DECLARE  @backupTypeToRun CHAR(1)
       DECLARE …

527 views

With the following database...

(CODE)

if it has 14.5 million records, how big might this table me?

Thanks

717 views

I have an exceptions Log table where I will be extracting new records to place into a backup table with the identical schema.

Here is the CREATE query from my Log table

(CODE)

My question is…

410 views

I am using Microsoft SQL Server 2008

I tried using the following stored procedure but when I execute it, I get an error as follows:

Msg 156, Level 15, State 1, Line 4
Incorrect syntax near the …

17 views

I am trying to see active user connection in SQL Management Studio but cannot.

I am using MS SQL 2014

Any suggestions.
Thanks

513 views

I need query an exceptions table with 14 million records and extract only records from the previous 1 year. There is a datetime field which contains the creation date for that row.

How do I write …

720 views

I have sql query in MS SQL server. The query is constructed by either join or exit operator. Generally speaking, which one can achieve better performance?

327 views

MS SQL Server table has following values:

ID Item Value
1 ItemA ValueA
2 ItemB ValueA
3 ItemB ValueB
4 ItemA ValueA
5 ItemC ValueC
6 ItemD ValueA

I need to build query which will return …

114 views

I need to trim three characters from the end of a value. As the example below, I need to eliminate the last three characters _PD

Ex. TA1500_PD

Any help will be appreciated.

227 views
Three Reasons Why Backup is Strategic
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

I want to include records from the last one year but have trouble casting the date...

WHERE Cast(sfl.[DateOfException] as date) > DATEDIFF(year, -1, GETDATE())

What is wrong with this syntax?

450 views

I am a NUB working with a SQL Server back end from withing MS Access 2013.  With help from EE I was able to create some code to invoke a stored procedure and even pass some values from a pass thru …

1953 views

I am interested to learn more on the topic. I need to consider query performance on an exceptions table with over 13 million records.

Thanks

533 views

I have a supervisor table with three columns which looks similar to the one below. I need to reformat the reporting structure in a specific format which is defined below. It basically starts out at …

213 views

Hi Expert,

We had maintenance yesterday. After restarted the server i have getting this error.

Please help!

1120 views

Hi,

I am not a SQL programmer expert and I need some help to complete a store procedure.

We will run a Powershell script to do a TCPIP address mass change and the powershell script is running a …

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

Microsoft SQL Server

157K

Solutions

184

Articles & Videos

48K

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