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 3

41-60 of 738     Previous     Next
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.
Return Numeric Data with a Thousands Separator in SQL Server
by Parthasarathy Mandayam
This tip shows a simple conversion that uses the style argument of the CONVERT function to insert commas every three digits.
Format a Textbox String to the Correct Currency
by Bart Thieme
This tip shows you how to format a textbox string to the correct currency in SQL Server, independent of regional settings or the user input decimal symbol.
Register the Same SQL Server More than Once in Enterprise Manager
by Parthasarathy Mandayam
Learn how to use the Client Network Utility to create an alias for your server.
Generate HTML Reports from Scheduled SQL Server Maintenance Activities
by Parthasarathy Mandayam
Learn how to use the SQLMAINT application to automatically generate a user-friendly, Web-based report of uitlity activities.
Generating a Sequence of Numbers in SQL Server
by Raj Chidipudi
This tip shows you how to fill the dropdown lists on a Web page, Combo box, or List box in a Windows application.
Getting the Week Start Date and Week End Date in SQL
by Raj Chidipudi
Suppose you're given a date and asked to retrieve data for the whole week in which the given date falls. The example code in this tip produces the Week Start Date and Week End Date.
List All the Tables with a Foreign Key Constraint
by Parthasarathy Mandayam
Use this code in Query Analyzer to list all tables with foreign key constraints.
Create and Retrieve a Named DataSet
by Victor Stefanescu
Use this C# function to create and retrieve a named DataSet using an open connection and a command.
Registering a MSDE SP3 instance into a group in Enterprise Manager
by Ian Northwood
I installed MSDE SP3 as per MS's directions. However, running Enterprise Manager and trying to register the SQL Server instance into a group (this is on the same box that MSDE was installed, BTW) resulted in the old "Server does not exist or access denied" error. This occured whether I used SQL ...
Compare Oracle and SQL Server Dates
by Andy Clark
41-60 of 738     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date