|
Hi
can anybody give solution for my req
i had a mastertable and i need to copy generated recordsd to my child table my code follows in this way:
CREATE TRIGGER trigInsertion on GlobalScan
AFTER insert as
INSERT into GlobalScanNew
SELECT * FROM inserted
end
but here in my mastertable coloums data type is different from child table
now i need to convert this and place it in my new table
plz can anybody give solution for this
Regards
padma
padma
|
|
|
|
|
hi
you can use convert() function for converting data type and insert it in to the child Table.
eg: INSERT INTO CHILD
SELECT CONVERT(VARCHAR,FIELD1) FROM INSERTED
Regards
Joe
|
|
|
|
|
thanks for reply
but in my master table i had 10 coloums and in that i need to check three coloums so how can i do it
padma
padma
|
|
|
|
|
hi
if you needs only 3 columns specify that columns in your select qry
eg: INSERT INTO CHILDTABLE
SELECT CONVERT(FIELD1),CONVERT(FIELD2),FIELD3
FROM INSERTED
Regards
Joe
|
|
|
|
|
|
I can do a select within a dataset to search for a string. This works great.
When I try to do the select to search for a number I get a 'does not evaluate to a Boolean term'.
For example- matchingRows() = ds.Tables("Generations").Select("id = 3")
I get a simular error when I try to create a dataview that keys off of a number.
How do you search a dataset for a numeric value?
Thanks in advance!
kermit88
|
|
|
|
|
Hi Dear
I am getting a error called "rsReportParameterProcessingError" from a report i deployed in sql sever reporting services (Sharepoint 3.0) in a sever A. the parameter which cause this error is 'EndDate' which set to returin the value of one day before report generation day, code as: =CDate(Format(Dateadd("d",-1,now()),"dd/MM/yyyy"))
The report is running fine and returning no error in either Visual Studio or other severs.
Could you please advise what setting in the sever might cause this error and how do i change the configration in Sever A to fix that?
Thank you very much,
Candy
|
|
|
|
|
Have you checked the report server logs? You should be able to get more descriptive error details from there.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
I have a SQL server that is setup for a few very small use applications. It is a very nice server and can handle a high workload, but is not getting even 1% of what it could handle. I just made a website with a simple login form that checks username and password when you click a login button.
The problem is sometimes, and I can't tell why, I'll get a 'can't connect to SQL database' error. But if I try again it works. Again, sometimes I don't even have the problem... This server is available still for the other applications so I don't know why this is happening.
Any suggestions? Anyone seen this before?
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
Post complete error message, also try to look in performance monitor to check number of concurrent connections and connection pool.
|
|
|
|
|
I will as soon as the error comes up again.
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
|
Some time ago, a plugin for Sql Server Management Studio was available here @ codeproject.
It was called "Enisey Data Scripter"
It has disappeared !
This http://www.codeproject.com/useritems/enisey.asp links to a "Page not found"
I have it installed on my machine but lost the installer.
Does anyone have this installer or the source ?
|
|
|
|
|
|
Please give me working link for that plug-in
|
|
|
|
|
hi, i am using sql 2000 and i want to insert farsi into my table using a form which i wrote with c# but the problem is that they would inserted into it but when i want to show them they apeare as '???'
where is my problem please?
|
|
|
|
|
hi
can u give some sample code for this....
Regards
Joe
|
|
|
|
|
thanks for answering me
actually I found out how to do that in msdn
the command which enables you to insert farsi(or any right to left languages) is:
INSERT INTO tablename(columnnames) VALUES(N'' ,)
like :
INSERT INTO Employees(FirstName, LastName) VALUES(N'شاهين',N'معصومي')
and the data type must be nvarchar
thanx
|
|
|
|
|
If you want to insert unicode text into text fields you need to make sure your fields are nvarchar, instead of varchar.
|
|
|
|
|
hi there,
i set identity specification to an column of my table with increament of 1
but i have a little problem
for example i have 4 rows in that table like this
1, ...., ......
2, ...., ......
3, ...., ......
4, ...., ......
and if delete 2 and 3 then when i reopen table it shows
1, ...., ......
4, ...., ......
and it must show like this
but i want to rearrange it, so is there any "sp" or any function in sql that
can do it? so that i can look like
1, ...., ......
2, ...., ......
thanks
Becoming Programmer...
|
|
|
|
|
xmen_xwk wrote: but i want to rearrange it, so is there any "sp" or any function in sql that
can do it?
For what purpose do you want to rearrange it. This is an expensive operation and if you want to hurt the performance of your SQL Server everytime you delete a row then go right ahead and renumber everything causing the relevant indexes to update, all foreign keys will need to be updated also (but you have to manage that) and so on. I would bet that it would take a lot of effort to do that correctly and the potential for getting it wrong somewhere is great.
So, unless you have an exceptionally good reason for renumbering your primary key* like that I'd suggest that you just ignore the "holes" in the number sequencing.
Well, I say primary key, although you didn't. I'm just assuming it is the primary key because identity columns are normally used as the primary key.
Upcoming FREE developer events:
* Developer! Developer! Developer! 6
* Developer Day Scotland
My website
|
|
|
|
|
Well, if you really can't sleep at night because of holes in your identity sequence, then you can manually assign IDs to new records (although this might require turning off your sequencer, or removing the "IDENTITY" attribute, then re-initializing it afterward) and use-up those holes.
Some months back, someone much smarter than I (Michael Potter[^]) suggested something similar to the following to find holes within a sequence.
SELECT TOP 1 Missing.ID
FROM (SELECT (ID - 1) AS ID
FROM tblMyTable
WHERE ID > @startnum
ORDER BY ID) AS Missing
LEFT JOIN (SELECT ID
FROM tblMyTable
ORDER BY ID) AS Includes
ON Missing.ID = Includes.ID
WHERE Includes.ID IS NULL;
You could just turn off your sequence entirely, and use the return from the above when it is not null, then when it does return null, use the following.
SELECT MAX(ID)+1 FROM myTable;
However, there are issues with not using the DB provided sequencer. For example, you'll have to make sure concurrency works correctly. This may involve locking tables, etc.
David
---------
Empirical studies indicate that 20% of the people drink 80% of the beer. With C++ developers, the rule is that 80% of the developers understand at most 20% of the language. It is not the same 20% for different people, so don't count on them to understand each other's code.
http://yosefk.com/c++fqa/picture.html#fqa-6.6
---------
|
|
|
|
|
i think i wont need sequencer because i got a trick from your last sql query
thanks man it may solve my problem
Becoming Programmer...
|
|
|
|
|
If this is a real project (and not a homework assignment), then I strongly suggest you re-read what Colin wrote. He is absolutely correct. Performance aside, a real problem with renumbering keys is making sure you GET IT ALL CORRECT (all the other tables that reference this key must also change). My previous post really dealt with adding new records to a table with holes in the identity field; not with RE-NUMBERING existing records.
EXERCISE CAUTION, and unless really necessary, follow Colin's advice and just live with the holes.
Good luck.
David
---------
Empirical studies indicate that 20% of the people drink 80% of the beer. With C++ developers, the rule is that 80% of the developers understand at most 20% of the language. It is not the same 20% for different people, so don't count on them to understand each other's code.
http://yosefk.com/c++fqa/picture.html#fqa-6.6
---------
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
