I want to get use the substring like this. is it any better way to get the substring seperation of a column. i using SQL 2000
thanks in advance
select @p_data1 = SUBSTRING(dv.data, 1, 8000), @p_data2 = SUBSTRING(dv.data, 8001 ,10000), @p_data3 = SUBSTRING(dv.data, 10001, upto end of the text(16013)),from confirmation l (nolock) join version dv (nolock)
Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…