Hi, I have table named "Map" with structure "XPos int, YPos int, FieldType int". The "XPos" and "YPos" are primary key. There are several tables depending on this table, referencing "XPos" and "YPos" columns. In "Map" table users can not add or remove rows. Rarely is changed value in "FieldType" column. The most selects looks like: ...
I have a Twisted application that runs in an x86 64bit machine with Win 2008 server. It needs to be connected to an MSSQL-Server database that runs in another machine (in a cloud actually but I have IP, port, db name, credentials). Do I need to install anything more that Twisted to my machine? And which API should be used? ...
I have a replication set up with pull subscribers and it's deployed in our corporate domain. I have requested to create a dedicated account to run this replication off of. On a pull subscription client in Sql Agent job I get this error: Message Unable to start execution of step 1 (reason: Error authenticating proxy DOMAIN\username, sys...
From a performance point of view is it the same doing this: select * from MYTABLEONE MT1 join MYVIEW MV on MT1.ID = MV.ID ( where the view is create view MYVIEW as select MT2.*, MT3.* from MYTABLETWO MT2 join MYTABLETHREE MT3 on MT2.OtherID = MT3.OtherID ) Or is it better to do this: select MT1.*, MT2.*, MT3.* from MYTABLEONE MT1...
at the moment I turn on the TCP/IP in sql server network configuration and enable the ip used for connection after I'm able to connect using management studio I saw that there is also an option to connect using named pipes, but I could succeed to connect from management studio using the pipe name ...
I have multi databases with same structure its name like that "Client1234" the different in numbers beside "client" i have table called "Transactions" inside each database and i want to run query to get count all raws in "transactions" table in all databases. also when i select database i need to check it has the client word and it has ...
I have multiple SSIS integration packages logging to a database. They all write to the table sysssislog. I want a stored procedure to be able to return the success of the last run of a selected package. How do I identify a package in sysssislog? The executionid field would seem to work, but it seems like it's changing values on mosts...
SSIS seems to insist on logging to the system table SYSSSISLOG. Is there a way to make it use a different table? I want each package to log to a different table. ...
I need to read in a log file created by a SSIS package in my stored procedure. Is there a good way to do this? I tried using this code but it shows the contents of my file as jibberish. Is there some kind of encoding issue it's not handling? Is there an easier way? ...
Possible Duplicate: SQL: Using Select * Hi everyone! I wonder if it is really a bad idea to use the * symbol in stored procedure in SQL server? Is really better to write SELECT NAME, AGE, OTHER_STUFFS FROM TABLE than SELECT * FROM TABLE For sure is only 3 columns in the table.. For performances is it better to enu...
I have a binary field in SQL Server which I want to read one byte at time in a SQL function. In code I would use a byte array. Is there an equivalent in SQL? I couldn't find anything with google. ...
I'm looking to use sql server compact edition for an application where users will not always be connected to the internet. Once the users regain an internet connection, I want them to be able to send the data to the enterprise sql server. I started thinking about this and I don't want to have to loop through a recordset to submit each ...
Given a table: |Name | Hobbies | ----------------------------------- |Joe | Eating,Running,Golf | |Dafydd | Swimming,Coding,Gaming | I would like to split these rows out to get: |Name | Hobby | ---------------------- |Joe | Eating | |Joe | Running | |Joe | Golf | |Dafydd | Swimm...
Using SQL Server 2008. I have a table with the following column: sampleData (nvarchar(max)) The value for this column in some of these rows are lists formatted as follows: ["value1","value2","value3"] I'm trying to write a simple query that will return all rows with lists formatted like this, by just detecting the opening bracket....
My boss wants me to create a few reports in the near future and I think he wants to use SQL Server Reporting Services to deploy the reports. I'm not so sure this would be such a great idea considering that we are a pretty small organization and I cannot see us making good use of or needing the features that this solution offers such as s...
Hi, I know how to encrypt data using ColdFusion using AES_128. I also know how to encrypt data using MSSQL AES_128. Does anyone know if it’s possible to encrypt data in ColdFusion using AES_128, then decrypt the string in MSSQL? I’ve played around with it a lot and can’t seem to figure it out. Thanks, Paul ...
Curious if this is possible: The app server and db server live in different places (obviously). The app server currently generates a file for use with sql server bulk insert. This requires both the DB and the app server to be able to see the location, and it makes configuration more difficult in different environments. What I'd like to...
I have a need to take the parameters passed in to a Stored Procedure (SQL 2005) and write those values into an XML column as one xml document. Looking for an idea on how to start it. ...
When two sets are given s1 ={ a,b,c,d} s2={b,c,d,a} (i.e) TableA Item a b c d TableB Item b c d a How to write Sql query to display "Elements in tableA and tableB are equal". [Without using SP or UDF] Output Elements in TableA and TableB contains identical sets ...
I am trying to execute a pretty-sophisticated query on a string field in the database. I am not very experienced at JPQL, so I thought I would try to get some help. I have a field in the database called FILE_PATH. Within the FILE_PATH field, there will be values such as: 'C:\temp\files\filename.txt' 'file:\\\C:\testing\testfolder\inn...