|
Thanks
But i want to find best way to Pass userID , username , email between Layers of a n-tier System.
|
|
|
|
|
|
|
Hi all,
Corresponding .cs file is not added when I add a Crytal Report file in Solution Explorer VS.Net2003. And therefore I am unable to use Strong-Typed report object in my C# code.
I have added the References
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Windows.Forms;
and I selected 'Show All Files' in Solution Explorer.
There is no error in compiling the project. So why the corresponding .cs file of the .rpt file is not added in my Solution Explorer?
Please help.
Arif.
|
|
|
|
|
hi friends,
any one please help me how to store a word document into sql server's blob.
|
|
|
|
|
I have to compare data in a table in a SQL Server DB at two different points of time to check if the concerned rows have been modified/deleted/new additions.
I am using a Stored Procedure to retrieve data the DB and save the data in another table. Now at a later time, I am retrieving this saved data into a first dataset. At the same time, I am using the Stored Procedure I used earlier and getting the current data in the second dataset. Now I have to compare these two datasets and get the modified/deleted/new rows. Any suggestions of how to do this?
All your help is appreciated.
Cheers
Kathy
|
|
|
|
|
Have you tried using Diffgrams
|
|
|
|
|
I am having a problem while working with DataAdapter and linked server. What is happening is that When I select records using "select * from bk...tablename" it gets the record in dataset but when I want to update that dataset it omits the "..." link "bk.tablename" so it does not find the Linked Server.
Any suggestion?
" I have found a new world but... lost the one I belong to... "
|
|
|
|
|
update linkedserver...tablename
SET myfield = 'Hello'
When mykey = 1
|
|
|
|
|
Thanks for the reply but my problem is that I want to do it with the help of Data Adapter  Thanks any ways
" I have found a new world but... lost the one I belong to... "
|
|
|
|
|
hi
I m passing the date parameter to a stored procedure. The stored procedure not does not accept the date format as 'dd/mm/yyyy'. It gives an error -"error converting data type varchar to datetime".
My machine's regional setting is set to 'UK' i.e. "dd/mm/yyyy".
How can i make a change in SQL server so that it accepts date parameters in the "dd/mm/yyyy".
please help
shelly
|
|
|
|
|
|
1. Don't concatenate parameters in your command string - use a SqlParameter object (ADO.NET) or the Parameters collection of the Command object (ADO).
2. If you must use a literal date, use the ISO format 'yyyymmdd'. SQL Server will always accept this format, regardless of locale settings.
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|
|
I never pass any dates to a SQL server I always pass DD MM YY then build the date on the fly in the SQL server Strored Proc. Example below.
###########################################################################################
CREATE PROCEDURE usp_myproc
@YearInt int,
@MonthInt int,
@DayInt int
AS
DECLARE @CD_DATE datetime
DECLARE @TempVarChar varchar(50)
Set @TempVarChar = CAST(@DayInt As Varchar(2) ) + '/' + CAST(@MonthInt As Varchar(2) ) + '/' + CAST(@YearInt As Varchar(4) )
Set @CD_DATE = (Convert( datetime, @TempVarChar, 103 ))
SELECT @CD_DATE
go
|
|
|
|
|
Hi Developrs,
I have developed a database in SQL Server 2000. Now I want to generate its ERD which should not contain attributes of Table.
Is it possible with Visio 2002? If it is possible in any way please do reply me its very urgent.
Thanx in advance.
|
|
|
|
|
How can I select one table which exist in another server but actually i am in my server????
|
|
|
|
|
My problem is that I have 1 table that is in the sql server, and another table that is in memory. The table in memory is defined as follows:
Name: outputTable
computer_id int
dracver string
dracip string
user string
password string
serial_num = string
the table in the sql server is defined as follows:
NAME computer
computer_id int
serial_num var
my question is how do I compare the serial_num column in the outputTable to the serial_num column in the computer table using all the rows in the outputTable.
Here is what I have so far
SELECT computer_id, serial_num FROM computer WHERE dbo.computer.[serial_num]="+FailureTable.Columns["serial_num"];
The problem is that it returns everything from the computer table.
can someone PLEASE HELP!!!!
thanxs
connie
|
|
|
|
|
That's a bit strange. It should only return the computer corresponding to the sigle record from the memory table that you use to create the query.
Loop through the memory table to create a string containing a comma separated list of id's. Then you can use that string in a query:
"select computer_id, serial_num FROM computer WHERE serial_num in (" + idList + ")"
---
b { font-weight: normal; }
|
|
|
|
|
The problem with that is that I also need the dracip string from the outputTable that goes with the serial_num being compared.
Any ideas on how I can also get that data as well??
Thanxs
Connie
|
|
|
|
|
Working in Microsoft Sql Server 2000
Is there a way to encrypt a database object like a stored procedure so the end user can not see the text of SP in their database management tool like Enterprise Manager. Maybe a third party tool or Does Sql Server 2000 provide this somewhere?
|
|
|
|
|
Use the WITH ENCRYPTION option in your stored procedure. Remember, once it is encrypted, there is no way to get it back. You must keep a text copy of the procedure somewhere so you can modify it later if needed.
So a stored proc definition would look like:
CREATE PROC Test WITH ENCRYPTION
AS
your code here
|
|
|
|
|
How to decrypt stored procedures[^].
The SQL Server 2000 stored procedure encryption suffers a fundamental flaw - if you have a known plaintext and the corresponding ciphertext, you can deduce the key. You can then decrypt any other ciphertext using the same key. When you use ALTER PROCEDURE, the same key is used as for the original procedure.
You can save the encrypted procedure text you're trying to decrypt by accessing the syscomments table. You can then ALTER PROCEDURE to a known plaintext, read back the new ciphertext and deduce the key. You can then decrypt the original.
I don't know if this is improved in SQL Server 2005.
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|
|
Thanks for the info! I had remembered reading that SQL Server 2000 encryption was better than before, and that the old ways to decrypt no longer worked. Obviously, a way was quickly found. Fortunately, I don't need absolute encryption, since I just use it to prevent casual tampering. Maybe I will have to add a clause to my support contracts dealing with intentional tampering.
|
|
|
|
|
Our application reads information from a Jet database distributed as part of the program. We have recently added a new block of records to the
database. They appear in Access in the order that we expect, but our application returns an assorted few of the records first, followed by the rest in order.
We are still using the MFC interface to DAO, now through MFC 7.1. We read the database using the MFC/DAO MoveFirst and MoveNext calls. The SQL query is "( [SECT_TYPE_NUM] = 70 )", checking a single field.
|
|
|
|
|
Andrew Hain wrote:
They appear in Access in the order that we expect
Ordered by which column?
Do you define the query with "order by" statement? Like "SELECT * FROM your_table ORDER BY your_table_id".
Marc Soleda.
... she said you are the perfect stranger she said baby let's keep it like this... Tunnel of Love, Dire Straits.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
