210 reputation
510
bio website saravanandorai.blogspot.com/…
location Chennai, India
age
visits member for 3 years, 5 months
seen Nov 6 at 18:34

Software Engineer.

Working in C# .Net, ASP.Net MVC, Kendo UI, jQuery etc...

Have working experience in SaaS

Prior experience in PHP, HTML, CSS, JS.

Linkedin Profile: http://in.linkedin.com/in/sarandorai/

Twitter: @sdoraiswamy


Sep
24
awarded  Autobiographer
Jul
10
awarded  Yearling
Jun
13
awarded  Notable Question
Feb
18
awarded  Popular Question
Dec
23
awarded  Notable Question
Oct
10
awarded  Popular Question
May
21
awarded  Caucus
May
21
awarded  Constituent
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