The error message means you are attempting to add an entityType that does not have a corresponding Project entry. (I don’t know your domain or what you are trying to achieve, but that schema design looks wrong to me…)
The supplied value must be a constant or a variable. You cannot specify a function name as a parameter value. (from MSDN Executing Stored Procedures). You need to do something like this: declare @EffectiveStartDateText varchar(30) set @EffectiveStartDateText = cast(@EffectiveStartDate as varchar) declare @EffectiveEndDateText varchar(30) set @EffectiveEndDateText = cast(@EffectiveEndDate as varchar) RAISERROR ( ‘SPName: InsertUpdateLiquidityDateRule: Start … Read more
From the MSDN Forums: If you right-click the TableAdapter in the Dataset Designer and click ‘Configure’ the TableAdapter Configuration Wizard opens where you can reconfigure the main query that defines the schema of your table. This should leave the additional TableAdapter queries (the additional methods) that were added after initial configuration. Of course the additional … Read more
Ok i ended up doing this : CREATE TABLE test ( from_ts TIMESTAMPTZ, to_ts TIMESTAMPTZ, account_id INTEGER DEFAULT 1, product_id INTEGER DEFAULT 1, CHECK ( from_ts < to_ts ), CONSTRAINT overlapping_times EXCLUDE USING GIST ( account_id WITH =, product_id WITH =, period(from_ts, CASE WHEN to_ts IS NULL THEN ‘infinity’ ELSE to_ts END) WITH && ) … Read more
You can use a derived table or temporary table for example to hold the list of CustomerId then find the non matching ones with EXCEPT. The below uses a table value constructor as a derived table (compatible with SQL Server 2008+) SELECT CustomerId FROM (VALUES(1), (79), (14), (100), (123)) V(CustomerId) EXCEPT SELECT CustomerId FROM Customers
It’s better to include code in your question, rather than ambiguous text data, so that we are all working with the same data. Here is the sample schema and data I have assumed: CREATE TABLE tbl_data ( id INT NOT NULL, code_1 CHAR(2), code_2 CHAR(2) ); INSERT INTO tbl_data ( id, code_1, code_2 ) VALUES … Read more
This is what I’ve learned so far from my research. .NET sends in connection settings that are not the same as what you get when you log in to management studio. Here is what you see if you sniff the connection with Sql Profiler: — network protocol: TCP/IP set quoted_identifier off set arithabort off set … Read more
SQL Server is indeed designed to request as much RAM as possible which will not be released unless this memory is explicitly required by the operating system. I think the best approach is to limit the amount of RAM the server can use which will allow the OS to have a set amount of resources … Read more
Try this method. It should work when field when you want to store image is of type byte. First it creates byte[] for image. Then it saves it to the DB using IDataParameter of type binary. using System.Drawing; using System.Drawing.Imaging; using System.Data; public static void PerisitImage(string path, IDbConnection connection) { using (var command = connection.CreateCommand … Read more
SQL Fiddle Here is a trivial example of use: http://sqlfiddle.com/#!4/8cf15/5