SQL Server and Crystal Reports

Pages

Home
SQL Server Interview Questions
Crystal Reports Interview Questions

Tuesday, November 25, 2014

How do we format field?

Right click on that field and choose format field.

Posted by Unknown at 21:27

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

No comments:

Search This Blog

Total Pageviews

Popular Posts

What is the STUFF function and how does it differ from the REPLACE function?

STUFF function is used to overwrite existing characters. Using this syntax, STUFF (string_expression, start, length, replacement_characters...
TRIM() Function – UDF TRIM()

SQL Server does not have function which can trim leading or trailing spaces of any string. TRIM() is very popular function in many languag...
SQL SERVER – Reducing CXPACKET Wait Stats for High Transactional Database

While engaging in a performance tuning consultation for a client, a situation occurred where they were facing a lot of CXPACKET Wai...
Retrieve Current Date Time in SQL Server CURRENT_TIMESTAMP, GETDATE(), {fn NOW()}

There are three ways to retrieve the current datetime in SQL SERVER. CURRENT_TIMESTAMP, GETDATE(), {fn NOW()} CURRENT_TIMESTAMP CURRENT...
Difference Between Unique Index vs Unique Constraint

Unique Index and Unique Constraint are the same. They achieve same goal. SQL Performance is same for both. Add Unique Constraint ALTER T...
Convert Text to Numbers (Integer) – CAST and CONVERT

How to convert text to integer in SQL? If table column is VARCHAR and has all the numeric values in it, it can be retrieved as Integer us...
Search Stored Procedure Code – Search Stored Procedure Text

How can I find if particular table is being used in the stored procedure? How to search in stored procedures? How can I do dependency ch...
How many types of reports can be generated in crystal reports?

Basically there are only five types of report templates available.. they are Standard Report Blank Report Cross tab report Mailing label r...
Select Only Date Part From DateTime – Best Practice

SELECT GETDATE ( ) ResuleSet : 2007 - 06 - 10 7 : 00 : 56.107 The required outcome was only 2007/06/10. I asked him to come up with...
Can we use stored procedure for creating the report?

Can. By Adding Command in Crystal Report XI.

Simple theme. Powered by Blogger.

Pages

Tuesday, November 25, 2014

How do we format field?

No comments:

Post a Comment