|
Warnat wrote: maybe your query does not return the primary-key-columns
So I have to write an update-query on my own??
_____________________________
...and justice for all
APe
|
|
|
|
|
Hi,
When I'm trying to copy the contents of a dataset to another dataset,I'm getting an exception "Cannot Find Table 0".But When I debug I could retrieve values for the dataset.
Please help me in resolving this issue.
Thank you,
Regards,
Deepa.
|
|
|
|
|
how do you copy ?
my solutions allways follow this scriplet:
please make sure, you copy the values into a row
which you retrieved from the Table you are copying into
DataRow new_row = desttab.NewRow();
now begin filling the values into new_row[xx]
in the end append this row to the dest_table:
desttab.Rows.Add(new_row);
hope this helps
Ralf
|
|
|
|
|
hi i need to write query to find the databases presented in the database objects
|
|
|
|
|
Rmesh wrote: i need to write query to find the databases presented in the database objects
 I have no idea what that means.
|
|
|
|
|
i have foind out the databases present in the database for ex, if we have databases like crm,sqm,love etc then i have to write the query to list out these databases
|
|
|
|
|
Rmesh wrote: i have foind out the databases present in the database
Do you mean the databases present on the server?
Rmesh wrote: i have to write the query to list out these databases
If you have SQL Server 2000 (and you haven't specified which technology you are using - please state this, it is important) the query would be something like:
SELECT * FROM master..sysdatabases
|
|
|
|
|
thank u its working now how to write query to list tables under the database
|
|
|
|
|
check out the INFORMATION_SCHEMA views. they will give you all this data. in particular for tables in views:
select * from INFORAMATION_SCHEMA.TABLES
if you want a comprehensive data dictionary of your database, check out the link in my sig below.
|
|
|
|
|
iam having an emp table
and i want to display recs randomly each time i retrieve
with regards
ravi kiran
|
|
|
|
|
|
Are you talking about a System.Data.DataTable that's already populated and you want to pull a random record from it? Or are you talking about writing a select statement that randomly selects a row?
If it's a datatable you could use Random.Next(DataTable.Rows.Count) to get a random integer with a maximum value set to the row count.
If it's a sql query you want to write you could get a random number based on the RAND() function and the COUNT() function then write something like:
DECLARE @Id INT, @Count INT, @Rnd INT
SELECT @Count = COUNT(*) FROM table
SET @Rnd = CAST((@Count*rand())+1 AS INT)
SELECT TOP (@Count) @Id = Id FROM table ORDER BY CartNumber
SELECT * FROM table WHERE Id = @Id
If you're not using SQL 2005 you'll have to build the SELECT TOP query as a string and call EXECUTE instead.
|
|
|
|
|
Oops, a small mistake. Change this:
SELECT TOP (@Count) @Id = Id FROM table ORDER BY CartNumber
to this:
SELECT TOP (@Rnd) @Id = Id FROM table
|
|
|
|
|
on mssql:
select top 100 * from yourtable order by newid()
|
|
|
|
|
i have around 20 fields in my database.i want to print them through crystal report.but all the 20 fields cann't accomodate in one page of a crystal report.are there any other methods except sub report concepts so that i can print all my records in a single page..?(i may use A12 sheet in dot matrix printer as usually used in offices)
thanks in advance
i m pradip kishore
|
|
|
|
|
you can have multiple detail sections in your report. one more workaround is to change the report to landscape.
hope that works.
Regards
Saud
saud
|
|
|
|
|
hi saud
thanks for your reply.but i am still not able to accomodate all the fields in one page of crystal report..can you give me any tutorials link or any further help in this regard..?
thanks again..
pradip kishore
|
|
|
|
|
Hi pardeep ,
Multi detail section is your only solution. have u tried that. if u need assitance of how to add multiple detail section let me know.
saud
|
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
