Skip to main content

எனது பதிவுகள்

Search This Blog

Sql query to validate or check syntax of sql statement in sql server

on July 11, 2012

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

http://msdn.microsoft.com/en-us/library/aa259200(v=sql.80).aspx

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Comments

Post a Comment

Popular Posts

How To Find Sql DeadLock and How to Kill It ?

How to troubleshoot Deadlock in SQL Server 2005 Manoj.B. Create DeadLock Insident : Poorly written queries in SQL Server can trigger deadlock in the system. If not common, at times you may need to troubleshoot deadlock issues. In SQL Server 2005, troubleshooting deadlock is much simpler compared to earlier versions. In this article, detection of deadlock in SQL Server 2005 is explained with simulation of deadlock. We all knows cyclic dependency causes dead lock. When SQL Server find a deadlock, it kill one process (deadlock victim) rolls back the transaction of the deadlock victim, and returns a 1205 error to the application. Database engine choose deadlock victim according to the least cost to rollback. Read more about Deadlock in Books online. Detecting deadlock in SQL Server 2000 was bit complex since you have to switch on the trace flag 1204. Trace flag 1204, returns the type of locks participating in the deadlock and the current command affected. The results are captured

Introduction to REST and .net Web API

Introduction to REST and .net Web API If you are building apps or websites today, the chances are you’ll have heard of REST and .net Web API, but you may not be sure what these things are, whether you should use them or how to get started. If this sounds familiar, then this article for you. API; what and why? Let’s start right at the start and figure out what an API is and why you should consider using one. The term API stands for ‘Application Programming Interface’. In the world of web development the term ‘API’ is synonymous with online web services which client apps can use to retrieve and update data. These online services have had several names/formats over the years such as SOAP, however the current popular choice is to create a REST (or RESTful) API. We’ll come onto REST and why REST is now preferred later, but first let’s examine why you would even bother with an API. Let’s consider a modern application which may include several mobile apps on vari

HIV/AIDS Affected children homes in chennai -Ananda illam /Hope foundation

Anandha illam : 56 Aids Affected kids including 1-2 yrs 3 kids . Address : No.85/1,Ananda Illam,Bandi kavanur , Ponneri taluk,Thiruvallur district . After Redhills and before periyapalayam contact person :chitra:9383733706 This home run by a doctor manorama (Community health education society -CHESS). Please help this childrens . God bless you.................... And whoever gives one of these little ones even a cup of cold water because he is a disciple, truly, I say to you, he will by no means lose his reward.” matthew 10:42 HOPE FOUNDATION IT's located in acharapakkam Chennai. Contact person : prem mob:8939357923 nearly 50 HIV/AIDS Affected orphan childrens are located here. May GOD Bless this childrens.

Powered by Blogger