|
|
you have to alter your collation settings,
the default collation in sql server 2005 is latin1_general_CI_AS
CI = case insensitve
AS = Accent sensitive
you might have to change it in to Case sensitive.
do google on "SQL Server Collation" for more details.
have fun. cheers
|
|
|
|
|
Thank you very much ... 
Regards,
The only programmers that are better than C programmers are those who code in 1's and 0's.....
Programm3r
|
|
|
|
|
Is there anyother alternate way to migrate blob data instead of using import column transformation and export column transformation using SSIS component. if so please tell me.
Thanks in Advance
gvr
|
|
|
|
|
hello
can i change my database collation name after i create it
and fill it with data
how please ???????
|
|
|
|
|
[ i did the same using sql 200, it is a very very tedious process, would recomment you to re install the DB using proper collation and dump in data, and re run sp's , this is much much better approach,
|
|
|
|
|
Hi,
I made a GirdView and fill it with data from database. In this GirdView
I have five columns. First column is Name of item that is represented
in this grid. I want to make items in this column url addresses so when
I click on item name it opens another page to edit the item on which I
clicked.
Can this be done? And if can, how?
Thanks!
Vasini
|
|
|
|
|
add hyperlink column to your page in the design time. you can notice smart tag at the righ top edge of the grid. hyperlink column need a url u can give the url of your required page there.
do let me know if u need further assistance
Regards
Saud
saud
|
|
|
|
|
Hi to all,
Some years ago I have made some experiences with ‘ADO.NET vNext CTP’ predecessor ObjectSpaces. Some while ago I also made my experiences with an O/R mapper (EntityBroker) from THONA Software & Consulting Ltd..
No I will give ‘ADO.NET vNext CTP’ a chance.
How good is Microsoft now?
Is ‘ADO.NET vNext CTP’ better than ObjectSpaces? And when YES which changes Microsoft has done?
Use anyone from you ‘ADO.NET vNext CTP’? Productive? J
Regards,
cyberjoe
|
|
|
|
|
I have an old asp website and trying to run it in Visual Studio 2005. It does not run. It says "This type of page is not served". Is there away to run it to fix an error?
|
|
|
|
|
dptalt wrote: I have an old asp website and trying to run it in Visual Studio 2005. It does not run. It says "This type of page is not served". Is there away to run it to fix an error?
I wouldn't think that is an error. Why would VS2005 handle classic ASP?
|
|
|
|
|
I've been perplexed by this for a while now, and have found no real solution.
I cannot find a way to create a stongly typed DataRow, without first creating a DataTable, which i don't want to do.
Basicaly, i want to wrap my business object around a datarow, so that it can be used with a data table, without exposing the table and adapter to the external code, and using the datarow to enforce the validation initialy.
Can anyone give me any pointers as to how to do this? I've tried a number of ways and been blocked by various caveats.
Cheers
Tris
[Update]
I'm thinking about using a single instance of each type of data table as a row factory, and wrap them in a static class with static members. Can anyone comment on the thread safety of this approach?
|
|
|
|
|
hey there, have you tried
System.Data.DataRow myDataRow;
Riaan Booyzen
|
|
|
|
|
hello,
Can I give a list of values in a valiable and use this variable in select query where clause with in operator
for instance
declare @list nvarchar(1000)
set @list = select words from sample
select * from emp where dept in(@list)
regards,
Uma
|
|
|
|
|
yes you can give...
You can use it something like this:
declare @tt varchar(100)<br />
declare @sql varchar(100)<br />
set @tt = '''0004'','+'''0005'','+'''0006'''<br />
set @sql='select * from mst_employees where emp_no in ('+@tt+')'<br />
exec (@sql)
Best Regards,
Apurva Kaushal
|
|
|
|
|
If I want to use with in a subquery then how to use?
Regards,
Uma
|
|
|
|
|
same way you just need to create the dynamic query..
Best Regards,
Apurva Kaushal
|
|
|
|
|
It means we cannot use a single query.We have to give it in the loops i.e with cursors.Is that right
Thank u.
Regards,
Uma
|
|
|
|
|
No not at all...
What exactly is your requirement?
Best Regards,
Apurva Kaushal
|
|
|
|
|
I have two tables.
one contians a column called keywords which contains individual words.
other contains a column called list which contains a list of words separated by comma.Now i want to write a query to retrieve details from first table by searching the second table.How to do this
Regards,
Uma
|
|
|
|
|
for this no need to go for the dynamic query you can directly use the method suggested by Colin.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Yes we can put a select statement inside the IN expression but if the column contains a list of values separated by comma(,) then it will not work.now the table data is like this.I hope this will make you clear with my requirement.
table1
col1
hyderabad
delhi
mumbai
table2
col1
hyderabad,chennai,bangalore
bangalore,kolkata,delhi
bangalore
mumbai,hyderabad
now if I give select * from table1 where col1 in (select col1 from table2)
i will not get the output
can u check it once
Regards,
Uma
|
|
|
|
|
Uma Kameswari wrote: Yes we can put a select statement inside the IN expression but if the column contains a list of values separated by comma(,) then...
...it breaks the first normal form of database normalisation.
The easiest solution from this point is to go to the dynamic SQL and use cursors to navigate through the rows. However, that is a very slow solution.
If you can, it would be better if you could find some way of normalising the data so that it can be used more efficiently.
|
|
|
|
|
He wanted to use the result of another SELECT statement inside the IN() expression which is a valid thing to do.
|
|
|
|
|
Actually what she has given was some values in a variable thats why I had given that type of solution.
Best Regards,
Apurva Kaushal
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
