One advantage is that you learn how to not expect a 3rd-party library to be a magic bullet, and that no matter what you select, there will be issues to overcome.

entity-framework

stored-procedure

NHibernate

How to export the stored procedure statement into a sql file?

9 Jun 2011 by #realJSOP

Why would you want to do that? If the stored procedures are already in the database, there's no reason to export them to their own files. You're completely defeating the purpose of having the stored procedures IN the database.

SQL-Server

stored-procedure

How to pass a db-Name to a stored procedure

19 Jul 2011 by #realJSOP

As a string.

stored-procedure

How to get SQL runtime errors ?

10 Dec 2016 by #realJSOP

Why don't you have the query that threw the error log it instead of making the app do it?

How to pass .NET collection of objects (parent-child) hierarchy to a SQL server stored procedure

24 Dec 2016 by #realJSOP

I've never had performance issues with sql server that were not caused by something I've done. I don't use table valued parameters.You can either iterate the list and save the onbjects one at a time, or do like the first answer suggested, and serialize all the data into xml and pass the XML...

Sql stored-procedures-DO-NOT work please help

19 Feb 2018 by #realJSOP

I suspect all of your records have the same value for saleinvid.

SQL

SQL-Server-2008R2

stored-procedure

How to get output parameter of a stored procedure in SSIS package using C#?

11 Apr 2018 by #realJSOP

You sure have a weird way of doing things. Try moving this line to be AFTER the call to package.Execute() string Result = vars["Result"].Value.ToString();

stored-procedure

SSIS

How to we use dynamic queries in EDMX files i.e. Enterprise library

27 Mar 2019 by #realJSOP

