Posted in SQL Server on April 25, 2008 | Leave a Comment »
In Sql server 2005 we can Encrypt & decrypt our data using this function.
// For Encryption
EncryptByPassPhrase(‘Key Value’,'Text’)
// For Decryption
cast(DecryptByPassPhrase(‘Key Value’,Encrypted Text) as varchar(16))
Key Value :- Value Of Key That is use For Encryption & Decryption Process.
Text :- In That Perameter Pass the Text That can be Encrypt.
Posted in SQL Server on April 16, 2008 | Leave a Comment »
If you have ever worked with Microsoft Access, you might have used the TRANSFORM statement to create a crosstab query.
Even though the similar functionality was missed in sql server 2000, we can achieve the same in SQL Server 2005 via the PIVOT operator with the SELECT statement.
The PIVOT operator can be used to [...]
Posted in SQL Server on April 16, 2008 | Leave a Comment »
1). With Help Of master.sys.xp_dirtree Function We get the directory structure of windows System.
This Function Accept One Parameter.
In This Pareamter give the Location.
below give code for getting structure of windows file system.
EXEC master.sys.xp_dirtree ‘c:\Inetpub’
Posted in SQL Server on April 16, 2008 | Leave a Comment »
There is a syntax of getting database name & status from sql server.
SELECT DB_NAME() AS DatabaseName, DATABASEPROPERTYEX(‘master’, ’Status’) AS DBStatus
Posted in Crystal Report on April 14, 2008 | 6 Comments »
1). Create XML File That Used In this Reports.
So,How To Create That XML File.
1). To Creating that XML Using Dataset.
2). First Fill Dataset From DataAdapter.After That there is one property WriteXMLSchema Of Dataset.In this Property write the XML FIle Name.
2). After Creating that XML File.Right Click On Project And Click On Add New Item.While Click [...]
