network profile
| bio | website | saravanandorai.blogspot.com |
|---|---|---|
| location | Chennai, India | |
| age | ||
| visits | member for | 1 year, 10 months |
| seen | Jan 21 at 4:54 | |
| stats | profile views | 7 |
Software Engineer.
Working in C# .Net, ASP.Net MVC.
Have working experience in SaaS
Prior experience in PHP, HTML, CSS, JS.
|
May 9 |
awarded | Notable Question |
|
Dec 17 |
comment |
How to avoid using the IN clause in sql query used in a stored procedure @JonSeigel: We are using this as part of the Bulk User Management process Jon, so we have to use it. |
|
Dec 17 |
comment |
How to avoid using the IN clause in sql query used in a stored procedure @MartinSmith: The userId are uniqueidentifier datatypes. I have userId as primary key in usertable and so with the case of memberid. shall i use the option(recompile) in the stored procedure. |
|
Dec 17 |
comment |
How to avoid using the IN clause in sql query used in a stored procedure @MartinSmith: I am having index on userid and memberid. The table will be a DataTable [From ADO.Net]. I will pass 25000 rows in the table. Kindly suggest a best solution if any |
|
Dec 17 |
asked | How to avoid using the IN clause in sql query used in a stored procedure |
|
Oct 11 |
awarded | Popular Question |
|
Sep 14 |
awarded | Popular Question |
|
Mar 28 |
accepted | Doing a bulk insert in SQL Server |
|
Dec 9 |
accepted | Getting the metadata about a Query and a Stored procedure in SQL Server |
|
Dec 8 |
comment |
Getting the metadata about a Query and a Stored procedure in SQL Server also tell me if there is any way to get the parameters in an sql query. |
|
Dec 8 |
comment |
Getting the metadata about a Query and a Stored procedure in SQL Server When i try to execute this code via C# in .NET, for the query BEGIN TRAN t1;SET FMTONLY ON; Select * from Users; SET FMTONLY OFF;COMMIT TRAN t1;, i am not getting the column metadata. I am just getting no values read through the SqlDataReader |
|
Dec 6 |
awarded | Commentator |
|
Dec 6 |
comment |
Getting the metadata about a Query and a Stored procedure in SQL Server Can I use this in my C# queries also. |
|
Dec 6 |
asked | Getting the metadata about a Query and a Stored procedure in SQL Server |
|
Nov 15 |
comment |
Doing a bulk insert in SQL Server I thought that i can use the BEGIN TRAN t1; Insert... ; before i came to know about the bulk insert. is that not a good choice. |
|
Nov 15 |
comment |
Doing a bulk insert in SQL Server I will check it and comeback to you. In the mean time, can you tell me if using a C# transaction as the outer transaction and a SQL transaction command like BEGIN TRAN t1;INSERT.....; INSERT... ; COMMIT TRAN T1; will work as i had this idea, just for knowing if this is a possibility. |
|
Nov 14 |
comment |
Doing a bulk insert in SQL Server SQL Server 2008 and above is what we use. |
|
Nov 14 |
accepted | query regarding combining an update and an insert query into a single query in mysql |
|
Nov 14 |
asked | Doing a bulk insert in SQL Server |
|
Sep 26 |
accepted | SQL Server Data types and operators clarification needed |
