¡@
c# Programming Glossary: execDisplay progress bar while doing some work in C#? http://stackoverflow.com/questions/1952201/display-progress-bar-while-doing-some-work-in-c I just needed a better solution than Action String String exec DoSomethingLongAndNotReturnAnyNotification IAsyncResult result.. IAsyncResult result exec.BeginInvoke path parameters null null while result.IsCompleted.. null null while result.IsCompleted Application.DoEvents exec.EndInvoke result that keeps the progress bar alive means not..
Execute multiple SQL commands in one round trip http://stackoverflow.com/questions/2336362/execute-multiple-sql-commands-in-one-round-trip simple sql commands like select from Users and I want to execute three of them. However to populate this one page I have to.. write a single stored proc getUsersTeamsAndPermissions or execute a single SQL command select from Users exec getTeams select.. or execute a single SQL command select from Users exec getTeams select from Permissions . But I was wondering if there..
Algorithm to avoid SQL injection on MSSQL Server from C# code? http://stackoverflow.com/questions/249567/algorithm-to-avoid-sql-injection-on-mssql-server-from-c-sharp-code Avoid dynamic sql both in db client code and in sql. Avoid exec statements with dynamic code with external sections in your.. that no stray code is sitting around in a world readable executable web directory. If it's not part of the active site archive.. Stay up to date on the database APIs. Some ways of executing SQL statements in some APIs are not as secure as others...
How to spawn a process and capture its STDOUT in .NET? http://stackoverflow.com/questions/285760/how-to-spawn-a-process-and-capture-its-stdout-in-net false startInfo.Arguments command startInfo.FileName exec p.StartInfo startInfo p.Start p.OutputDataReceived new DataReceivedEventHandler..
What's a good alternative to firing a stored procedure 368 times to update the database? http://stackoverflow.com/questions/3282254/whats-a-good-alternative-to-firing-a-stored-procedure-368-times-to-update-the-d built 5 years ago and all calls to the db currently get executed via modular static functions with names like ExecQuery and.. This code should get code the last time this query is executed but only then. exec spUpdateOrdersHeaderForSkuGroupSourceCode.. code the last time this query is executed but only then. exec spUpdateOrdersHeaderForSkuGroupSourceCode @OrdersID 7 0 @PromoCode..
Stored procedure: pass XML as an argument and INSERT (key/value pairs) http://stackoverflow.com/questions/3557882/stored-procedure-pass-xml-as-an-argument-and-insert-key-value-pairs Rows ' Call the stored procedure with the XML Parameter exec ParseXML @InputXML @XMLParam Clean up Drop the procedure drop..
Using DateTime in a SqlParameter for Stored Procedure, format error http://stackoverflow.com/questions/425870/using-datetime-in-a-sqlparameter-for-stored-procedure-format-error run SQL Profiler to watch the calls I then copy paste the exec call to see what's going on. These are my observations and notes.. '2009 01 08T08 22 45' EDIT RE BFree the code to actually execute the sproc is as follows using SqlCommand sprocCommand new.. param.Value DOB Results in this value in the exec call as seen in the SQL Profiler @Date_Of_Birth ''2009 01 08..
ADO.Net : Get table definition from SQL server tables http://stackoverflow.com/questions/457485/ado-net-get-table-definition-from-sql-server-tables command.Connection connection command.CommandText exec sp_tables command.CommandType CommandType.Text SqlDataReader.. TABLE_NAME .ToString reader.Close command.CommandText exec sp_columns @table_name ' tablesList 0 ' command.CommandType..
How can I determine the parameters required by an arbitrary piece of T-SQL? http://stackoverflow.com/questions/5792507/how-can-i-determine-the-parameters-required-by-an-arbitrary-piece-of-t-sql is able to do this very successfully. Edit 2 SQL BIDS is executing this command in order to describe the results exec sp_executesql.. is executing this command in order to describe the results exec sp_executesql N'SET FMTONLY OFF SET FMTONLY ON SELECT @Foo Foo.. this command in order to describe the results exec sp_executesql N'SET FMTONLY OFF SET FMTONLY ON SELECT @Foo Foo ''@Bar''..
Entity Framework can't handle a simple table variable? http://stackoverflow.com/questions/5997033/entity-framework-cant-handle-a-simple-table-variable decimal 15 5 8 decimal 15 5 9 decimal 15 5 insert into @t exec dbo.CrossTabWithoutSumWithOrderBy #pivot 'Name' null 'Grade'.. stored procedure it calls SET FMTONLY ON and after that executes the stored procedure. When FMTONLY is ON execution returns.. that executes the stored procedure. When FMTONLY is ON execution returns only metadata and it doesn't work with some advanced..
What does the bitwise or | operator do? http://stackoverflow.com/questions/612072/what-does-the-bitwise-or-operator-do The write bit bit 1 is set Execute 4 00000100 The exec bit bit 2 is set ... ReadWrite Read Write 00000011 Both read.. make sense ReadExecute Read Execute 00000101 Both read and exec bits 0 and 2 are set Note that the non combined values are powers..
http://stackoverflow.com/questions/658818/linqtosql-strange-behaviour I put tagToPosts.ToList in the Watch window for query to execute. In SQL profiler I can see the following query exec sp_executesql.. to execute. In SQL profiler I can see the following query exec sp_executesql N'SELECT t0 . Id t1 . Name FROM dbo . tblTagToPost.. In SQL profiler I can see the following query exec sp_executesql N'SELECT t0 . Id t1 . Name FROM dbo . tblTagToPost AS..
C# SQL Server - Passing a list to a stored procedure http://stackoverflow.com/questions/7097079/c-sharp-sql-server-passing-a-list-to-a-stored-procedure connstring con.Open using SqlCommand cmd new SqlCommand exec sp_UseStringList @list con var table new DataTable table.Columns.Add..
http://stackoverflow.com/questions/8602395/timeout-expired-the-timeout-period-elapsed-prior-to-completion-of-the-operation Description An unhandled exception occurred during the execution of the current web request. Please review the stack trace.. Error An unhandled exception was generated during the execution of the current web request. Information regarding the origin.. process and select details it'll show you the last query executed by the process. The second issue will cause the database..
Get value output from SQL Server stored procedure into variable http://stackoverflow.com/questions/8618978/get-value-output-from-sql-server-stored-procedure-into-variable your existing procedure retuns you need insert ... exec declare @t table id int insert into @t exec dbo . AllocateId.. insert ... exec declare @t table id int insert into @t exec dbo . AllocateId If you want to return a value as a return value..
How to execute a stored procedure within C# program http://stackoverflow.com/questions/1260952/how-to-execute-a-stored-procedure-within-c-sharp-program 0 WHILE @i 5 BEGIN Print 'I VALUE ' CONVERT varchar 20 @i EXEC @command SET @i @i 1 END EDITED using System using System.Collections.Generic..
When is it better to write “ad hoc sql” vs stored procedures [duplicate] http://stackoverflow.com/questions/2734007/when-is-it-better-to-write-ad-hoc-sql-vs-stored-procedures much can't do this with stored procedures without the EXEC hack which is not to be spoken of in polite society so the point..
http://stackoverflow.com/questions/508213/is-there-a-way-to-dynamically-execute-a-string-in-net-similar-to-eval-in-jav they come from Execute the manipulation dynamically EXEC sp_ExecuteSQL @stmt @manipulation @params N'@s nvarchar 1000..
Entity Framework Stored Procedure Table Value Parameter http://stackoverflow.com/questions/8157345/entity-framework-stored-procedure-table-value-parameter StringBuilder command new StringBuilder command.Append EXEC command.Append procedureName command.Append Add a placeholder.. parameters The command string ends up like this EXEC someStoredProcedureName 0 1 2 3 4 5 6 7 I tried to run this.. storeProcName params object parameters string command EXEC storeProcName @caseid @userid @warnings context.ExecuteStoreCommand..
Get value output from SQL Server stored procedure into variable http://stackoverflow.com/questions/8618978/get-value-output-from-sql-server-stored-procedure-into-variable from SQL script it doesn't seem to work declare @Id int EXEC @Id dbo . AllocateId @Id is always 0. How do I get the value..
|