Search results for query: *

I've been successfully using a local installation of SQL Server Express for about 6 months. I recently changed my network/PC password and I've been unsuccessful in loging on to SQL since. I changed my password in SQL Server Configuration Manager, and it seems to start up OK. In the SQL Server...

Thanks to SQLDenis for your help. Your tips allowed me to complete the stored procedure I was working on.

It's a variable. I left out the Declare statement for simplicity.

I'm trying to open a cursor using an SQL statement based on a DB whose name changes from month to month. I have the following code: SET @dProcDate = '02-01-2007 00:00:00' SET @cMonth = 'Test_' + CASE WHEN MONTH(@dProcDate) < 10 THEN '0' + CAST(MONTH(@dProcDate) AS char(1)) ELSE...

Thanks for all your help George. It works!

Thanks George - That's a big step in the right direction. However it's still not working. What's the difference between running the above code, which returns the error message: Msg 3701, Level 11, State 5, Line 1 Cannot drop the table 'XXX_012007.Dbo.PT', because it does not exist or you do not...

Tried your code, received this error: The name 'drop table [XXX_012007.Dbo.PT]' is not a valid identifier.

I am attempting to write code that drops tables/databases based on a date. I have several databases/tables with the following names: Database - XXX_122006 tables - PT_122006 PD_122006 Database - XXX_012007 tables - PT_012007 PD_012007 I have the following...

Thanks to you both. I'm a beginner with ASP.NET and it's a steep learning curve.

I have the following entry in my web.config file: <connectionStrings> <add name="ConnectionString" connectionString="Server=XXX\SQLEXPRESS;Database=Test;Uid=sa;Pwd=XXXXX"></add> </connectionStrings> I am trying to access the connection string as follows: Dim lcConStr As String lcConStr =...

Thanks for your help TipGiver. The ConnectionString.com provided me with correct format for my string.

Dsn. It's an ODBC Data Source

I have the following code in the page_load event of page Default.aspx: Imports System.Data Imports System.Data.SqlClient Partial Class _Default Protected Sub page_load(ByVal sender As Object, ByVal e As System.EventArgs) If Not IsPostBack Then Dim conn As New SqlConnection...

I have a simple sp: create procedure [dbo].[sp_GetClinicLocation] @cCID char(5), @cLocation varchar(50) output AS BEGIN SELECT @cLocation = cLocation FROM AC WHERE cClinic = @cCID END I'm trying to call the procedure as such: declare @Test varchar(50) exec...

Thanks to all who replied. Your tips were valuable in resovling my problem

I have a written a query which asks for the results of a couple of aggregate calculations: count(*) as nTotal, SUM(nTVC) as nVTotal Results nTotal = 4754 nvTotal = 11911 However, when I add this line to the query: count(*)/SUM(nTVC) AS nVPercent Results nTotal = 4754...