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

I have a column in  my sql server table  JobCharge Decimal(18,2)
Now I am running this query
Select CAST(JobCharge as DECIMAL(18,15)) from Journal
And I am getting this error - Arithmetic overflow…

38 views
Ransomware: The New Cyber Threat & How to Stop It
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

We have a database which is refreshed three times throughout the day via SSIS.  To minimize downtime we populate an identical staging database and then "swap" the production DB with the staging DB.  …

219 views

Hello, I need your help to write a view that will remove the middle name initial and suffix from a single full_name field.

Assumptions:
a) The middle name and suffix can be in the beginning, …

419 views

Hi;
I have three tables for holding salary master data.
1-      tblMaster
2-      tblAllowance
3-      tblDeduction
tblMaster has columns of:
o      mstId
o      mstEmpNo
o      mstHireDate
o      mstBasicSlary
o      …etc.

845 views

I am using sql server 2014

How would I edit the following code spinet so that I get 1000 sequential rows instead of 100.

CREATE TABLE Table1
    ([Folder] int, [casefile] varchar(20))
;
    …

451 views

I have 5 different tables in which I want to create a new record, pass a value to it and return the primary key of the newly inserted record. I can not see the sense in creating 5 sproc to do this …

516 views

I have a Function which might return a Null Value. As you can see I am using vbNull which is failing "Invalid use of Null".
How should I test for this?
(CODE)

515 views

Hi,

Is someone use the NOLOCK command in a view  like below.

Select col1, col2, col3 from view1 with (nolock) does this impact the view definition that tables are inside the view? and set the …

1028 views

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…

518 views

I am using MS SQL Server 2014, the database is running in  2008 compatibility mode. The page I am working with is written in Classical ASP and, must for now, stay that way.
I am having a bad time …

616 views
PRTG Network Monitor: Intuitive Network Monitoring
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

I have below scenario and in SQL i want to display ID of first max value. I want to display 5 because it has first max value

ID   Value
1      10
2       20
3       30
4       40
5       50
6…

328 views

is there any specific best practices on how and when to change page verification in MSSQL from torn page to checksum - and any specific precautions we should take before/after if it causes issues? is …

128 views

Have you ever had situations where a backup of a SQL database would not restore, and if so what kinds of issues can mean a SQL backup cannot restore into a live or test instance. we are reviewing how …

325 views

I am looking at the security of a progress database (now openedge). I wondered what the equivalent tool to SQL Server management studio would be for connecting to a progress/openedge database, to …

246 views

Not sure why this isn't working from SSMS. Working fine from a command prompt

(CODE)

616 views

Hi,

A few years ago I put the following code together which connected to an SQL server on my network and returned a list of available databases on that server.  I have returned to this project to …

1025 views

Hi,

I have the following code

(CODE)

I have a form with two fields (From & To) dates.  I am trying to filter the report to display only the records between the two dates.  What is wrong with…

1046 views

Hi,
Right now, i am doing migration from SQL server to oracle. In sql server, some stored procedures contains keyword like
sp_xml_preparedocument, openXML, sp_xml_removedocument,

I think, they …

425 views

hi,

right now configuration some test on SQL server 2014 transaction replication and we receive the following error:

Error messages:

(CODE)'

it seems that the mentioned error was due to …

1635 views
Best Practices: Disaster Recovery Testing
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Hi Experts
    Is there any free tool which can automatically build the ERD (Enterprise Relationship diagram) of a Database ? (What I was looking is a diagram which shows the relationships based on …

429 views

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  

1415 views

Its has been years since I wrote a curser and was hoping for some guidence.


Lets say I have a select statement that returns me a unique list of Customers

So here is the select

Select  …

210 views

I would like to know what is the 'size' specification for the input parameter type  for adDBDate .
Seems I can find the size for everything but that one. Thank you.
Below is my code:
(CODE)

822 views

Trying to filter by current Month in a table.  I know I can use the "m" but not sure what to replace it with.  

1022 views

We have a pair of 2012 R2 servers clustered together with SQL 2012.  Recently when we attempt to attach a database and associated log file we get the attached error.  We are unaware of or even if any …

912 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