Programming SQL

Incorrect syntax near '1' error from sql server 2005
Hi When i am trying to run this SP i get Incorrect syntax near '1' error from sql server 2005. Here are the SP Values i pass. exec aspnet_Membership_CreateUser 'b3302ad3-6814-4ee8-b5ec-bce1210e6730', 'testuser555', 'Rajesh123', '4A86ynGjk7wnOy4I3Njr9w==', 'i...(a)sdsdet.com', 'what Rajesh 123', CAST(... 27 Jun 2008 12:09

Can't connect locally via name
I just updated my PC with XP service pack 3 and now I cannot connect to the SQL server on my network via the host name. I can however connect with the IP address. Named pipes are enabled. Where do I go from here? ... 1 Jul 2008 15:26

concatenation of string var in cursor loop
I am trying to concatenate a string varchar variable to make some dynamic SQL It looks something like this: OPEN Vcursor FETCH NEXT FROM Vcursor INTO @vtablename WHILE @@FETCH_STATUS = 0 BEGIN SET @pm_EXEC = ' SELECT * FROM ' + vtablename + ' UNION ' + @pm_EXEC FETCH NEXT FRO... 27 Jun 2008 12:09

How to upgrade from Sql Server 2000 Personal Edition to Enterprise/Standard Edition ?
Here is info on how to purchase the current SQL Server 2005 editions: http://www.microsoft.com/sql/howtobuy/default.mspx HTH, Plamen Ratchev http://www.SQLStudio.com ... 27 Jun 2008 10:05

How to upgrade from Sql Server 2000 Personal Edition toEnterprise/Standard Edition ?
Where i can get these upgrades ? ... 27 Jun 2008 10:05

How to compare two tables
Hi all I have two tables with the same structure T1: ID, Accessories T2: ID, Accessories The goal is... ID Accessories 1 3 2 1 3 0 When ID is the Key, and Accessories is the comparaison bettwen T1 and T2 that should be answer to this question: How many... 30 Jun 2008 03:30

How to confirm ....
How can I confirm if I have access to "SQL Server Reporting Services" on my SQL Server ? Best regards KSor, Denmark ... 27 Jun 2008 04:58

storage format of character data (varchar vs nvarchar)
Can someone explain the actual storage of varchar vs. nvarchar in SQL Server 2005? I understand that a varchar is a single-byte character and nvarchar is a double-byte character, but does SQL Server ultimately store them both as UCS-2? In other words, what format is the underlying storage? Or should I just be l... 29 Jun 2008 11:08

ConnectionString problem
Hi, I want to create a connection with a SQL Server 2000 and SQL Server 2005 db. With the following connectionString I try to connect me to a SQL Server 2005 string conString = @"Data Source=serverName;Initial Catalog=dbName;User id=myUserId;Password=myPw"; SqlConnection connection = new SqlConnection(con... 27 Jun 2008 11:07

Alternative Way to Aggregate
I have grade table containing student_id, exam_id, grade. I would like to get the average grade based on student_id. Assuming I could utilize avg function, have computed columns, but not group by clause in the select statement, is there another way I could perform group by? Thanks in advance ... 27 Jun 2008 08:02