|
Give me Please Syntax's for locks with example if possible....
exclusive locks
updated locks and shared locks.. with lock modes
|
|
|
|
|
|
Good afternoon. I have a VB 6.0 app using ADO 2.7 to access SQL Server 2000. I have a nText field that holds Cyrillic text in which the data looks correct when viewing it in Query Analyzer. When retrieving the data via an ADO 2.7 recordset and looping through the records, the data appears as ???? in the recordset object itself. It appears the issue is the fact that ADO is not translating/recognizing the Cyrillic text, but I have read that ADO 2.7 is Unicode compatible. I have seen other posts with similar questions on various boards, but I have yet to come across an answer. If anyone can help with this situation, it would be greatly appreciated.
--Jason
|
|
|
|
|
Hi
I need to implement search facility. How can I do that ? How can I make a search index table ? How google is maintaining their search index ? Will they store all contents from the pages what they crawled ?
|
|
|
|
|
Hi Guys,
I need a hand with the following.
I need to write a stored proc that accepts a parameter that contain multiple values.
i.e
alter proc spGetLastNames
@Firstnames varchar(200)
as
Select lastname from user where firstname in(@Names)
@Firstnames should be able to accept a comma delimited string i.e 'Frank', 'Peter', 'William'
I am pondering whether to use XML to pass the Parameters, do you think this would be viable?
|
|
|
|
|
|
thanks ! just what I needed
|
|
|
|
|
Hi,
Hi I have 3 tables, one is master table( EMP) and other two are child tables (Emp_Dep and Emp_Jone).
Example:
EMP
EmpId Name
1 ABC
2 XYZ
Emp_Dep
EmpId DepId
1 2
Emp_Jone
EmpId JoneId
1 4
I have created these 3 tables and defined Relation objects between these three tables.
My problem is the order of updating in my application,
Case1:
If I update the tables in Emp_jone, Emp_Dep and Emp order, I am getting “constrain failed” exception, when I have add a new employee and linked with a Department and Jone. This would be resolved if I update in Emp, Emp_Jone and Emp_Dep order
Case2:
If I deleted an existing employee, who has been liked with some Department and jone, and I update in Emp, Emp_Jone and Emp_Dep, I will get same constrain failed exception, to resolve this I will have to update as specified in Case1 order.
Could you please give me some suggestion to resolve this without any intermediate updates?
Regards,
Satish
Satish
|
|
|
|
|
Hi
i have following fields in a Table i want to group on month and week plz help me to build query.
Userid,Value,Date,RefNo,Type
now i have month function but i want to group on week. so what will be the query?
Regards,
Shahzad Aslam
Software Engineer
|
|
|
|
|
Hi
Query will be
Select datename(ww, getdate()) - which will give you week number of the given date.
Harini
|
|
|
|
|
Try this out with ur values in place of ''08-03-2006'
------------------------------------------------------
select *,datename(mm,('08-03-2006')) as mnthName, datename(dw,('08-03-2006')) as wkName
group by mnthName, wkName
!!Hope so it should work
Bala, HeroITES, Gurgaon(India)
|
|
|
|
|
Thanx! its working.
Shahzad Aslam
Software Engineer
|
|
|
|
|
Hey Guys I know this question has probably been asked a thousand times on this forumm, but I had a look and been searching on the net for an answer, and no one answer suits my situation.
I have a Stored proc that handles paging on the server side
everything works fine, until I get to the dynamic sorting.
[code]SET NOCOUNT ON;
Declare @StartIndex int;
Set @PropCount=(SELECT COUNT(property_id ) FROM [dbo].[vwResidentialProperty]
WHERE (@Area is null or parentid = @Area)
and (@locality is null or CharIndex( [dbo].[vwResidentialProperty].locid, @Locality)>0)
and askprice between isnull(@MinPrice,0) and isnull(@MaxPrice ,5000000)
and bedrooms between isnull(@MinBed,0) and isnull(@MaxBed ,10)
and (@PropType is null or charindex( [dbo].[vwResidentialProperty].propertytype,@proptype)>0)
and floorarea between isnull(@MinFloor,0) and isnull(@MaxFloor,5000000));
/*Check to see if the Number of Properties returned is less than actual page size if it is then set the start Index
to the Property Count */
if @PropCount < @Numrow
begin
set @StartIndex = 1;
end;
else
begin
set @StartIndex = (@PageIndex * @Numrow) + 1;
end;
with Property As
(
SELECT top 100 percent
case @SortOrder
when 0 then ROW_NUMBER() OVER (order by [dbo].[vwResidentialProperty].askprice Asc)
when 1 then ROW_NUMBER() OVER (order by [dbo].[vwResidentialProperty].askprice desc)
when 2 then ROW_NUMBER() OVER (order by [dbo].[vwResidentialProperty].dateadded desc)
end as row,
[dbo].[vwResidentialProperty].property_id , [dbo].[vwResidentialProperty].Address, [dbo].[vwResidentialProperty].askprice
, [dbo].[vwResidentialProperty].dateadded, [dbo].[vwResidentialProperty].Saleterm ,[dbo].[vwResidentialProperty].locid,
[dbo].[property].adbrief
FROM [dbo].[vwResidentialProperty]
inner join [dbo].[property] on [dbo].[property].property_id = [dbo].[vwResidentialProperty].property_id
WHERE (@Area is null or parentid = @Area)
and (@locality is null or CharIndex( [dbo].[vwResidentialProperty].locid, @Locality)>0)
and [dbo].[vwResidentialProperty].askprice between isnull(@MinPrice,0) and isnull(@MaxPrice ,5000000)
and [dbo].[vwResidentialProperty].bedrooms between isnull(@MinBed,0) and isnull(@MaxBed ,10)
and (@PropType is null or charindex( [dbo].[vwResidentialProperty].propertytype,@proptype)>0)
and [dbo].[vwResidentialProperty].floorarea between isnull(@MinFloor,0) and isnull(@MaxFloor,5000000)
)
Select Property_ID, Address as 'Address', askprice as 'Price', adbrief as 'Description', Saleterm, dateadded
FROM Property
WHERE Row BETWEEN
@Startindex and (@startindex + @Numrow )-1
order by case @SortOrder
when 0 then askprice
when 1 then askprice -1
--when 2 then dateadded -1
end;[/code]
I need to be able to provide 3 different sorting options to the user.
1 . Price Asc
2. Price Desc
3. Date added Asc
Now I can't find away of providing this criteria.
At the moment the options are available to the user on screen via option buttons. I don't really want supply SQL code in the HTML of the page i.e
I would prefer to pass an integer value through to the stored proc, and let the case clause handle it.
I have tried puttin Price Asc in the case clause, but SQL complains.
is there any other way of doing this?
|
|
|
|
|
Hi
The following example shows how to sort using case .. when clause:
Use Northwind
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Spe_Invoices_Sort]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Spe_Invoices_Sort]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].Spe_Invoices_Sort
@SortColumn nvarchar(25),
@SortDirn nvarchar(25)
AS
BEGIN
SELECT * FROM Invoices
ORDER BY
CASE WHEN @SortColumn = 'ShipCity' AND @SortDirn = 'DESC' THEN ShipCity END DESC,
CASE WHEN @SortColumn = 'ShipCity' AND @SortDirn = 'ASC' THEN ShipCity END ASC
end
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
Excute this SP in Northwind database. Try this
exec Spe_Invoices_Sort 'ShipCity','asc
Replace ASC or DESC as 1 or 2 as your wish
Hope this helps your problem
Harini
|
|
|
|
|
hello to all,
i have developed a application using vb.net and sql server 2000. Everything is fine but now i have to install it on client's machine.
should i install sql server in that machine?
In other words " Is it necessary to install sql server on client machine , if application use sql server as back end." if not please tell me solution.
with regards ,
sachin jangir
|
|
|
|
|
dotnethunk wrote: should i install sql server in that machine?
If your application is using the same system as database server you have to. If not you can specify remote server address where SQL server resides.
|
|
|
|
|
Thanx for reply ,
But i want that my client have to click on Setup Icon & software is ready to run like when we use Access as database.Is there any way to get such functionality .If Yes please tell me .
With regards ,
Sachin jangir
|
|
|
|
|
dotnethunk wrote: But i want that my client have to click on Setup Icon & software is ready to run like when we use Access as database.Is there any way to get such functionality
Yes You can.... Download install creator. Using this you can create packages. Package your application along with sql server setup. In install maker you can configure the setup to wait untill the installation of SQL server finishes before starting installing your program. After that Use SQL scripts to create database and tables.
|
|
|
|
|
Sir,
Can we update or insert into a table by updating or inserting a view on that table. If we can, then how and if we cant then whats the remedy for that and reason for that. Thank you.
Regards,
S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.
|
|
|
|
|
yes we can update table thru views if the view is not readonly
Regards,
Sylvester G
sylvester_g_m@yahoo.com
|
|
|
|
|
YES. (in continuation to sylvesterg)
It is possible, if view contains all not null / foreign key columns of base table.
View is like a filter/window by which data in a tbale is viewed.
Regards
KP
|
|
|
|
|
S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.
|
|
|
|
|
Hi
I need to implement search facility. How can I do that ? How can I make a search index table ? How google is maintaining their search index ? Will they store all contents from the pages what they crawled ?
|
|
|
|
|
Hi
You can use a SELECT statement that it contions a CONTIONS keyword simply
|
|
|
|
|
give me the what is locks....
where we r using....
whick purpose....
give me detailed please....
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
