Microsoft SQL Server 2005

71K

Solutions

27

Articles & Videos

23K

Contributors

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Related Topics

  1. Microsoft SQL Server
  2. Microsoft SQL Server 2008
  3. Query Syntax
  4. Databases
  5. .NET Programming
  6. ASP.NET
  7. SSRS
  8. Windows Server 2003
  9. DB Reporting Tools
  10. Visual Basic.NET
Refine results

Working is SQL server 2005 using SSMS 16

I have a stored procedure in a database  exec get_info 'ID175143'

Msg 2812, Level 16, State 62, Line 22
Could not find stored procedure 'get_info'.
 So…

514 views
NFR key for Veeam Backup for Microsoft Office 365
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

I found a sample code online to get the last part of a string.

This is SQL 2016. I need to get the digits (4576893 for example)

This works. You see there is no forward slash after 4576893  

1412 views

If I have a column like this:

[  "abcd", "xyz", "123" ]

How can I parse it? I want to parse it and insert them in a table (3 rows in this case)

This is sql 2014

625 views

Hi Experts,

I have a function that accepts some parameters and returns a results string.
See attached.

Now I need some help figuring out why the section below only works when the results …

721 views

I'm parsing a JSON file and the datetime field looks like below and I get an error.

What data type I need to declare for it to get the datetime? This SQL 2014

(CODE)

118 views

This project still uses Visual Studio 2005 SQL Server Business Intelligence Development Studio and is doing some strange things.

I added a single column to an SSRS Report and get it working fine.

219 views

"Are triggers slow?" is a general question that I know depends on what the trigger is doing.

This is sq 2014.

We're importing more than 50,000 rows of data. Some calculation needs to be done on …

710 views

Hi EE,

I am getting the error which is described in this article:

http://tritoneco.com/2014/05/15/fix-sql-configuration-manager-cannot-connect-to-wmi-provider/

However when I apply the 'fix' …

1117 views

hi all,

when tempdb log keep growing an un controllabe, what T-SQL command we should use to check what the log is waiting, what process is running against/locking the tempdb log before it can be …

733 views


I am wanting to copy a table, its structure, indexes primary keys constraints etc.  how can this be done via t-script or Stored procedure.

I keep getting this error.

Msg 117, Level 15, State …

2434 views
Comprehensive Backup Solutions for Microsoft
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Hi

We have  legacy shared application/DB server that requires us to downgrade the installed MS SQL Version / Edition

The server hosts an older application and has a single database only within …

1264 views

How could I go back a fiscal year for a given date?

My organization use the format of the Fiscal year as follows:

'FY2015', 'FY2016', 'FY2017'

I need to get these values automatically  using …

454 views

(CODE)

I want to result like:

(CODE)

I am able to get the Present/Absent status of a user for a single  date. But my question here is that I want to get all the users that are present/absent …

1136 views

How to I change this to get the right result in LAG_ROWID see what I got and what i expected
Note the last in the series always has to be NULL too !

   SELECT ROWID, AcctID
, ROW_NUMBER() OVER ( …

215 views

I have a table  "RENEWALS" with 55 records which has a column called ROWID
I want to update this column with a sequential number 1 to 55

RowID  AccountID
NULL    A
NULL    B
NULL    C

I used…

953 views

Hi All,

Is there any simple way to detect and resolve SQL server database deadlock ?
My custom application hangs and the developer suspect that there is deadlock in the DB which I must fix for the…

646 views

Hello Experts,
Need this.
Data(changed data)
Keycol data
1      O1
1      O2
1      O3
2      O4
3      O5
3      O5
7      O2
7      O1
Output I need below

Keycol data       LineNo
1 …

347 views

Hi,

I have this query that is supposed to look for instances occuring within the same timespan as the given dates. What I want is to see is if a person with a particular personID is booked …

1146 views

Hello there,;
What is the error in this code.?

DECLARE @OrderId AS INT = 10028
SELECT * FROM Orders
WHERE OrderId = @OrderId
Appreciate your help.

641 views
Migrating Your Company's PCs
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

I have two tables (tablea and tableb). I would like to set the value of a column in tablea (call it tablea.column1) to zero, if I find a matching row in table b. The matching is done on 3 fields. The …

440 views

I have a SQL database that has a table for invoice header information and another for invoice detail information linked on invoice number.  There is a 1:many relationship between header and detail.  I…

751 views

Whats wrong in this query - Select * from tableA,tableA

1145 views

Guys,
I choose to run update statistics via maintenance plan, however  when the update stats is complete I realized only some of the tables get updated whereas most of the table are not being update …

332 views

I have this currently but its producing duplicate rows.
I added a group by before the where and added the fields from prev and data table but it wouldnt run


(CODE)

My try
(CODE)

error:

1043 views

Why i am getting a star, SSMS does not show me any error. Division Error
SELECT CONVERT(VARCHAR(2),  7140 / 12)

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

Microsoft SQL Server 2005

71K

Solutions

27

Articles & Videos

23K

Contributors

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Related Topics

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