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 738     Previous     Next
Executing Marked Text in SQL Server Management Studio
by Cindy Rodriguez
In SQL Server Management Studio, you can use the Alt key in your keyboard to select blocks of text to execute.
Quickly Determine Which Tables Need Indexes in SQL Server
by Srinath MS
A quick way to determine which tables need indexes is to use the SQL Server Profiler Create Trace Wizard with "Identify Scans of Large Tables."
Debugging SQL Server Stored Procedures Through Visual Studio.NET
by Srinath MS
Learn how to use Visual Studio.NET to debug SQL Server stored procedures.
Determine the Version and Build Information for Microsoft SQL Server
by Alexander Ocher
Use the query shown in this tip to determine the version and build information for Microsoft SQL Server.
Obtain Information About Table Columns in Microsoft SQL Server
by Alexander Ocher
To obtain information about table columns in Microsoft SQL Server, use the INFORMATION_SCHEMA.COLUMNS view.
Testing Compatibility Between SQL Server Versions
by Srinath MS
When migrating SQL code (stored procedures, triggers, etc.) to newer versions, it's not uncommon to have to rewrite your entire back-end code. However, a simpler solution is to check the exisiting code's compatibility with the newer versions.
Returning a Random set of Records
by Parthasarathy Mandayam
Find out how to use the NEWID() function to return a random set of records.
SQL Reporting Service: Using the rc:TargetLink Parameter for Drilldown Reports
by Jayadev D
Find out how to prevent SQL Server Reporting Services drilldown actions from opening in a new window.
Graphical Tools for MSDE
by John Joseph
MSDE's small-footprint SQL Server compatible database has now been retooled as SQL Server— and it does not include graphical tools.
How to Backup an SQL Server Database in a Shared Network Location
by Jaya Nehru Kumar
This workaround allows you to back up shared network locations in the SQL database.
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.
21-40 of 738     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date