Microsoft SQL Server is a relational database management system (RDBMS). Use this tag for all SQL Server editions including Compact, Express, Azure, Fast-track, APS (formerly PDW) and Azure SQL DW. Do not use this tag for other types of DBMS (MySQL, PostgreSQL, Oracle etc.). Do not use this tag for ...

learn more…| top users | synonyms (3)|sql server jobs

0
votes
0answers
9 views

Inserting decimals in SQL Server using jdbcTemplate

I have this piece of code to insert 1 register in a SQL Server DBint numOfRowsAffected=remoteJdbcTemplate.update("insert into dbo.[BANKIA Resource Time Registr_] "+ "( [Entry No_]...
0
votes
0answers
16 views

Sorting an alphanumeric column in SQL with mix of alphanumeric and alpha-only values

I have a requirement where I have to apply sort in an SQL query by an Alphanumeric column such that the values in it get sorted like the following:ADAHAK1B1B2B3xB3yB11C1C6C12xUIPinstead ...
0
votes
0answers
22 views

Create Table Variable only when there is rows to insert in it

In Query that haves 3 tables variables joined with 2 tables in some cases where those variable tables are empty (no rows) in the Execution Plan still appears with 16% cost for the scan of each table ...
0
votes
1answer
38 views

C# Fast Upload Related Tables

I am working on a dynamic loader. Based on a database table that defines the flat text files I can read a single file with multiple record types and load it into database tables. The tables are ...
-2
votes
1answer
65 views

How to insert a string with ( / ) in SQL Server database? [on hold]

I have string that contains a "/".How can insert that string into database table column?When I tried to insert record using simple query like :insert into XYZ values (2567, '364722988', 'ABC', '...
-1
votes
2answers
88 views

sql not able to insert into table?

I am not sure this an syntax error or an problem with my IDE (Visual studio), but cant seem to insert into the datable I have added to my project?private void create_user_username_box_Leave(object ...
0
votes
1answer
14 views

Equivalent of MSSQL's STUFF and XML PATH in MYSQL

I have an mssql database that I want to convert/migrate to mysql. I am getting the error message below.Error Number: 1064You have an error in your SQL syntax; check the manual that corresponds ...
-1
votes
0answers
23 views

SQL Server Agent jobs fail

I have some jobs run by using SQL Server Agent, all jobs ran without any issue.But now I got a connection issue, I know I do not have any authentication issue. Is there anyway to solve this issue?
-1
votes
0answers
38 views

Error in my php code when trying to insert data in database with arrays [duplicate]

I was wondering if someone could help me with this code?Cant really figure out where the error is. It doesnt insert anything in the database but i dont get any errors, even with error reporting on. ...
0
votes
0answers
27 views

Issue updating a View on another instance

We have a SQL Server 2014 database that is basically a set of views to a 3rd party remote SQL Server instance that we connect to as a linked server. They are upgrading to 2016 and said that we would ...
0
votes
1answer
37 views

T-SQL use operator '&' like function SUM/COUNT/etc

Hi,in SQL-Server (2014) i search too make a request like this:SELECT T.`Text`,&(T.`Numeric`)FROM MyTable AS TGROUP BY T.`Text`;I would like use '&' like SUM()/MAX() ...
0
votes
0answers
8 views

SQL Migration Process Using the Data Migration Assistant

When using Microsoft's Data Migration Assistant (DMA), what is the "step-by-step" approach?This is my best guess:Run DMA to detect compatibility issues from the source to the target serverRun DMA ...
2
votes
1answer
80 views

INSERT, UPDATE, DELETE in database with one button

I have an application that makes the user chose an item from a list, then the components of this item are displayed and when clicking a component, a dataGridView is populated with the stock of that ...
0
votes
0answers
28 views

Pass value of Where Filter in SubQuery written in Select Statement

I need the Date which I put at the Where Clause in the ModifiedDate in the SubQuery Where Clause (NeedWhereDateHere).I my application, I have the only option to send the date in the where clause, but ...
0
votes
0answers
26 views

[SOLVED]Optimize query in Sql Server with a huge table

This is my first question, so I apologize in advance if there's anything out of order. I've searched for an answer but I couldn't find anything that fit my current situation. I have this SP showed ...

153050per page
angop.ao, elkhabar.com, noa.al, afghanpaper.com, bbc.com, time.com, cdc.gov, nih.gov, xnxx.com, github.com,