|
Hi,
If I have created an encrypted stored procedure with stytax below, is there a way I can edit it at later stage? Or I must keep a master copy at others machine or database?
<br />
CREATE PROCEDURE sp_MyProcedure<br />
{<br />
@CustName nvarchar(128)<br />
<br />
WITH ENCRYPTION<br />
}<br />
<br />
AS<br />
<br />
<br />
regards,
K-PAX? YOUR BUSINESS NEED, OUR CUSTOM MADE
|
|
|
|
|
From Books Online:
"Encrypting Procedure Definitions
If you are creating a stored procedure and you want to make sure that the procedure definition cannot be viewed by other users, you can use the WITH ENCRYPTION clause. The procedure definition is then stored in an unreadable form.
After a stored procedure is encrypted, its definition cannot be decrypted and cannot be viewed by anyone, including the owner of the stored procedure or the system administrator."
You'll have to keep a master copy of the stored procedures somewhere else.
Grim (aka Toby) MCDBA, MCSD, MCP+SB
|
|
|
|
|
Hi Grim,
I get thhi note from the MsSQL help file too. Which mean, I have to save a master copy of the SP in somewhere else.
Also, I have 1 more question about the encrypted stored procedure performance. Will it decrease significantly comapre to those not encrypted?
regards,
K-PAX? YOUR BUSINESS NEED, OUR CUSTOM MADE
|
|
|
|
|
It will have an impact, of course. But the impact shouldn't be significant. The only time the SQL Server needs to decrypt the procedure's code is when it needs to do a compile/recompile of the procedure. This is already an expensive process, anyway, so I doubt you'll notice the additional performance hit.
Grim (aka Toby) MCDBA, MCSD, MCP+SB
|
|
|
|
|
I have 1 table that connect 2 other table to it.
I mean -->
Table 1 Table 2 Table 3<br />
IDPerson IDRelation IDWorkPlace<br />
IDPerson<br />
IDWorkPlace
What I would like to know, is how can I get all the IDPerson that are not in the Table 2 ....
This is not the real name of tables and fields but believe me, it must be like this.
I am a newbie and maybe not but who cares
|
|
|
|
|
Table 1 | Table 2 | Table 3
IDPerson | IDRelation | IDWorkPlace
xxxxxxxx | IDPerson |
xxxxxxxx | IDWorkPlace|
Sorry
I am a newbie
|
|
|
|
|
I can't understand your layout. If you're saying that it's like this,
<br />
[Table 1]<br />
---------<br />
IDPerson<br />
IDRelation<br />
IDWorkPlace<br />
<br><br />
[Table 2]<br />
---------<br />
IDPerson<br />
<br><br />
[Table 3]<br />
---------<br />
IDWorkPlace<br />
then you can use
SELECT t1.IDPerson
FROM [Table 1] t1
WHERE
t1.IDPerson NOT IN (
SELECT t2.IDPerson FROM [Table 2] t2
)
I'd recommend against naming tables using spaces. -Jeff
|
|
|
|
|
Exactly what I needed Thank you.
And it's not the real table name and field.
I am a newbie
|
|
|
|
|
You can use 'not in' in query :
select * from table1 where idperson not in (select idperson from table2)
Om Prakash
|
|
|
|
|
hello, i get this error-> System.Data.SqlClient.SqlException: Login failed for user 'xxx\ASPNET'
do some one knows how to solve it?
i am new to sql and i use msde.
thank u in advance
|
|
|
|
|
See my response to your cross-post in the C# forum.
Grim (aka Toby) MCDBA, MCSD, MCP+SB
|
|
|
|
|
I have a trigger that inserts every action made by the implementation department of my company, including the query, but when they use the Enterprise Manager the query is shown as sp_executesql;, but that isn't of any help for me, what i really need is the actual query that's begin executed by the sp_executesql, any help or clue would be greatly appreciated
|
|
|
|
|
when using embeded sql,i declare and open a cursor in a function which worked well,and fetch record from the cursor in other function,the problem was that the record had been fetched,but the return sql code was -1,why?
and the other problem:the similar problem occured when declare and open a cursor,the return sql code was -1,it's bad result.
thans!
|
|
|
|
|
Without some sort of sample code, my guess would be that your cursor isn't declared as a global cursor, and you're having scope issues trying to access it from different routines.
Grim (aka Toby) MCDBA, MCSD, MCP+SB
|
|
|
|
|
HI,
Is the a way for me to call a store procedure within the DTS package?
regards,
Chris
K-PAX? YOUR BUSINESS NEED, OUR CUSTOM MADE
|
|
|
|
|
Yes
Within the DTS editor, there is a task type called "Execute SQL Task."
Set up one of these tasks and set the SQL statement to "EXEC sp_MyProc"
Grim (aka Toby) MCDBA, MCSD, MCP+SB
|
|
|
|
|
It work great, thanks a lot.\
regards,
Chris
K-PAX? YOUR BUSINESS NEED, OUR CUSTOM MADE
|
|
|
|
|
CREATE PROCEDURE sp_Get_Products_By_Search
@SearchString nvarchar
AS
Select * from vw_Categories_Products
Where ProductName LIKE '% @SearchString %'
return @@rowcount
How can i change it to a correct statement?
Please help me. Thanks.
Simon
|
|
|
|
|
Hi Simon. Would this work?
CREATE PROCEDURE sp_Get_Products_By_Search
@SearchString nvarchar
AS
BEGIN
Select * from vw_Categories_Products
Where ProductName LIKE '%' + @SearchString + '%'
return @@rowcount
END
|
|
|
|
|
i found some resources indicate that ADO.NET has advantage over ADO bcoz of its disconnect features, using Datasets, copy data to datasets and disconnect from database(datasource), i wonder how does it handle the frequent update in database made by other connection,
for example we have two users, accessing a table, one user use datasets, and disconnect, and do manipulation with data in datasets before finally updated to database.
But what will happen if the other user change data in database, since the first user is already disconnected, data in his datasets may not be updated as the other user has changed it.
This is the doubt that i have, i know there must be some mechanism to handle this.
Could somebody enlighten me?
Thanks
|
|
|
|
|
Hi!
I want to create an app that would diagnose and repair (if possible) .mdb files. Where should I start? Is there a particular librady that I should work with?
Thanks!
---------------
Tired of Spam? InboxShield for Microsoft® Outlook® and Outlook Express®
http://www.inboxshield.com
|
|
|
|
|
How do I update the database if I don't know which row to update. The selected datagrid row doesn't match that of dataset row because of how I display things. So how do I match up the dataGrid row to the dataTable row?
|
|
|
|
|
hi,
The one way which appears in my mind is :
While displaying the dataset content on the datagrid maintain the datagrid row :: dataset relation (may be in the form of HashTable) and later on while updating refer to this relation HashTable to locate the dataset rows or columns...
Hope this helps you... sorry if I haven't got your question right...
regards,
Aryadip.
Cheers !! and have a Funky day !!
|
|
|
|
|
hi, how would I go about setting up a hashtable. I haven't worked with the hash Table yet. What I did try, what to see whether the table contained the a row with a field that matches the first cell in the datagrid. But it made my dataAdapter or something to stop working before the problem even hit that function. yet gave no errors at start-time.
|
|
|
|
|
How to build a DataBase of data types (int, char, struct, …)?
I would like to build an ACCESS DataBase, containing information about all the data types we use.
For example:
Suppose, we have the following C/C++ code;
typedef char ARRAY_8_BYTES[8];
struct Foo1
{
int a[20];
int b;
ARRAY_8_BYTES a6;
char a[8];
};
struct Foo2
{
Foo1 foo1;
Foo1 *pFoo1;
char c[12];
};
Ideally, I’d like to have an ACCESS DataBase, containing data about the Foo1, Foo2 structures. So, I would be able to build a program, which uses this data base and (for instance) generates automatically the C code structure definitions above.
The questions I ask myself are:
1) How to organize data which is hierarchical by nature using a relational
data base such as ACCESS?
2) Are they better solutions than using ACCESS to solve this kind of
problem?
3) Do you know about other databases or commercial softwares that permit to
do this?
4)Could you please give me either a precise answer or links which can help me?
Many, many Thanks.
|
|
|
|