Microsoft SQL Server

158K

Solutions

187

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

Hello experts,

I have to write a sql joining 6 tables. to retrieve classid, planname, workoutname,date,timeslot,status,staffemail and display them to a gridview.

the tables are as below

416 views
Free eBook: Backup on AWS
Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

How to restore a log which was backuped with COMPRESSION .
Is it the same as restore log without compression?

311 views

Dear All,

Could you please have a short look on this syntax, I would like to have the result in format like 0,134 instead of getting 0:
(CODE)

Could you please advise how to CAST that?

717 views

We have  one application using native application driver to connect to sql server and we want to force the application connect to sql 2014 using sql native client, how do we install sql native client …

316 views

Guys,
How do I convert a values below to the table with 3 columns with name,blocksize and Lable as column heder?

NULL
Name                                        BlockSize Label                  …

322 views

I have a date time field, x.action_dttm , I need to "lookback" and pull all data from 5pm and prior based on the dates in action_dttm field.

I thought I could DECLARE the field as a date time and …

424 views

I have html content I am reading in from SQL Server to display on a page.
This content is a basic string HTML

I need the end user to be able to place if then else statements in there
That will …

855 views

In my sql below I get a result set of technical "duplicate" records.

What I need is to add a column that show the "Parent" record.
If row = 1 it is IndividualID

If row > I it is Row 1 …

822 views

Hi Expert,

This is my following query but there are 3 condition ebs, non-ebs and open

select
case when i.is_ebs = 1 then 'EBS'
        when i.is_ebs <> 1 then 'Non-EBS'
        when …

1422 views

Hey guys-  I currently use a query that I have named tables touched that allows me to see what tables are edited when a user commits a transaction on the application.  It is useful but has its …

419 views
Free Tool: Site Down Detector
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Hi

I have this data in a single column

X^00001JU4QK^129920250^201211070034
Z^00001JUAGI^123995189^201209231021

I need these as 4 separate columns A function is fine

ColA    ColB          …

427 views

(CODE)


Above is my original code.  The issue is, I cannot do a true >= comparison on RD.ResultInfo because it isn't an integer--so I'm getting all kinds of non <= 70 results.  If I change the …

316 views

I have .bak and .trn  backups from an unknown Microsoft SQL Server version.  

Does anyone know if there Is there is a way to tell what version of Microsoft SQL created the files, short of …

738 views

I am debugging some sql server code. See the "Before" code below. It will not run because of the UPDATE statement in the exec statement. So I changed the code to have an extra EXEC statement, with the…

225 views

I have a query (see below) which reports on product sales, and I need to add products set to a status of discontinued.
The field is StockStatusID and the table is product.stockstatus.
I need to link…

217 views

Hi EE,

All of the sudden multiple reports on our SSRS instance have begun timing out I have checked the underlying database no, or index/stats issues and IO performance (read/write) is between …

11103 views

I am looking into a migration of an environment which was recently aqcquired from a previous IT, havent had the best of handovers. The business has 2003 R2 server running SQl 2005 Express , the …

419 views

hello,

I have a stored procedure that builds an xml.

I have discovered that the application that calls the stored procedure and recieves the xml has a limited size for the returned xml …

722 views

Hello All;
(SQL Server, is what it will run on, for the production environment.
Access Database is what it will run in, for demonstration)

This is the code.
The query is sent through Jquery, to …

4326 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!

I have this
(CODE)

How can I use the result of wordPosition and add it to the end of [ClientCodeWodePosition]

ive attached a small spreadsheet to show

I am using the most recent version of …

816 views

I have this query
(CODE)

I would like to know how I can get the number of words so in this case Field NoOfWords would =3 in each row as the original string contained 3 words before it was split.

920 views

Hello,

I am new to scalar functions.

Is there any way to create a function in which you enter the ID in a simple select statement and get the name?

Example of the Table

ID|Name

123|Bob…

315 views

using vb.net and sql server.
On SQL Server I have a table function that returns a date column that is converted in the function like this:
Convert(Date, DateTimeColumn) As DateColumn

When I …

425 views

I am trying to get SQL 2012 Web Edition to use TLS 1.2 instead of TLS 1.0
But if I disable TLS 1.0 on the server then the connection fails.

I am told I need to configure SQL to use TLS 1.2 ... …

121 views

I need to implement TDE for an SQL Database, but we use SQL 2012 Web Edition and apparently TDE is only available for Enterprise Edition, but the difference in cost from Web Edition to Enterprise …

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

Microsoft SQL Server

158K

Solutions

187

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