|
We've had a view working fine in SQL 2000 which has one field (used for sorting) which is defined by calling a function that returns a text string. In SQL 2000 you can either run the query in Design View or select Open View and it works the same in both cases. In SQL 2005 if you run the query in Design view it works fine and the data is sorted correctly, but if you just do Open View to see the data then the data isn't sorted.
Any thoughts? TIA.
|
|
|
|
|
iam using sql script wizard to script the table scripts of my table ...iam succeeded in this case and my getting all the table creation scripts in one .sql file but how can i get each individual script ie
one creation script one .sql file like that is it possible
|
|
|
|
|
There is an option in the wizard for "1 file" or "1 object per file"
|
|
|
|
|
hi mr
i tried but i didnot find will u plz guide where it is
|
|
|
|
|
Im using SQL 2005 - if you have another version you're on your own.
Right Click database > Tasks > Generate Scripts
Follow wizard until the page titled "Output Options"
Script Mode > Script to File > Files to generate > File per object
|
|
|
|
|
hi i tried the same what u said but iam unable to get the option of
Script Mode > Script to File > Files to generate > File per object
in my sql server version tat is the last one file per object iam unable to get
|
|
|
|
|
There has been an option to script objects to separate files in every version of SqlServer ive ever used (6.5 onwards).
If you are unable to find that option by reading each page of the wizard I suggest you go for another career - one that does not involve using your eyes or brain.
|
|
|
|
|
Hello Dear,
We developed one project nameed Richmedia. We are servering advertising banner on in.msn.com. So when msn page call from any corner of the world it will ping our server on proirity base. Our database is Sql Server 2005. We have optimised all dotnet code after we came to know about that in SQL Server LOg File there are lots of error. And all error is like same
Error: 18056, Severity: 20, State: 23.
2009-02-20 17:53:25.07 spid249 The client was unable to reuse a session with SPID 249, which had been reset for connection pooling. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.
Can Anyone tell me why I am getting this error frequently?
Any help would be appreciated.
TarDak
|
|
|
|
|
Hi am working on application that most be highly secure
how can i ensure that if somebody broke into the database and backup he canoot restore on another machine
how good is .net encrption. i want to be sure that people canoot crack the password over the network
i need help please
|
|
|
|
|
Hi All,
Currently I have the following dataset:
Name UserEmailId RoleName RoleID
A A@A.com Admin 1
A A@A.com Dev 2
A A@A.com Tester 3
NOW I WANT THE ABOVE DATASET AS:
Name UserEmailId RoleName1 RollName2 RollName3
A A@A.com Admin Dev Tester
OR
Name UserEmailId RoleID1 RoleID2 RoleID3
A A@A.com 1 2 3
Please provide the solution. Thanks
Rajesh Ram
raj
|
|
|
|
|
rajg82 wrote: Please provide the solution. Thanks
The solution is to properly define your table structures in the first place.
User Table
UserId, Username, Email
Role Table
RoleId, RoleName
UserRole Table
UserId, RoleId
|
|
|
|
|
Hi J4amieC
Yes, I have the same table structure what u mentioned.
thx.
raj
|
|
|
|
|
I think you may be looking for a pivot table clickety[^]
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
hey can any one tell me how to read the xml data from sql server....
thanks in advance
icanmakeiteasy
|
|
|
|
|
1) Open a connection
2) Issue a SQL Command using one of the FOR XML commands or read froma n Xml column
3) Close Connection
Further reading[^]
|
|
|
|
|
thanks for reply
i have a xml file at c:\sample.xml
i want to read the sample.xml file from my stored procedure how can i?
icanmakeiteasy
|
|
|
|
|
Based on your posts, use the OPENROWSET[^] function, like:
SELECT * FROM OPENROWSET(BULK 'c:\sample.xml', SINGLE_BLOB) AS somealias
|
|
|
|
|
I AM SAVING DATA OF A EDITOR ON THE BUTTON CLICK. IN TABLE WE HAVE THREE COLUMNS DEPARTMENT DATA , DEPARTMENT ID . AND I AM PICKING DEPARTMENT ID FROM DEPARTMENT SELECTED IN DROPDOWNLIST.. AND I M SHOWING SELECTED DEPARTMENT DATA IN EDITOR. NOW I WANT IF USER EDIT THIS DATA . AND CLICK ON THE BUTTON DATA AGAIN SAVE IN THE TABLE WITH SAME ID IS IT POSSIBLE… GIVE ANY SUGGESION OR QUERY THNX IN ADVANCE.
|
|
|
|
|
Turn your caps off - it is the equivalent of walking up to someones desk and SHOUTING in their ear. It is also really painful to read!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Yes, its called an UPDATE
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
mu question is on clicking the same button can we add the data with same id . for update we have to use other button.
|
|
|
|
|
why not you create a extra variable which hold the ID of the department. set -1 for new department. If you edit any saved department, then replace -1 to ID of saved department. And finally on button click, check whether variable is equal to -1 then use insert query, otherwise use Update query
|
|
|
|
|
This is a somewhat stupid question, it all depends on your database design - if the id is a primary key then no, otherwise yes.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
I'm using IReport and I'm trying to connect to the database on the server from my home computer. It works fine when I connect from my work computer that is on the same network as the server but it fails from home.
I checked on everything, firewall is turned off on the server, all sql server services are running, The tcp/ip port 1433 is enabled and sql server authentication is enabled on sqlexpress.
The url is: jdbc.sqlserver:// serverIpAddress:1433;DatabaseName=mydatabase
It connects from my work pc, but at home it doesn't. Am I missing something?
modified on Thursday, February 26, 2009 2:55 AM
|
|
|
|
|
I think you just committed hari kari, I have not heard of someone attempting this for at least a decade, your exposure is extreme and there are automated systems that test 1433 for open connections.
Having said that you may be lucky and the IP you are using is the local one on your office network and not a publicly accessible IP address. If you want to connect to your office SQL server then do it via web services not directly.
Never underestimate the power of human stupidity
RAH
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
