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 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))
;
    …

429 views
NAS Cloud Backup Strategies
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

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 …

513 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)

511 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 …

1024 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…

515 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 …

614 views

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 …

126 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 …

321 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 …

244 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.  

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

(CODE)

615 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…

1042 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 …

424 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 …

1633 views

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 …

427 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  

1412 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)

819 views
Announcing the Most Valuable Experts of 2016
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

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 …

911 views

I'm doing a small audit on our data and
I want to take a column that has a long string that separates product models with a comma and see if any of those models are not valid from  separate table …

29 views

Over the past 10 years I have developed several applications using SQL Server as the back-end database with Access "projects" (.ADP) as the front-end applications.

Now that the Access ADP Projects …

1532 views

Hi EE,

I have got the set of data from which i want the count of those bookings where the column WebSupplier has changed from 0 to 1 or 1 to 0.

below is the sample data
(CODE)

thanks a lot …

930 views

A hypothetical situation:

I have product features. These features are stored as BITWISE values in the database.

In my back-end code, I have a [Flags] enumerator that lists out all the features …

624 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