Migrate SQLExpress to MySQL datetimeoffset issue
Hi, i'm trying to migrate from sqlexpress to mysql, and am having an issue with the DateTimeOFfset(7) field in one of my tables. MySQL is refusing to handle it.. Is there a way to get around this? ...
sql
CASE statement within WHERE statement
Greetings, I would like to include CASE Statement inside my where statement as follows: SELECT a1.ROWGUID FROM Table1 a1 INNER JOIN Table2 a2 on a1.ROWGUID=a2.Table1ROWGUID WHERE a1.Title='title' AND (CASE WHEN @variable is not null THEN a1.ROWGUID in (SELECT * FROM #TempTable)) However, this 'CASE' statement does not work inside 'W...
How do I create queries to SQL Server tables via Visual Studio when no knowledge about SQL nor Linq?
Let´s be frank, my knowledge regarding SQL language is very low. Nevertheless, my boss gave me the task to build a database application using the following tools: SQL Server and Visual Studio 2008; C#. I use the VS DataSet as a local mirror of the SQL Server. And let´s be frank again, my understanding of the VS Query builder is also ve...
Execute query stored in variable in a very specific way
Greetings, I have a problem as follows: I have an SQL variable declared: DECLARE @myVariable nvarchar(max) a third party library set a value for this variable. To simplify, lets say that the value is as follows: SET @myVariable = 'Select ROWGUID from MySampleTable' Now, I want to execute the following query: SELECT ROWGUID FROM my...
Free tool to watch database for changes?
Im looking for a tool that can watch database(mysql and oracle) for changes. When someone inserts or updates something in any(or chosen) table i want to get to know about it. It could be very useful for working with others people code that do some magic in database. I know that it can be done using triggers (see this question), but im ...
SmoApplication.EnumAvailableSqlServers returns server names but not instance names (but only on one machine)
Hi, There are a number of questions about this and a number of possible causes and thus far ive tried them all with no success. situation: i have an app that needs a db to work, onstartup it does a SmoApplication.EnumAvailableSqlServers(false) to get all the instances on the network, shows the user a dropdown, they pick one and i go con...
MS SQL - High performance data inserting with stored procedures
Hi. Im searching for a very high performant possibility to insert data into a MS SQL database. The data is a (relatively big) construct of objects with relations. For security reasons i want to use stored procedures instead of direct table access. Lets say i have a structure like this: Document MetaData User Device Content Conten...
Update Multiple Tables at a Time - SQL Server/T-SQL
I have two tables, Customer and CustomerPhone. Single record in Customer can have multiple CustomerPhone records. As you see in the image below, Phone and Fax resides in CustomerPhone table whereas the rest of the fields resides in Customer table. If user want to edits a customer record, obviously i will have to update the record in Cus...
Returning a row from a With clause
Hello im trying to make a Function that retruns a value. in my function i have this script: WITH t_new AS ( SELECT PersIDOLD, PersIDNEW, RightsMUT, SUM(gap) over(ORDER BY PersIDOLD, PersIDNEW) grp FROM ( SELECT h1.*, CASE WHEN h1.PersIDNEW = lag(h1.PersIDNEW) ...
Update multiple table column values using single query in SQL??
I have two tables like Temp1 and Temp2 The Table Temp1 have id and Col1 fields and The Table Temp2 have id and Col2 fields I need to update the two table fields Col1 and Col2 using single query in SQL. Can anyone help me?????? ...
How do I filter one of the columns in a SQL Server SQL Query
I have a table (that relates to a number of other tables) where I would like to filter ONE of the columns (RequesterID) - that column will be a combobox where only people that are not sales people should be selectable. Here is the "unfiltered" query, lets call it QUERY 1: SELECT RequestsID, RequesterID, ProductsID FROM dbo.Requests I...
SQL Server Management Studio with SQL Server 2000
How to use SQL Server Management Studio with SQL Server 2000 ...
How to insert arabic characters into sql database?
How can I insert arabic characters into sql database? I tried to insert arabic data into a table and the arabic characters in the insert script were inserted as '??????' in the table. I tried to directly paste the data into the table through sql management studio and the arabic characters was successfully and accurately inserted. I loo...
Get list of duplicate rows in MySql
Hi, i have a table like this ID nachname vorname 1 john doe 2 john doe 3 jim doe 4 Michael Knight I need a query that will return all the fields (select *) from the records that have the same nachname and vorname (in this case, records 1 and 2). Can anyone help me with this...
Faster Insertion of Records into a Table with SQLAlchemy
I am parsing a log and inserting it into either MySQL or SQLite using SQLAlchemy and Python. Right now I open a connection to the DB, and as I loop over each line, I insert it after it is parsed (This is just one big table right now, not very experienced with SQL). I then close the connection when the loop is done. The summarized code ...
SQL Comparison Tools
Which SQL comparison tool would you recommend for SQL server database comparisons. I've been looking at SQL Compare and SQL Delta. I'd like the ability to compare and sync database schema and data. ...
Need help with a SQL CTE Query
I have a table that I need to get some specific data from for a view. Here's the base table structure with some sample data: | UserID | ReportsToUserID | Org ID | ------------------------------------- | 1 | NULL | 1 | ------------------------------------- | 2 | 1 | 1 | -----------------------...
Using LINQ to fetch result from nested SQL queries
This is my first question and first day in Linq so bit difficult day for me to understand. I want to fetch some records from database i.e. select * from tblDepartment where department_id in ( select department_id from tblMap where Guest_Id = @GuestId ) I have taken two DataTable. i.e. tblDepartment, tblMap Now I want to fe...
Adding a character to a foreign_key in SELECT statement
Hi, I've got two tables, e.g. table_1 and table_2. I want to Select the foreign key from table_2 with the id from table_1 but the value of the foreign key in table_2 is the id from table_1 with a prefix. table_1.id = 1 table_2.fk_id = fk1 How do I add a value to the id so I can select the fk? Thanks! Peter ...
SqlException: Login failed for user
I use a dbml for my Data Access Layer to provide the data that i need in my app. When i connect from the server explorer everything seems fine. I choose to use my windows authentication and the connection test shows everything works just fine. When i Build my solution and run it on my IIS it says that i'm using a login that is not workin...