|
Hi - Want to search for a word - in all the existing stored procs in SQL2005?
Is there a way we could do this?
Many thanks.
|
|
|
|
|
SELECT ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE CHARINDEX('SearchWord', ROUTINE_DEFINITION) > 0
This searches only 1 database; to search all databases:
SELECT name FROM sysdatabases
and loop through each database, doing the first query each time.
Scott
|
|
|
|
|
I am not seasoned in databases in general, let alone in MS SQL Server administration in particular. I have installed MS SQL Server 2000 on my computer - authentication set to SQL Server and Windows. My problem is, that after I have designed my database tables in an Enterprise Manager the tables appear to be 'read only' when I access them in a Query Analyzer. It doesn't help to set 'enabled' to all of the existing permissions to my database and all its tables for my account, a public and a guest. I can't append a row neither in Query Analyzer, nor programmatically. Of course I can access the database itself and its tables as well. This applies to all my databases. I know I have overlooked something in SQL Server settings, but I haven't a clue what it is.
Can you give me a hint?
Regards,
Zdenek
|
|
|
|
|
Zdenek Navratil wrote: It doesn't help to set 'enabled' to all of the existing permissions
Including the DenyWriter permission?
It would appear to me that you are logging in with different accounts in Query Analyzer and Enterprise Manager.
|
|
|
|
|
I don't think so. I run both Query Analyzer and Enterprise Manager in the same account.
Regards,
Zdenek
|
|
|
|
|
So, you can modify data in Enterprise Manager, but not in Query Analyzer? If they are running in the same account this cannot happen.
|
|
|
|
|
Could anyone suggest me good books for Data modeling and RDBMS?
|
|
|
|
|
Handbook of Relational Database Design (Paperback)
by Candace C. Fleming, Barbara von Halle
Regards
RR
|
|
|
|
|
|
Besides buying books, there are good tutorials available from the big database makers - Microsoft, Oracle, IBM, MySQL and so on, and not to forget the various university resources.
Why not visit them. OR, google for then such as [^]
modified 1-Aug-19 21:02pm.
|
|
|
|
|
Hi
I have a table, with 4 columns, and round about 400 rows of records in it. Now i want to have INSERT Query for each and every record separately.
I dont want to use Import/Export option for this.
Hoping for replies ASAP and thanks in advance
|
|
|
|
|
Write a small console program to query the table, then format the resutls (row by row) into insert query statements and write them out to a text file. One table with 4 colums - should take you less than 10 minutes to do this.
|
|
|
|
|
Can we do that in SQL server itself using Stored procedures.
|
|
|
|
|
Obviously, you have not explained what it is you are trying to do. Please clarify.
|
|
|
|
|
karthiBalu wrote: Now i want to have INSERT Query for each and every record separately.
What is it exactly your trying to do here?
I'd love to help, but unfortunatley I have prior commitments monitoring the length of my grass. :Andrew Bleakley:
|
|
|
|
|
Do you mean to insert data from one table to another via T-SQL?????
|
|
|
|
|
Hi everyone,
I have a problem but I dont know this problem is for which forum Sql server or no if its not for
this forum im really sorry.
I bought Sql Server 2005 but when i want to install it,it says you have a newer version of Sql Server in your system
I installed VS2005 and my Operating systems is XP Pack2 Can you help
me,please.
Thanks
-- modified at 13:39 Sunday 17th September, 2006
|
|
|
|
|
messages wrote: g
VS2005 (professional or higher) installs SQL Server 2005 as part of the default installation, so you already have it installed.
|
|
|
|
|
VS 2005 installs SQL Server 2005 EXPRESS as part of default installation.
|
|
|
|
|
During installation ur vs.net 2005 slect custom mode and do not install sql express 2005
|
|
|
|
|
Hi all,
I have created a database for my application. One of the tables manages the employees data. It has got 2 columns listing primary skillset and secondary skill set (free text to give a summary of skillsets). Both these columns are optional. It is basically aimed at capturing skillsets of employees in a department but could be extended to all.
Now, what comments I receive from some of team members is that these skillsets columns being optional should be placed in a different table with a link to employee_master.
Should I do this really? If so, why should I? How does this improve the existing design? What is wrong with having it all in a single table?
Thanks in advance,
|
|
|
|
|
Since they are optional, they could be 'missing' if in a linked table. That is, you would simply not add the linked row until there was some data to supply. This would conserve space in the database (but would complicate your application design a bit, since you would need to deal with returning no rows for the join). It would also simplify tasks like locating which employees had no skillsets, etc.
If you keep this in the main table, every row will have the colums, which take up some space even if NULL.
|
|
|
|
|
The key advantage that separating the skillset information out to an Employee_Skillset table is that you could store much more information, make it easier to retrieve and have greater control over the data entry. You could have columns to cover not just the skill but the level and any qualifications held. It is perfectly possible to store and retrieve this data from free-text columns but you have a greater chance of simple things like spelling mistakes causing incorrect query results.
Ian
|
|
|
|
|
i have no idea about using a SQL database but i need it in my application.
any help
salie
|
|
|
|
|
If you don't know anything about it, how can you know you need it?
|
|
|
|