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...

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...

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...

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 =...

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...

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...