Stories recently tagged with 'Insert'

Client Side Validating Bulk Insert With jQuery Validation Plugin(beckelman.net)

submitted by beckelmwbeckelmw(2755) 3 years, 8 months ago

I have been working on a proof of concept for a way to insert a bunch of contact data for a record. One of the requirements that has been pretty challenging is the client side validation since a lot of info isn't known until run time. read more...

add a comment |category: |Views: 47

tags: another

SQL Server 2008: Locking with MERGE statement compared to Update/Inser(weblogs.sqlteam.com)

submitted by spirit1spirit1(3160) 4 years, 9 months ago

How SQL Server 2008 MERGE statement locking compares to the locks held when doing "update if exists, insert if not" problem in SQL Server 2005. read more...

add a comment |category: |Views: 34

tags: another

SQL Server: Best way to Update row if exists, Insert if not (weblogs.sqlteam.com)

submitted by spirit1spirit1(3160) 4 years, 9 months ago

This question pops up a lot everywhere and it's a common business requirement and until SQL Server 2008 doesn't come out with it's MERGE statement that will do that in one go we're stuck with 2 ways of achieving this. The biggest problem with every update/insert (upsert for those who haven't heard the term yet) is locking. read more...

add a comment |category: |Views: 119

tags: another