Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
Search the Tips

Sql Server - Page 2

21-40 of 728     Previous     Next
Date Formats for the DATE Data Type
by Srinath MS
SQL Server offers two date formats for the DATE data type.
Determine Whether a Table Has an Identity Column
by Jaya Nehru Kumar
A simple, single line of code helps you determine whether a table has an identity column.
Identify "Drop Out" Columns Used in Stored Procedure Definitions
by Jaya Nehru Kumar
Find out an incredibly easy way to identify dropped out columns used in stored procedure definitions.
Insert the Current Date/Time in a SQL Server, Excel Spreadsheet, or MSAccess
by Srinath MS
The following keyboard shortcuts are quick ways to insert the current date and time in an Excel spreadsheet, Access table, or SQL Server table.
Retrieve All Columns from Each Table in Every Database
by Mohammad Khan
This stored procedure retrieves all the columns of each table in every database.
Finding a SQL Server Object
by Srinath MS
Use this code to find a SQL Server object, even if the database name is unknown.
Selecting One Record Before and After a Value
by Srinath MS
Find out how to select one record before and after a value.
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.
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.
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.
Prevent Empty Parameters from Automatically Converting to Null
by Jaya Nehru Kumar
This kind of conversion could lead to unexpected query results--and sometimes no query results at all.
View the Source Code of Stored Procedures in Yukon
by Vadivel Mohanakrishnan
This tip explains how to display the definitions of user-defined stored procedures and system stored procedures in SQL Server 2005 (code named Yukon).
Using T-SQL to Check Whether a Table Exists
by Jaya Nehru Kumar
Use this simple query to check for the existence of a table in a database.
Reset the Identity for All User Tables
by Jaya Nehru Kumar
This tip provides a stored procedure for resetting the identity of all your user tables.
Create and Drop Stored Procedures as a Group
by Jaya Nehru Kumar
Ever created a bunch of stored procedures for testing purposes and went to drop them but couldn't remember all the names you created? A way to avoid this is to group multiple stored procedures under a single name.
Connect to SQL Server Using ADODB Retrieving Records
by Yatin Karekar
This tip will show you how to connect to SQL Server using ADODB Retrieving Records using Record Set and connecting it to Crystal Reports.
Locate the Installed Version of MS SQL Server
by Jaya Nehru Kumar
Use this query to determine what version, Service Packs, and editions of MS SQL Server are installed on a given machine.
Use the Connection String and SQL Profiler to Identify Your Application
by Akash Aggarwal
The ApplicationName property can be very useful when there are multiple applications running on a server and you need to track which application is issuing bad SQL.
21-40 of 728     Previous     Next
Sitemap