Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

Search the Tips

SQL - Page 4

61-80 of 604     Previous     Next
Find the Total Number of Tables in an MS Access Database
by Jaya Nehru Kumar
Use the code in this tip to find the total number of tables in an MS Access database.
Convert Descriptive Flex Fields to Numbers
by Kamlesh Jethwa
Often, data in Oracle applications is stored in extended columns known as Descriptive Flex Field (DFF) columns.
Determine Whether a Given Column Name Is an Identity or Not
by Vadivel Mohanakrishnan
This tip lists two ways in which you can find out whether a given column name is an identity or not in SQL Server.
Determine How Many Times a String Is Found Inside Another String
by Zarko Jovanovic
This tip shares a fucntion that can help you determine how many times a string is found inside another string.
Handling Null Values in Oracle
by MS Sridhar
Find out how using NVL in your queries is better for displaying information and helps avoid front-end processing.
Determine the Type of Modifcation Operation on a Table
by Sachin Kainth
Find out how to use the INSERTING, DELETING and UPDATING trigger predicates to determine the type of modifcation operation that's been performed on a table.
Turning Recursive and Nested Triggers On and Off
by Sachin Kainth
This tip gives you the commands to switch recursive and nested triggers on and off.
Presenting Dates in Varying Formats
by Sridhar MS
Dates are generally a requirement for every application. However, including dates for users across the globe can be tedious, because different people use different formats to read the date.
Getting New Values Entered into a Table
by Sachin Kainth
Find out how you can use :new.<fieldname> to retrieve new values entered into a table.
Constructing Strings of Repeated Characters in T-SQL
by Srinath MS
Learn how to use the Repliciate() function to display a set of characters for a specified length.
Find All User Tables, Columns, DataTypes, and Length
by Daljinder Singh
Use this code to determine all your user tables, plus their columns, datatypes, and length.
Locate All Stored Procedures and Their Objects/SQL Tables
by Daljinder Singh
This code shows you how to you need to locate all the stored procedures and objects/SQL tables upon which they depend.
Making Tables Read-only in Oracle
by MS Sridhar
In Oracle, you can only control read/write capability for an entire tablespace, not for a single table within a tablespace.
Using SELECT * on a Table with the Column Type NTEXT
by Steve Skelton
Find out how to ensure that your NTEXT contents display when you've used SELECT * on table with the column type.
Improve Performance by Reducing Column Size
by MS Sridhar
Learn how to reduce column size in columns that contain data.
Achieving IIF Functionality in T-SQL
by Jaya Nehru Kumar
Although T-SQL doesn't provide an IIF command, you can get equivalent functionality using the SELECT CASE command.
Retrieve All the Index Names for a Given Table Using SQL Query
by Jaya Nehru Kumar
Use this code to retrieve all the Index names for a given table Using SQL query.
Check for the Existence of a Stored Procedure Using T-SQL
by Jaya Nehru Kumar
Find out how you can use T-SQL to check for the existence of a stored procedure.
Combining a Conditional Update with a Single Statement in a Cursor
by Srivastava Alok
In a cursor, rather than checking for values and using an exists condition and having an if/else block, it can be done using a case statement.
Identify Columns for Indexing for Faster Queries
by Sachin Awasthi
A merge join is the best possible join an optimizer can choose between two tables of similar size.
61-80 of 604     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date