The easiest way - setup your own database, import the data into it (using the customer's stored procedures to acquire the data), and then write EF models to load it from YOUR database. EF will NOT be able to properly define models from datasets *returned by stored procs* that are selected from...

In mysql stored procedure how to custom where clause as users selections ?

12 May 2019 by #realJSOP

MySQL doesn't do dynamic sql like SQL server does. However, you can do prepared statements. Google "mysql prepared statement".

entity-framework

MySQL

stored-procedure

How to do a dual select in C# using a stored procedure

22 Jun 2020 by #realJSOP

var result = new DataSet(); var dataAdapter = new SqlDataAdapter(command); dataAdapter.Fill(result); At that point, you can reference each result set in different tables inside the dataset... result.Tables[0] and result.Tables[1]

stored-procedure

When run query for only part it take too much time for only one part why ?

21 Jul 2020 by #realJSOP

19 tables (18 joins), with a where clause and a sort. That's why it takes 50 seconds.

SQL

stored-procedure

While debugging in WCF method getting error such as {"must declare the scalar variable \"@POL_NBR\"."}

21 Jun 2022 by #realJSOP

Your query is malformed... SET @sql_Query = 'Update TPCA set ' IF ISNULL(@POL_NBR, '') '' BEGIN SET @sql_Query = @sql_Query + 'TPCA.POL_NBR=''' + @POL_NBR + ''' END

SQL

WinForms

stored-procedure

Stored procedure in SQL

29 Sep 2014 by /\jmot

Try like this..CREATE PROCEDURE usp_makebid( @userID varchar @auctionID varchar)ASBEGIN declare @HasBid intdeclare @Opres intset @HasBid=0set @HasBid=select bids from Users where id=@userIDif @hasBid>0begininseri into Auctions (column values)select...

Addition Condition In Store Procedure Query.

14 Nov 2014 by /\jmot

I have a Store procedure with 8 optional parametes, if the optinal parameter passes when calling the store procedure it'll add the condition to the Query according to the parameter value.This is My Store ProcedureALTER PROCEDURE [dbo].[Copy_Search_Candidate_forcampus]...

SQL

stored-procedure

How to make query to change data

5 Dec 2014 by /\jmot

Description here..http://msdn.microsoft.com/en-IN/library/ms188043.aspx[^]

SQL

stored-procedure

Error while converting in to nvarchar

21 Jun 2013 by 7045Jeegnesh

CREATE Procedure [dbo].[InsertUpdate_DashBoardMst] ( @nDashBoardNo numeric(18,0), @nCompanyNo numeric (18, 0) , @nPositionNo numeric (18,0) , @vDashBoardTitle nvarchar (255) , @iWidth Integer , @iHeight Integer , @iLayoutNo Integer , @bIsActive Bit , ...

SQL

stored-procedure

How to create a stored procedure having a value and array input

16 Aug 2012 by __TR__

Hi, The below article might be helpful.Sending a DataTable to a Stored Procedure[^]

stored-procedure

How to Get the Primary Key in stored Procedure

20 Aug 2012 by __TR__

Try the below sampleDECLARE @Inserted_Identy Bigint; if not exists(Select * From TableA Where NAME = @NAME and PINCODE = @Pincode ) Begin Insert into TableA (NAME,PINCODE,Address,MOB) Values(@NAME,@Pincode,@Address,@MOB) Set...

SQL

stored-procedure

How to create a stored procedure having a value and array input

16 Aug 2012 by _Amy

You could convert the array to a delimited string and extract it again in the stored procedure.int[] arr = {0,1,2,3,0,1};string result = arr.Aggregate("", (s, i) => s + ";" + i.ToString());Try these links:Parse delimited string in a Stored procedure[^]Array Parameter Handling in a...

stored-procedure

Do all StoredProcedures are percompiled?

17 Sep 2012 by _Amy

Putting your effort in the basic questions may increase your skills. Don't run from finding a simple answer rather than asking to others. You could have tried google[^] for it.Check top 3 links here:Overview of SQL Server Stored Procedure[^]Stored Procedure in sql server[^]SQL Stored...

stored-procedure

Stored Proceedure Exception

28 Feb 2013 by _Amy

Try this:protected void btn_submit_Click(object sender, EventArgs e){ cnn.ConnectionString = ConfigurationManager.ConnectionStrings["jin"].ConnectionString; try { string path = @"~/images/"; if (FileUpload1.HasFile) { string path1 =...

ASP.NET

stored-procedure

update query in procedure issue

19 Apr 2013 by _Amy

You can just swap the update statement like:IF (status =1) OR (status =2)--What status is doing here? From where it came? Get the value for it from your table.BEGIN UPDATE issuesdetails SET assignedto=@employeeid,status =2 , testerassign=@testerid WHERE...

ASP.NET

stored-procedure

How to add two time(like 10:30:16,14:27:44) in sql server 2008

26 May 2015 by _Asif_

Try this, your task is now to add seconds part :)DECLARE @TBL TABLE( intime TIME, outtime TIME)INSERT INTO @TBLSELECT '10:30:16', '10:10:11'UNION ALLSELECT '14:27:44', '13:47:55'UNION ALLSELECT '9:35:01', '18:31:51' DECLARE @InTimeString VARCHAR(10) DECLARE...

SQL-Server-2008R2

stored-procedure

Query data in SQL server 2008

16 Sep 2015 by _Asif_

Try thisDECLARE @TBL TABLE( ID INT IDENTITY, REPORTDATE DATETIME, GAMENAME VARCHAR(50), TOTAL INT)INSERT INTO @TBL (REPORTDATE, GAMENAME, TOTAL)SELECT '2015-09-05', 'Ninja Runner', 2000 UNION ALLSELECT '2015-09-05', 'ZigZag', 1500 UNION ALLSELECT '2015-09-05', 'Sky...

SQL-Server

stored-procedure

How can Make an Generating auto increment unique ID which contain today date, month, year and some number in SQL Server

25 Jan 2016 by _Asif_

A moderate level design could be like* Have a table COUNTERS(ID, currentValue, maskingRules)* With values (1, 1, 'yymmdd9999')* Have a SQL Function which does following * Read masking rule * Parse it and fill it accordingly * Update CurrentValue * Return the...

SQL-Server-2008R2

stored-procedure

How to use sub query in stored procedure?

7 Feb 2016 by _Asif_

You need to break your code in two parts. First will fill a table variable by splitting returned result of a sub query and the second part will use this table variable for getting result. A pseudo code would be like thisDECLARE @TBL TABLE( GL_ID VARCHAR(100)) INSERT INTO @TBL...

How to display parts not exist on trade code temp and exist on parts temp table by trade code ?

22 Jan 2020 by _Asif_

Its a simply query that do not require master level skills. All you need to know about different type of Joins. We advice you to read good articles about JOINs. Try this select P.PARTID, P.SUPPLIERID from #PARTS P left outer join #TradeCodes T on P.PARTID = T.PARTID WHERE T.PARTID IS NULL

SQL

stored-procedure

What mean index seek noncluster where select based on mslid?

29 Jan 2022 by _Asif_

Well, By looking your execution plan the problem is not in index rather it is the insert that taking significant time. Inserts usually don't take that much time so you need to check with DBA why inserts are taking that much time. A quick...

T-SQL

SQL

stored-procedure

store procedure in asp.net

17 Feb 2013 by _Maxxx_

Don't quite understand your talk of loops etc. but an observation:Your code is summarised asif duration

T-SQL

stored-procedure

Using MSXML2 from a SP on SQL 2014

7 Jul 2017 by _Maxxx_

I have a SP using MSXML2 to call a Web Service.It is working on my local machine using SQL Server 2008R2It is not working on my server, using SQL Server 2014.Running the same MSXML2 from a Javascript program from the command line, works on both local machine and server.The SQL Server...

SQL-Server-2014

ActiveX

stored-procedure

Using MSXML2 from a SP on SQL 2014

5 Aug 2014 by _Maxxx_

Well, OK , looks like I will have to answer it myself.It turns out that the MSXML6.dll on Windows 7 is different to the MSXML6.dll on Windows Server 2012I don't know what the difference is, but the 'send' method fails on the 2012 version with an error Msxml6.dll 0x80070057which...

SQL-Server-2014

ActiveX

stored-procedure

Insert bulk Records In Master/Detail Tables Using Stored Procedure Or Parameterized Quries

15 Feb 2015 by _Maxxx_

You can pass a datatable as a parameter to a stored procedureThere's an article about it at Passing a datatable to a Stored Procedure in SQL Server 2008[^]So populate your datatable with the detail values, and call the SP with the table value parameter as described.

stored-procedure

master/detail

Dropdown list binding with financial year..

22 Nov 2012 by _Natula

Let say we received the given date from text box:- private void button1_Click(object sender, EventArgs e){DateTime GivenDate = Convert.ToDateTime(textBox1.Text);int GivenYear = GivenDate.Year;for(int i=0; i

I can't get all data from view in sqlserver

17 Mar 2023 by A Belal

i create table orderSales, typeCustomer, Customer i create view SELECT [id] ,[OrderDate] ,[Total] ,[Pay] ,[Remain] ,[Sales] ,[ValueAdd] ,[CustomerType] ,[Name] FROM [dbo].[vOrdersAll] GO but...

Microsoft.data.sqlclient.sqlexception: 'incorrect syntax near '/'.'

7 Jul 2023 by A Belal

I want to create invoice Error Is An unhandled exception occurred while processing the request. SqlException: Incorrect syntax near '/'. Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, bool breakConnection, Action...

Paid and remain amount always saved null in database

10 Jul 2023 by A Belal

paid and remain Amount always saved null in database although i get value is not null by javascript What I have tried: my storedProcedure USE [OnlineMarket] GO /****** Object: StoredProcedure [dbo].[InsertintoSalesInvoice] Script Date:...

Store procuder execution error

11 Sep 2013 by a.pkumar

pass @DegreeID tooexec dbo.AdminDegree @Mode = 'Select' ,@DegreeID=2 like

SQL

stored-procedure

Store procuder execution error

11 Sep 2013 by a.pkumar

pass @DegreeID too exec dbo.AdminDegree @Mode = 'Select' ,@DegreeID=2

SQL

stored-procedure

I want Rollback Outer Transaction instead off commited(inner)Transaction

18 Oct 2012 by Aadhar Joshi

U can use Save Point functionality given for try can catch..SET NOCOUNT ON BEGIN TRANPRINT 'First Transaction: ' + CONVERT(VARCHAR,@@TRANCOUNT) INSERT INTO People VALUES ('Tom') SAVE TRAN Savepoint1PRINT 'Second Transaction: ' + CONVERT(VARCHAR,@@TRANCOUNT) INSERT INTO...

SQL-Server

stored-procedure

database

How to prevent insert duplicate id in sql server

2 Oct 2014 by aarif moh shaikh

Create this Stored procedure ... You will get your Solutioncreate procedure sp_by_aarif@item_id int=0,@item_name varchar(50)= ''ASBEGIN if exists (select * from yourTableName where item_id=@item_id) begin Insert into yourTableName values...

SQL

SQL-Server-2008R2

stored-procedure

when i write a column in store procedure it shows error..

17 Sep 2012 by Aarti Meswania

ALTER PROCEDURE [dbo].[selectDataByDDLValue](@ddlValue varchar(50))ASIF @ddlValue = 'Uname'BEGINselect distinct Fname,Lname from Client_registration_tblENDELSEBEGIN IF @ddlValue = 'Delivery_Date' BEGIN select a.Fname,a.Lname, b.Product_name,b.Product_quan,b.Delivery_date ...

SQL-Server

stored-procedure

Stored procedure nesting in SQL server

27 May 2013 by Aarti Meswania

See example...create table #temp( field1 nvarchar(146), field2 sysname, field3 nvarchar(64), field4 nvarchar(64),field5 nvarchar(64),field6 nvarchar(64),field7 nvarchar(2126))insert into #temp ( field1 , field2 , field3 , field4 ,field5 ,field6 ,field7 )exec sp_helpconstraint...

SQL-Server

stored-procedure

DataTable

Check for output by passing a parameter to stored procedure

2 Jun 2013 by Aarti Meswania

it seems like you wat to get sal as outputALTER procedure [dbo].[Test](@name varchar(50),@sal int out)asbeginselect @Sal = Sal from Salary where Name=@nameendexecute sp in sqlexec Test 'Name to pass', 0Happy Coding!:)

SQL

SQL-Server

stored-procedure

spilting varchar value (dot) seperator

12 Mar 2014 by Aarti Meswania

DECLARE @FromVal Varchar = '2013.001'DECLARE @ToVal Varchar = '2013.007' SELECT SUM(SIGNEDDATA)FROM FACPLAN INNER JOIN [Time] ON [Time].TIMEID = FACPLAN.TIMEID INNER JOIN mbrVERSION ON [Time].ID = mbrVERSION.CURRENT_MONTHWHERE...

SQL

stored-procedure

I not not getting result from stored procedure

1 Oct 2019 by Aarti Meswania

Hello Akshay, Please go through below code, Hope it helps CREATE PROCEDURE spGetSurveyOrDistrict @SurveryorName VARCHAR(8000) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; SELECT DISTINCT tsd.State AS...

SQL

stored-procedure

"Conversion failed when converting date and/or time from character string"

7 Apr 2013 by Abbas mca

My stored procedure is as follows, -- Add the parameters for the stored procedure here @FromDate datetime, @ToDate datetime --Select query DECLARE @query nvarchar(max) set @query='SELECT [col1] FROM [Table1] ...

stored-procedure

This code RETURNEE NULL way

30 Apr 2015 by Abdul Samad KP

If you are not getting any error ,then the problem is with the date format.changereportcustomer.SetParameterValue("@InventoryDate", this.dateTimePicker1.Text);toreportcustomer.SetParameterValue("@InventoryDate", this.dateTimePicker1.Value);

SQL

stored-procedure

Recursion in Stored Procedures

28 Nov 2013 by Abdur Rashid

Create Stored Procedure CREATE PROCEDURE Factorial_ap@Number Integer,@RetVal Integer OUTPUTASBEGINDECLARE @In Integer, @Out IntegerIF @Number != 1BEGIN SELECT @In = @Number-1EXEC Factorial_ap @In, @Out OUTPUTSELECT @RetVal = @Number * @OutENDELSEBEGINSELECT...

stored-procedure

recursion

Recursion in Stored Procedures

27 Nov 2013 by Abdur Rashid

How to use recursion in Stored Procedures

stored-procedure

recursion

increasing value without using cursor

23 Jan 2012 by Abhi KA

uisng update only u can increase .how to increase using cursor?

stored-procedure

Send images using stored procedures in email

11 Jun 2017 by Abhi1 Kanobi

I have a stored procedure that is used to send mails to a list of people . I have stored the image in varbinary(max) in my database in imagetable . I am unable to send the email along with images in body . Can anybody please help ? What I have tried: have tried adding the image in body...

How to call mysql stored procedure with parameters in c#.net?

1 Jan 2014 by Abhilash Boggavarapu

I'm new to MySql and also connecting MySql from visual Studio.Please help me in this, How to connect to MySql from Visual Studio and How to call mysql stored procedure with parameters in c#.net.Thanks & Regards

C#4.0

MySQL

stored-procedure

get total days beetween two dates in stored procedure

18 Nov 2020 by Abhilask kumar

get total days beetween two dates in stored procedure.

SQL-Server

stored-procedure

I want to update and delete xml file using stored procedure in sql server

4 Feb 2014 by Abhinanda2491

0 down vote favorite I want these things should happen in my stored procedure,If XML file has records, Delete all existing records for the PlantAreaID, Read and insert records from XML,And even i want to know how to create an XML file in SQL for this tableIf successful Call...

XML

SQL-Server

stored-procedure

Getting data from xml and inserting into existing table using stored procedure and c#

16 Feb 2014 by Abhinanda2491

public int UpdatePlantContacts(int PlantID, List PlantContacts) { int i = 0; DataTable dt = new DataTable("PlantAreaContact"); dt.Columns.Add("PlantAreaID",System.Type.GetType("System.Int")); dt.Columns.Add("PlantAreaContact", System.Type.GetType("System.String")); ...

C#4.0

stored-procedure

How to pass a db-Name to a stored procedure

19 Jul 2011 by Abhinav S

Some examples that could help you -http://forums.databasejournal.com/showthread.php?t=36588[^]http://itknowledgeexchange.techtarget.com/itanswers/passing-a-database-name-as-a-stored-procedure-parameter/[^]

stored-procedure

How to get Specific return value from stored procedure in asp.net

31 Dec 2012 by Abhinav S

If you want to get the primary key value, you can always use identity value.Here[^] is a good example that accomplishes this task.

ASP.NET

stored-procedure

this is my stored procedure for insert. how to write the same for update.

9 Jan 2013 by Abhinav S

You need to identify a primary key set for your table before you run an update - it could be firstname, lastname combination or even a new unique primary key identity.You can then easily update based on this key.E.g. Update primaryskill=@primaryskill,...

stored-procedure

How to fetch the next records from a table in sql database one after other

12 Apr 2013 by Abhinav S

It will not be optimal for you to fetch records in groups of 30 from the database. To optimize this connection and network overhead, get all data using a single query. Put this data in a DataTable.Loop through groups of 30 in the DataTable, get the email ids and send mails before proceeding...

website login problem?

14 Feb 2014 by Abhinav S

You can add the user name to the web site's session parameter. You can then access the login id.Do not pass the password across the application.

jQuery

ASP.NET

stored-procedure

How I Convert Xml(Return By Webservices) Into Table Using Store Produre...

26 Feb 2014 by Abhinav S

You have to write the code for it.Parse the XML and convert it into data tables or directly push it into the database.Don't know, but this video[^] might help.

ASP.NET

stored-procedure

webservice

How do I retrive the data from a table by passing a parameter to a stored Procedure and store it in a DataSet

10 Mar 2014 by Abhinav S

TryC# Dataset Tutorial [^]http://www.dotnetperls.com/dataset[^]http://www.homeandlearn.co.uk/csharp/csharp_s12p6.html[^]

C#3.0

stored-procedure

How can do stored procedure dynamically?

8 Jul 2014 by Abhinav S

Pass the year as a stored procedure parameter and run a query against this parameter.E.gCreate SP_1 as@Year as char(4)ASSELECT * FROM ( SELECT salesEXE,SalesEXEName,name,gross,YearNo FROM vw_Pivot_Month_ALL) TableYearNopivot (Sum(gross) for [year] in (@Year))pivotTable

SQL

stored-procedure

How to trace a Store Procudure Parameters in sql

25 Nov 2014 by Abhinav S

How to: Debug Stored Procedures[^] could provide some help to you.

SQL

stored-procedure

how to solve error "The multi-part identifier could not be bound." in storeprocedure

23 Dec 2014 by Abhinav S

You are updating while simultaneously joining two tables.So this is what you could try UPDATE [dbo].[SOMasterTEMP] SET qty= dbo.SVendorMaster.Mon FROM dbo.SOMasterTEMP,dbo.SVendorMaster WHERE dbo.SOMasterTEMP.svcode=dbo.SVendorMaster.SVCode

stored-procedure

Populate one dropdown list based on the selection of other dropdown list

12 Feb 2015 by Abhinav S

You need cascading dropdowns -Creating Cascading DropDownLists in ASP.Net [^]Populate Cascading DropDownList On Selection ASP.NET[^]Tutorial ASP NET Cascading Drop Down Lists with AJAX [^]

stored-procedure

Get the last generated identity from sql server

11 Apr 2015 by Abhinav S

Check out six different to get the last identity - 6 Different Ways To Get The Current Identity Value in SQL[^].

SQL

stored-procedure

Identity

My stored procedure is not working, I'm trying to insert new row.

13 Apr 2015 by Abhinav S

Run this and try -ALTER PROCEDURE [dbo].[val]@Name1 varchar(20),@Amount char(10)ASBEGINInsert into store (Name1, Amount)values (@Name1, @Amount)ENDThe difference here are the brackets.

SQL

stored-procedure

How Can I Loop Using "For Each" Loop In Stored Procedure

9 Jun 2015 by Abhinav S

Try using for loop in stored procedure[^]

SQL

stored-procedure

How Can I Loop Using "For Each" Loop In Stored Procedure

9 Jun 2015 by Abhipal Singh

There is nothing like foreach in SQL. If you want to iterate your list of numbers you can use a WHILE loop.First, you need to iterate your csv DECLARE @partyIDs VARCHAR(MAX)= '750005,750007,750009,7500011,7500021,75000251'check the link below to see...

SQL

stored-procedure

how to bind category then subcategory bind in single dropdown using asp.net or vb by store procedure?

19 May 2014 by abhishek burnwal Kolkata

My Table is-:Category fields are-: CategoryID, Category_Name, Category_Description 1 Science aaaaa 2 Language lllllSubCategory fields are-: SubCategoryID, CategoryID,...

How to update grade marks column from another table?

19 Sep 2017 by Abhishek Burrnwal

StudentMarks - ID, Subject, Marks, Grade Another Table GradeMarks - ID, Marks, Grade ID Marks Grade 1 91 A+ 2 81 A 3 71 B+ 4 61 B 5 51 C+ 6 41 C 7 31 D 8 21 F ID Subject Marks Grade 1 Hindi 57 2 Eng ...

How to update last column by employeeid name using store procedure?

19 Sep 2017 by Abhishek Burrnwal

Employee - ID, Name, ManagerID, ManagerName ID Name ManagerID ManagerName 1 Abhi 1 2 Ram 1 3 Sonu 2 4 Monu 3 5 Shyam 2 6 Keshri 4 ...

System.InvalidOperationExcepti...

24 Aug 2015 by Abhishek Kumar Goswami

if i am not wrong, you are not selecting TeamId in your result set.

C#5.0

LINQ

stored-procedure

How to call mysql stored procedure with parameters in c#.net?

1 Jan 2014 by Abhishek Pant

refer this-http://docs.oracle.com/cd/E17952_01/refman-5.6-en/connector-net-tutorials-intro.html[^]

C#4.0

MySQL

stored-procedure

Nested while loop in stored procedures

12 Jul 2016 by abinash panda

Declare @cSex varchar Set @cSex = (Select cSex from StaffMaster where iSMID = @iSMID) While(@iSMID

Problem with the Code Handling User Registration and Send Activation Link

11 Apr 2014 by Abinash_Sahoo

As I can see your USP_CandidateActivation procedure is expecting as datatype of UNIQUEIDENTIFIER, but you are passing a string value for ActivationCode. That could be an issue. You may try this:db1.sqlcmd.Parameters.Add("@ActivationCode", SqlDbType.UniqueIdentifier).Value = Guid.NewGuid();

How to call SQL server stored procedure with parameter in ms access 2010 VBA

6 Aug 2016 by Adam_adam

I have an MS Access application that contains all tables linked to SQL Server, so in MS Access VBA code I work with those tables very simple, I access them via name, like [Customers].Also I have a stored procedure in SQL Server called sp_CopyData which I need to call from my VBA code. I...

To differentiate data between two table with same column

28 May 2015 by Advay Pandya

Hi,The best way to compare 2 tables with same columns is using "except" keyword.Please try below query:SELECT M_C FROM [dbo].[TPATH]exceptSELECT M_RTE_C FROM [dbo].[TTENS]This query will return data which are there in [TPATH] table but not in [TTENS] table.Please let me...

Cannot pass string parameter to stored procedure C#

18 Jul 2016 by Aelion

HelloI searched through this site and found some topic about my problem but still cannot make this work....I am simply trying to retrieve data from SQL Database using a stored procedure.I am passing one parameter that is a SqlDbType.Varchar(50) type, but get back an SQL error:Procedure...

SQL

stored-procedure

Cannot pass string parameter to stored procedure C#

14 Dec 2012 by Aelion

I found problem solution!I should pass whole command parameter like this SqlDataAdapter ad = new SqlDataAdapter(com);not just com.CommandText ... it was stupid.... but I lost so much time...

SQL

stored-procedure

How to pass .NET collection of objects (parent-child) hierarchy to a SQL server stored procedure

24 Dec 2016 by AFell2

So, what you are saying is that you have structured data that consists of parent and child records, and while the parent schema is static, the children have differing schemas.Is your intent to shred the data and span it across multiple tables in the database using a single stored procedure?...

How to pass .NET collection of objects (parent-child) hierarchy to a SQL server stored procedure

24 Dec 2016 by AFell2

There is another option you might want to consider, and that is adding and populating your referential integrity fields (Id, ParentId, etc.) in your POCO (or a new POCO just for the insertion process) and then performing set-based inserts for each object type. You would use the "SelectMany" LINQ...

combine Multiple rows into single row

11 Nov 2013 by agent_kruger

use Concate or Concatinate function in SQL

SQL-Server

stored-procedure

combine Multiple rows into single row

11 Nov 2013 by agent_kruger

http://stackoverflow.com/quest...

SQL-Server

stored-procedure

combine Multiple rows into single row

11 Nov 2013 by agent_kruger

http://msdn.microsoft.com/en-u...

SQL-Server

stored-procedure

Insert Into Multiple Related Tables

13 Mar 2013 by Ahmad Abd-Elghany

PROCEDURE [dbo].[MET_Dynamic_Pages_Insert_Tran] --Pgae Var @P_Name nvarchar(50), --Status Var @Create_Time nvarchar(100), @Update_Time nvarchar(100), --Relation Var @P_Title nvarchar(200), @P_Contenet nvarchar(max), --Relation Var @Cat_Id int, @Is_Active...

conversion faild when converting date time from charachter string error

1 Sep 2014 by ahmed_sa

Hi guy when i run this Stored procedure it give me message error conversion faild when converting date time from charachter stingstored procedure as following Create proc searchData @StartDate datetime, @EndDate datetimeasDeclare @SQLQuery as nvarchar(2000)SET...

SQL

stored-procedure

When executing clr function I get error NET framework error occurred during execution of user-defined routine or aggregate "spexecuteparallel"

5 Nov 2019 by ahmed_sa

Problem I work on sql server 2012 when implement clr function i get error Msg 6522, Level 16, State 1, Line 1 A .NET Framework error occurred during execution of user-defined routine or aggregate "spExecuteParallel": System.NullReferenceException: Object reference not set to an instance of an...

How to execute stored procedure with every row of temp table ?

9 Nov 2019 by ahmed_sa

problem how to execute stored procedure with every row of temp table ? I need to execute storedprocedurename inputfilepath outputfilepath. this is data exist on database on table Importertemplate. i need to get stored procedure name after execute with two parameters inputfilepath and...

SQL

stored-procedure

transaction

How to allow stored procedure to work one time only ?

10 Nov 2019 by ahmed_sa

problem I have stored procedure move data by openrowset based on select statement I need to modify stored procedure to prevent repeated data suppose i have on table company on database SQL server 2012 1 mazda 2 toyotal first time Executed stored procedure it show on excel with data above...

How to know error happen on which line number SQL server 2012?

29 Nov 2019 by ahmed_sa

Question I have big stored procedure on sql server 2012 it compiled success when create it when execute it by give it parameters exec stored procedure parameter it give me error but problem i cannot know this error exist on which line so that i need any thing tell me about error on...

SQL

SQL-Server

stored-procedure

How to write select statment get top highest 10000 on count from table parts.rohs based on revision_id ?

2 Dec 2019 by ahmed_sa

I work on sql server 2012 and i need to get top 10000 revision_id and count parts related that having highest parts from parts.Rohs ? this table have one million rows of parts but parts are repeated . so that i need to count parts related to every revision it then get top 10000 have counts ...

SQL

stored-procedure

transaction

How to write query insert data to generaltypes increased by one based on max number on typeid ?

11 Dec 2019 by ahmed_sa

I work on sql server 2012 I have table name GeneralTypes as follwoing create table GeneralTypes ( TypeId int, TypeName nvarchar(50) ) TypeId is primary key but not identity I have temp table as #tempGeneral create table #tempGeneral ( TypeId int, TypeName nvarchar(50) ) I need to...

SQL-Server

stored-procedure

How to write query get counts of part by two fields onlinedata and offlinedata from general table ?

16 Dec 2019 by ahmed_sa

problem How to write query get counts of part by two fields OnlineData and OfflineData from General Table ? Result Expected OnlineData OfflineData CountParts www.spare.com www.sic.vom 3 www.while.com www.datacomer.com 0 I need to write query get count...

SQL-Server

QueryPlan

stored-procedure

How to write query return status conflict if mask related parts not have same checmicalid ?

5 Mar 2020 by ahmed_sa

create table #temp ( partid int, maskid int, chemicalid int, status nvarchar(50) ) insert into #temp values (100,1000,901) (700,1700,909) (400,1500,920) Parts pk PartId maskId 100 1000 200 1000 400 1500 600 1700 700 1700 Chemical Master Table ...

SQL

stored-procedure

How to write query insert related parts for maskid into chemical master table if not exist ?

9 Jan 2020 by ahmed_sa

How to write query Insert related parts for maskId into chemical master table if not exist on table chemical Master ? create table #temp ( partid int, maskid int, chemicalid int, status nvarchar(50) ) insert into #temp values (100,1000,901) (700,1700,909) (400,1500,920) Parts pk ...

SQL

stored-procedure

How to make group by revision_ID and when repeated display last check date separated by stick | ?

17 Jan 2020 by ahmed_sa

problem How to make group by Revision_ID and when repeated display last check date separated by stick | ? I need to group data by Revision_ID that make count to all zpartid every revision_ID Have group of parts . and when revision id repeated two time then lastcheckdate is firstdate |...

How to display parts not exist on trade code temp and exist on parts temp table by trade code ?

22 Jan 2020 by ahmed_sa

I need to select parts that exist on temp table #parts and not exist on tradecode temp table but by trade code not by partid only suppose i have trade code related to it 2 parts on trade code temp table then i will display all parts not related to tradecode temp table by trade code on my...

SQL

stored-procedure

How to write this statment by using join without using (not in) statment ?

24 Jan 2020 by ahmed_sa

How to write this statement by using join without using (not in) statement ? I work on SQL server 2012 I need to use alternative query statement to (not in) using join and where condition only Are this possible or not ? What I have tried: SELECT PartID, SupplierId FROM #parts WHERE...

SQL

stored-procedure