.NET

Query error ?!!!

• by Saeed-Salimi

• SQLServerCentral.com

• Topic

Hi every one...I execute this query : SELECT     news_content.id_doc AS ID, news.publish_date, news.publish_time, news_content.title, news_content.abstract, news_content.lead, news.image_title,                       news.image_main,                       SUM(doc_view_stats.hour_00 + doc_view_stats.hour_01 + doc_view_stats.hour_02 + doc_view_stats.hour_03 + doc_view_stats.hour_04 + doc_view_stats.hour_05                        + doc_view_stats.hour_06 + doc_view_stats.hour_07 + doc_view_stats.hour_08 + doc_view_stats.hour_09 + doc_view_stats.hour_10 + doc_view_stats.hour_11                        + doc_view_stats.hour_12 + doc_view_stats.hour_13 + doc_view_stats.hour_14 + doc_view_stats.hour_15 + doc_view_stats.hour_16 […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2004-12-06

4 reads

How to ORDER BY using an @parameter

• by Jim-W-White

• SQLServerCentral.com

• Topic

Is it possible to take in a parameter and use it as the column name or column number in the ORDER BY clause of a SQL statement?  I've copied the SP_Columns stored procedure and created a new one from it.  I want to specify a sort order as one of the parameters when I run the […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2004-11-24

3,668 reads

Any Extended Stored Procedure is there to find out the number of drives in the server and their capacity

• by Marimuthu-129612

• SimpleTalk

• Topic

Hi,Any Extended/Undocumented Stored Procedure is there to find out the  drive name and their capacity in the server .(we know xp_fixeddrives gives only the free space in each drive i want to know the capacity of the each drive)Any Stored  proc/Extended Stored proc /Undocumented DBCC Command to find out size/max size of the datafile and data […]

2004-11-22

RE: List database recovery modes

• by lholman

• SimpleTalk

• Reply

JP,try running sp_helpdb without passing any parameters, the recovery model is listed in the 'status' column.lloyd

2004-11-15

RE: select overlapping date(s) problem.

• by Ben-Haschalk

• SimpleTalk

• Reply

Thanks for the work, all, Jeff's research did the trick in the end. 

2004-11-15

RE: 3rd Party Products for Monitoring SQL Server

• by Cricketdogger

• SimpleTalk

• Reply

Another one to check out is the "i3 for Sql Server" product from Veritas. 

2004-11-09

WebService - Enabling SQL Server 2005 Procedures

• by Additional Articles

• Other

• .Net

• Article

One of the most interesting features that I'll explore is that you can now create WebServices in the database tier directly, without resorting to "add ons" or even the use of IIS at all. One of the many extensions to Transact SQL is the new CREATE ENDPOINT statement, which allows the developer to create an endpoint directly from SQL Server 2005, which hooks right into the Kernel Mode HTTP.SYS driver, exposing functions and stored procedures written either in T-SQL or native CLR methods/classes.

2004-11-04

3,131 reads

• Discuss

Writing Managed Stored Procedures in SQL Server 2005

• by Additional Articles

• DevX

• .Net

• Article

Are you tired of struggling with T-SQL to encapsulate the logic your applications need to get data into and out of SQL Server? Now you can bypass SQL altogether, and write logic that runs directly within SQL Server in your favorite .NET language.

2004-11-01

4,360 reads

• Discuss

Msg 2754 from Transact-SQL

• by Frank-Rosser

• SimpleTalk

• Topic

Does anyone know how to get rid of Msg 2754 when using RAISERROR with a Severity greater than 18?I keep getting the following. I know what it means, but I just can't see the point of it. I would rather it not appear on the error log.Msg 2754, Sev 16: Error severity levels greater than […]

2004-10-30

530 reads

Query Notifications in ADO.NET 2.0

• by Additional Articles

• MSDN Communities

• .Net

• Article

Learn how to use the new notification technologies in ADO.NET 2.0 and SQL Server 2005 to handle ad-hoc data refreshes.

2004-10-18

2,668 reads

• Discuss