XP_ENUM Stored Procedures

Digging a little deeper this week into extended stored procedures, we find the xp_enum procedures. These
procedures require no parameters but provide a handy bridge to the operating system and is extremely helpful for developers.

SQL Server CE: New Version Lets You Store and Upda

Handheld device users need to be able to synchronize with a main data store when it's convenient and, preferably, when the back-end database server isn't busy. SQL Server 2000 Windows CE Edition allows you to build a traveling data store that can be displayed and run on a variety of devices. SQL Server CE supports a subset of the full SQL Server package, and can be used as a standalone server or in tandem with SWL Server and IIS.

PASS 2001 North America - Register and Save $500

Unique access to more than 110 sessions and 80 presenters, including SQL Server users and Microsoft developers. Educational tracks include: data warehousing and business intelligence; developing web-enabled and line of business solutions; enterprise database administration and deployment; and, professional development. Register today and get a great return on your SQL Server investment!

Blogs

Daily Coping 22 Apr 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Altering a Computed Column in a Temporal Table in Azure SQL

By

System-versioned temporal tables were introduced in SQL Server 2016. They provide information about data...

Basic OFFSET–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs

Forums

Implicit varchar to nvarchar conversion by linked server

By andrei_solntsev

I have a remote query over linked server with search by varchar column. However,...

Office FOMO

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Office FOMO

Parquet

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Parquet

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Parquet

See possible answers