|
I got it working now. Thanks! I just created a new database however I have a new problem. Yesterday I was able to successfully migrate my data to another database, using this query: "INSERT INTO Records SELECT * FROM MMDAserver.dbo.Records", then being stupid, I accidentally deleted the newly created database from the project file I attached into. Now when I created the new database again with the same name and same everything, I already get this error when I try to copy them again:
Msg 8101, Level 16, State 1, Line 1<br />
An explicit value for the identity column in table 'Records' can only be specified when a column list is used and IDENTITY_INSERT is ON.
|
|
|
|
|
This means that you hav an IDENTITY column in records table. Normally you cannot give value to an identity column because SQL Server assigns it. When migrating old data you can set this feature temporarily off. Have a look at: SET IDENTITY_INSERT (Transact-SQL)[^]
However if you don't want that SQL Server assigns the value at all, you should remove the identity definition from that table.
|
|
|
|
|
Yeah I just noticed. LOL. I removed the Identity Specification for the newly created tables. THANKS A BUNCH! You guys were a great help! 
|
|
|
|
|
You're welcome
|
|
|
|
|
hi everybody,
My sql databse gets suspected and i am not able to use that database or delete that database.How can i use that database.
|
|
|
|
|
|
Hi All,
I m using Reporting services 2005... I ve to use TWO Databases
(Same Server) in a single Query.... In that,ve to pass Database name as PARAMETERS...
How to pass DB name as a parameter using reporting services 2005...
Pls any one suggest some Solution...
Thanks in advance...
|
|
|
|
|
Would it be possible to create a view in one of the databases that links to the second DB and contains the information you need? This might be easier...
|
|
|
|
|
Thanks for ur solution... It Works...
|
|
|
|
|
Friends,
Is there any sql query which returns the data type of the fields in a table.
please help me
Shivanandan C V
|
|
|
|
|
select name,column_id,system_type_id,type_name(system_type_id) system_type_name,max_length from sys.columns where object_id=object_id('"Schema".tableName')
|
|
|
|
|
Hi,
I have a column in table 'str_Name'of type string.
It contains the data as shown below.
Vishnu
Rajesh
12Sharma
02Santhosh
34657Chandu
Anita
Swapna
987fhug
Deepika
Divya
Janaki
My requirement is to get names which starats with numerics
Please suggest me how to achieve this in 'SQL Server 2005'.
Thanks in Advance
|
|
|
|
|
sekhar.k wrote: get names which starats with numerics
One easy way is to use like operator:
... str_Name LIKE '0%'
OR str_Name LIKE '1%'
...
|
|
|
|
|
Hi Mika Wendelius,
Thanks for your valueble suggestion.
|
|
|
|
|
|
you could also use something like
Where str_Name like '[0-9]%'
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
ThanQ for your suggestion.
|
|
|
|
|
try this
select str_name from mytable where isnumeric(left(str_name,1)) = 1
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Thanks for your suggestion
|
|
|
|
|
In LINQ:
'Create a char array using digits
dim digits as char() = "0123456789"
dim query = from x in myTable _
where digits.Contains(x.str_Name.Substring(0,1)) _
select x
|
|
|
|
|
I trying to upgrade sybase version 6 and keep getting database created by an different version using version 11
any help.
Learning to Code
|
|
|
|
|
Assuming Sybase have filled versions between 6-11 you are trying to jump 5 versions, and you wonder why it does not work.
Have you confirmed with Sybase that the 6-11 upgrade is possible?
I suggest you try transferring the database. Scripting out the structures and then transfer the data, probably won't work the first couple of times so make sure you have backups and script each step so it can be repeated and repeated and....
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I recently have had the task of converting SQL statements that select directly from the database to DataTable.Select statements that select from a cache of records in memory.
The SQL statements use a single table and are along the lines of:
SELECT node.Name, parentNode.Name, rootNode.Name
FROM (nodes node INNER JOIN nodes parentNode ON node.ParentID = parentNode.ID)
INNER JOIN nodes rootNode ON node.RootID = rootNode.ID
WHERE node.format = 5;
Assuming I have a cache of the "nodes" table in memory (as a large DataTable), I can simulate this SQL statement with nested for / foreach loops, intermediate DataTables, and simple DataTable.Select statements.
However, I was wondering if there's a slicker way of using the DataTable.Select that eliminates the need of doing so much looping and creating intermediate tables for the results.
|
|
|
|
|
The Select method in DataTable is quite restricted. You cannot for example join tables, create hierarchical queries etc.
I didn't quite understand why you have to loop or create intermediate results since you didn't include your actual data table usage. I'm guessing that it's because of those restrictions I mentioned.
If that's the case, I'd suggest that when building the cached datatable, use the database server ability to execute complex queries and in the datatable store the information in simpler form. Since this is mostly for reading the data from the cache, denormalization is one way to make the data more easy to use.
|
|
|
|
|
Hello all,
I have a report that deals with a large set of inventory data. Inventory items are stored in bins at various locations. At each location, different team members may be responsible for keeping track of inventory in the various bins. Team members may have more than one bin. We don't store which team members are responsible for a bin - that's pretty much determined by who is around when inventory needs to be taken. We are building a report that is basically a worksheet for listing what is in each bin.
We have a user interface that allows us to determine which bins should have page breaks after them (the bins are listed in order of location and then alphabetically ordered). What we need is a way to group the result set coming back from our stored procedure so that each set of bins between page breaks is grouped. If that makes sense...?
I've been googling trying to find an answer to this question, but I think part of my problem is in how to express the question in such a way as to get an answer. Please advise.
Thanks,
Will
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
