Questions tagged [server-to-server]

143180 questions
0

votes
3

answer
24

Views

Wanted to select from a table but it's ignoring it

I want to have a select statement that takes a table parameter of IDs. The desired behavior is that if there are no elements in the table, get all of the values but if there are elements in the table, only select those who's values match the ID parameter of the table. My where clause looks like this...
mark b
0

votes
0

answer
4

Views

Moving Emails from Inbox to Folder Using ExchangeLib

I'm trying to move an email from the inbox to a folder also located within the inbox using ExchangeLib. Here is what I have so far: from exchangelib import Credentials, Account, Message, Mailbox, UTC_NOW from exchangelib.items import SEND_ONLY_TO_ALL, SEND_ONLY_TO_CHANGED import urllib3 from bs4 imp...
JK72
1

votes
2

answer
2.9k

Views

Add Network Location to My Computer (Group Policy)

The shares at my company are becoming unwieldy and we have now officially ran out of letters to map shares to having exhausted A, B, H-Z. Not all of our users need access to some of these shares, but there are enough people who need access to enough different shares that we can't simply recycle lett...
BpH
1

votes
3

answer
3.2k

Views

How to handle if DbTransaction's Commit() or Rollback() throw exception?

I am working with Visual Studio 2012 and MS SQL Server 2008 R2. In my code I am using DbConnection and DbTransaction. This is my code: DbConnection dbConnection = null; DbTransaction dbTransaction = null; try { dbConnection = DbProviderFactories.GetFactory('System.Data.SqlClient').CreateConnection()...
ChumboChappati
1

votes
2

answer
844

Views

How can I throw an error if a parameter is null or 0?

I have this stored procedure: CREATE PROCEDURE [dbo].[get_test_status] @CreatedBy INT OUTPUT, @TestStatusId INT OUTPUT, @UserTestId INT, @UserId INT AS How can I throw an error if the @UserId parameter is a null or zero ? Here's what I tried but it gives a syntax error: IF (@UserI...
Alan2
-1

votes
0

answer
42

Views

How to link HTML,CSS and Javascript files ? (for the given example)

The following is the source code for a Sliding Shopping cart and store,that I came across on codepen.io . The HTML,CSS and Javascript files are given separately. How can I link them? Is it also okay to not have html tags in an html code? I tried linking with the help of script tag ( ) but that did...
Karthika Manoj
0

votes
1

answer
28

Views

How to add a String after multiple comma in a Row using SQL?

Please help me to add a string for ex: CA_ after every comma in a Row data : CA_BA, FU, OT Result :CA_BA,CA_FU,CA_OT I have tried with below code which is not working as expected DECLARE @FullName as NVARCHAR(50) SET @FullName = 'CA_BA, FU, OT' ELECT STUFF(@FullName, CHARINDEX(' ', @FullName, 0),0,...
DataBase
0

votes
0

answer
18

Views

AVOID CASE SENSITIVE IN SSRS EXPRESSION

I AM USING THIS EXPRESSION IN SSRS 1. =iif(Parameters!SchemeConsolidateYn.Value='y',false,true) 2. =IIF(Parameters!ConsolidatedYn.Value='y','Consolidated',First(Fields!BranchName.Value, 'DataSet2')) BUT WHEN I AM GIVING 'Y'(CAPITAL Y ) EXPRESSION TAKING OTHER VALUE.. MY QUESTION IS HOW TO AVOID CAS...
PIYUSH KUMAR
0

votes
1

answer
19

Views

How do I allow a machine to connect to local SQL file

I'm currently working on an EPOS system for a friends shop, I'm currently getting him too test the features, making sure design etc is fine. I've set up the SQL Service Based Database, but the problem seems too be he is getting the error System.Data.SqlClient.SqlException (0x80131904): A network-re...
Kevin Gorman
0

votes
0

answer
3

Views

Macromedia sqlserver jdbc driver object has been closed: error only when running simultaneous requests

I am seeing this error: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Object has been closed. Some other threads mentioned that restarting CF or resetting DSN should sort it out. It did not sorted after the restart. Also my problem looks weird. I encounter this issue when I run...
CFML_Developer
1

votes
2

answer
1.3k

Views

GuideWire BC configuration with SQL Server database

Currently working on PC-BC integration. I need to configure my studios with SQL Server database, For PC its working fine, but for BC I'm getting error. If anyone knows please help me to sort this out. my username is 'username' and password is 'pass#1121' database name : BillingCenterDatabase The er...
Aravind R Pillai
1

votes
2

answer
1.8k

Views

on what Sql Server product levels the Change Data Capture (CDC) feature is available?

I have a project, which involves using Sql Server 2012 Standard Edition. This project needs to have Sql Server Change Data Capture enabled (CDC). Is CDC available in Sql Server Standard Edition?
Eugene Goldberg
1

votes
1

answer
777

Views

Search for column name in multiple databases on SQL Server

I need to find specific columns in many databases, located on the same SQL Server 2008. I have tried many solutions over the internet, but none worked for more than system databases. What is the best way to extend the search to look inside all databases on one server?
Alcor s
1

votes
3

answer
4k

Views

SQL view with “with check option”

I am currently reading the documentation from Microsoft about views and I am kind of confused on what I read about the 'with check option.' There isn't any examples provided in the documentation. Can someone make me a simple example? I understand easier with examples. CHECK OPTION Forces all data mo...
pete
1

votes
2

answer
1.2k

Views

Cannot implicitly convert DateTime to Timespan

Sql Server has the variable TEST_TIME data type as Time(7) I created the tables in C# and it automatically assigned the Timespan datatype. Now, i'm trying to upload csv file data to the SQL database and it is giving me an error ' Cannot implicitly convert DateTime to Timespan'. What would be the bes...
SQLserving
1

votes
2

answer
346

Views

SQL Server LIKE, WILDCARDS, AND, OR operator, braces

Need help with querying a list of names which start with either prefix1 or prefix2. These names should contain values ABC or DEF in their description(next column). Something like the below select query: SELECT Name FROM Table WHERE Name LIKE 'X_%' OR Name LIKE 'Y_%' AND NextCol LIKE 'ABC%' OR N...
Joy
0

votes
1

answer
28

Views

C# data reader value repeats multiple times while debugging

I am reading data from SQL server table and inserting the same value in the PostgreSQL database table. It's a data migration process. The issue is that the data in the SQL is plain text but I see it in the debugging it shows same value multiple times in watch (visual studio 2015). Value displays in...
Maharshi
0

votes
1

answer
16

Views

Executing script for add primary keys to all tables returns error

I want to add Primary Key IDD to every 'Temp...' table in the schema. I'm trying to do it the following way: DECLARE @addId VARCHAR(MAX) = ''; SELECT @addId = @addId + 'ALTER TABLE ['+ TABLE_NAME +'] ADD IDD int IDENTITY(1,1);ALTER TABLE ['+TABLE_NAME +'] ADD PRIMARY KEY (IDD);' FROM INFORMATION_SCH...
Passer7by
1

votes
0

answer
24

Views

What is a better way to manage same database tables for multiple products?

I have multiple products, like Google has drive, docs etc. One common Auth server is there which will contain users table. But I have roles table related to each product, which contains roles for user for respective product. Now how to manage this roles table? I have following ways to do this, which...
ATUL SHARMA
0

votes
1

answer
11

Views

Combine two columns data with first char of second column into one column leaving null values

I have a table like below: ------------------ | Scode | Ucode | ------------------- | qwei | we2 | | iu76 | oi | | ikhj | null | | null | ikj | ------------------- I want output like below ---------------------------- | Scode | ucode | Finalcode | -----------------------------...
Amitesh
1

votes
1

answer
4k

Views

nvl is not a recognized built-in function name

I am executing below query on SQL Server but getting error: SELECT DISTINCT t1.p_id 'Id', (TO_CHAR('sysdate', 'YYYY') + least(SIGN(('sysdate' - to_date('01-Aug-' | | TO_CHAR('sysdate', 'YYYY'), 'DD-Mon-RRRR'))), 0)) 'Year' FROM t1, t7, t9 WHERE t9.ei_id(+) = t7.e_id AND (t7.e_student...
Aruna Raghunam
1

votes
3

answer
1.6k

Views

“Value cannot be null. Parameter name: userName” error when installing MSSQL 2014 Express in Docker

When I try installing MSSQL 2014 Express in Dockerfile, it fails with error 'Value cannot be null. Parameter name: userName'. The following error occurred: Value cannot be null. Parameter name: userName Error result: -2147467261 Result facility code: 0 Result error code: 16387 Please review the summ...
Samuel
1

votes
1

answer
413

Views

SQL Server transactions errors due to different Isolation Levels

I created the following stored procedure in order to examine the isolation level behavior in transaction: CREATE PROCEDURE ReadCommittedIsolationLevel AS BEGIN BEGIN TRANSACTION t1 BEGIN TRY EXEC SnapShotIsolationLevel COMMIT TRANSACTION END TRY BEGIN CATCH PRINT ERROR_MESSAGE() ROLLBACK TRANSACTION...
Offir Pe'er
-2

votes
1

answer
18

Views

C# SQL Stored Procedure Multiple Insert Actions, Influence?

I have an application which uses stored procedures to insert datatables into my SQL Server. At run-time it will access the database, uses the one stored procedure and one table to do several insert actions. But how does it affect my database? For example I have 5 Datatables (dt1..dt5) 1 Table (tb1...
V.Hunon
0

votes
1

answer
12

Views

Weird result with MAX and COALESCE in a SQL query when run by different users

I have a SQL Server query that tries to choose NULL if there is at least one NULL in column PredComplDate or the latest date stored as NVARCHAR(30) The weird thing is that when I run the query it returns correct results, but when my co-worker runs the query on the same computer it returns different...
Ibo
1

votes
1

answer
25

Views

Do I need to specify NOT NULL on a column that has a CHECK constraint?

doctorName VARCHAR(50) CHECK(LEN(doctorName ) > 0) Should I specify NOT NULL on the preceding declaration? A NULL value will not be permitted, since It will not pass the CHECK constraint... So what is the purpose of specifing NOT NULL under this circumstance ?
user2324238
0

votes
0

answer
2

Views

How do I go about using a server to store and retrieve data in Unity?

I have the task to implement a server into my Unity game which I must use to store and retrieve data. The thing is, I know nothing about servers and online databases. Where do I start? And what are the steps I need to stake to just store and retrieve a couple of stats from the game? Here is the task...
John Nguyen
0

votes
0

answer
3

Views

Insert Excel Data into 2016 SQL database using JavaScript, Vue.js and a .net web api

I have a Vue.js Web page that has a drop zone for the end user to drop a Excel Template that could have over 1000 rows. When the End User drops a file a Vue.js DataTable is created to display the data on the screen. At that point they can edit or change data that is in the selected row. Once they...
user1314159
1

votes
0

answer
9

Views

Refreshing external data (from SQL server) in org chart in Visio

I have linked SQL server employee data to create an org chart in Visio, but I can't figure out how to refresh the data in the org chart - for example if a new employee is added for this to automatically appear in the org chart, or if there is a change in title for an existing employee for this to up...
Sarah
1

votes
0

answer
6

Views

How to run a service for multiple VLAN's?

I have a running server hosted on 192.168.254.1 with some VLAN's which can be accessed by each one from 192.168.(TAG).1. I'm trying to run a service on a second computer physically connected to the first one and make it available for all VLAN's by running it on 192.168.(TAG).1 for each VLAN. This se...
Diego Fidalgo
1

votes
0

answer
19

Views

How to create a SQL Server table with exactly 1 MB data in it

I'd like to try and gauge my users internet speeds based on the downloading of a dataset of known size (1MB). Using T-SQL only, how can I quickly create a table with exactly 1MB of data in it? I want to be able to run EXEC sp_spaceused N'dbo.myTableName to verify data size.
ericOnline
1

votes
3

answer
3k

Views

Install SSDT for Visual Studio 2017 community fails on recursion too deep

'Setup Failed' Recursion too deep; stack overflowed 0x800703E9. I have windows 10 and newest visual studio version. I have tried rebooting to make sure I have as many resources as possible. I have 4g ram.
billpennock
1

votes
1

answer
1.2k

Views

SQL Server trigger to check if column value was changed to insert

I have around 25 tables that each have 3 triggers (insert, update, delete) to generate logs on user actions. All these tables get updated each time there is an edit in the UI, though their value is not changed in the UI. In such case I can't just check for if a column is updated, I need to check if...
B Vidhya
1

votes
2

answer
1.1k

Views

How to combine two query results into one and I have different column name

I have two queries I want to combine into a single output, I can't use a Union operator because they have different numbers of columns. **First query result** A1 A2 10 15 **Second query Result** B1 B2 5 10 **The final result would be** A1 A2 B1 B2 10 15 5 10 T...
Bhanu
1

votes
1

answer
214

Views

Is it possible to use Apache NiFi as dataflow engine for MS SQL Server in-database computations?

Is it possible to use Apache NiFi as dataflow engine for MS SQL Server in-database computations? In other words, I would like to use Apache NiFi as if I used Alteryx. For example, can I execute two or more MS SQL procedures sequentially from within Apache NiFi? Can you suggest alternative tools?
user2530062
1

votes
1

answer
95

Views

SQL Server - Syntax error near “Primary” upon execution

When execute my SELECT statement I receive a syntax error near 'Primary'. What am I missing? SELECT Name FROM Production.Product WHERE ProductID IN (SELECT ProductID FROM Production.ProductProductPhoto WHERE Primary = 1);
Cameron Cole
1

votes
1

answer
93

Views

UI Namespace Tableau Extension changes not saving in Tableau Server

I was working on an extension similar to UI Namespace Sample extension (Github Link) provided by Tableau. I have hosted the files in the application server (https enabled) and pointing the trex file to the files hosted there. I am able to drag the extension to Tableau Desktop, select the input from...
Sanjay
1

votes
2

answer
134

Views

Reading data from CSV File and Inserting it into Database

I have a requirement to read the data from a csv file and populate it into the database. I am using the bcp commandline utility for this purpose. My CSV File look like this: First_name,Last_name,EmpID,company,languages 'Jack','Thomas','57616','IBM','C C++ JAVA COBOL PERL SQL ' 'Tim','Cook','10001',...
Abhishek Pandey
1

votes
3

answer
83

Views

How to calculate the number of nodes in a JSON string

Is there a way to calculate the number of nodes in a JSON in SQL. { 'File':[ { 'ID':1, 'Fragment':'Frag1' }, { 'ID':2, 'Fragment':'Frag2' }, { 'ID':3, 'Fragment':'Frag3' }] } Is there a way to count the number of child elements under File node? Answer should be 3 according to the above ex...
Harsha W
1

votes
2

answer
33

Views

Select string that contains square 2

I want to select rows that contain square 2 (this char '²') I did select myColumn from table where myColumn '%²%' I got the columns that contain '²' but also the ones that contain '2'. I tried select myColumn from table where myColumn '%2%' and I got the same result. Is there a way in SQL Server...
AnotherGeek

View additional questions