-
Likes : Having a stored procedure that attempts to do everything, as in the whole CRUD salad. Dislikes : Having to create lots of separate stored procedures if I can the first option is feasible. Thank God for dynamic queries for that. /* * Name : MY_LAZY_SP * Purpose : multiple crud operations for group...
-
I was asked by a friend of mine on how to create a trigger that would trace the changes that a user did to a table. So i checked my bookmarks and give him this link http://www.nigelrivett.net/SQLTriggers/Triggers_2_Creating_Audit_Trails.html Hope to Get some of your opinions or maybe improvements on...
-
In one of the website I have developed, we feature random products displayed on a webpart. This can be done several ways either of the code behind or via t-sql but I think the simplest way to do it is via t-sql with the help of Guid columns. Globally Unique Identifier or GUID is a randomly generated...
-
Here's a tool that im using for some of my projects. What it does is it Automate the Generation of Stored Procedures for Your Database. You just have to execute a querry like this EXEC pr__SYS_MakeUpdateRecordProc 'Order_Details', 1 and it will automatically generate a stored procedure for the table...
-
During my last post try to query the actual size of the logfile, and today i'm going to share a script i found months ago at the microsoft site. I cant find the original link.... Notes: Be sure that you have a backup of your database so that if something goes wrong you have something to get back into...
-
dwarvend, a former teammate in my frist company once asked me about data paging large resulsets in ASP.NET. Data paging in SQL Server 2005 is relatively easy with new RowNumber feature but supporting dynamic sorting is little tricky. I have this executable to script to demonstrate this sorting. --check...
-
I previously posted my views regarding @@IDENTITY variable and SCOPE_IDENTITY() functions in sql server here and luckily with the single stored procedure in our project using NHibernate, i was able to revisit some of its definitions. My teammate whom i asked help from in developing the said stored procedure...
-
i previously have an experience on debugging stored procedures especially those that involve dynamic sql generation and execution. my experience told me that debugging stored procedure of this type is better with visual studio compared to query analyzer. i encountered a problem with query analyzer before...
-
Lately, I was wondering why the Autosize property of label on windows forms is set to true, this is annoying and tiring if you love using windows forms designer(yucks! kidding ), because you often want a properly aligned controls and fixed with labels on data entry textboxes.But not until i want to loicalize...
-
When you are developing software product to be catered to diverse customers, it must be a standard to localized your software. With .NET this has never been easy, on .NET 2.0 its even easier with striongly typed resource files. But localizing application must be part of the architectture and should not...
Posted to
Rodel E. Dagumampan
by
rdagumampan
on
11-07-2006
Filed under:
Filed under: .NET, sql server , ASP.NET, usability and design, Development Process, how to, L10N, localization, scripts, stored procedures, user interface, sql, sequel server
-
[code language="C#"] using System; using System.Collections.Generic; using System.Text; using System.Data; using System.Data.SqlClient; namespace SqlParametersDemo { class Program { static string connectionString = "server=local;database=yourdatabase;userid=youruserid;password=yourpassword;";...
-
Wouldn't it be nice if you have a mechanism to notify users that are connected to your SQL Server? Here's a stored procedure that an help you do that task. CREATE PROC spSendNetworkNotification @Message VARCHAR (200) AS BEGIN SET NOCOUNT ON DECLARE @ShellCommand VARCHAR (350) DECLARE @MessageSource...
-
I have been wanting to put stored procedures in our current project under source control. Although changes to SPs will be minimal, we all know what we can get when we keep history of parts of our code and the ease of comparing them side by side. Searching usenet as usual, it brought me to this KB: How...