Programming SQL

Name of MS Online Classes
I have asked this question in other forums but can't get an answer. I really want to take some Sql Server and Windows classes. I know MS offers these cool online classes that are reasonably priced on Sql Server and Windows, but I can't for the life of me remember the name of them. What do you call them, so I... 2 Jul 2010 13:33

Ntext Data Type
How can I declare a NTEXT parameter within a sproc? The @newsstory parameter is a ntext data type and I can't get the syntax right. The table column it represents is ntext 8000 data type and being used for a fairly decent size news article. If anyone has a better idea for what data type would be better, I'd app... 2 Jul 2010 19:04

SQL Connection from VS 2008 Express to SQLExpress database
I'm recieving the error "Logon Failed For User". Everything looks right to me, so I am unsure what could be wrong. Here is the connection string I am using in my vb code: connectionString2 = "Server=MyComputer\SQLEXPRESS;Database=adatabasename;User ID=auserid;Password=apassword" The SQLExpress version i... 5 Jul 2010 13:20

Selecting dynamic number of columns into fixed-structure table
I have a table with the following columns (the Pen# columns are all REAL data types and all columns support NULL values): dtDateTime Pen1 Pen2 Pen3 Pen4 Pen5 Pen6 Pen7 Pen8 Pen9 Pen10 I have a stored procedure that returns data sim... 3 Jul 2010 10:08

Alternative to dynamic SQL in Table Valued Function?
Hi, I have the following SQL Server table valued function that I've written to use as a parameterised view. It takes a bunch of parameters and returns a table of results. Each of the parameters can contain a value or can be NULL. If the parameter is NULL then no rows will be filtered by that value. The function ... 2 Jul 2010 16:52

Best way to store image, voice, text file?
Hello there, Is it possible to define a sql server field to store image, or voice, or text file? If the size of the file is very big, thus exceeding the max row size 8064 bytes limit, is it better to store it in a directory, and just save the location of the file in the field? Thanks, Ben ... 3 Jul 2010 10:08

TRANSACTION PROBLEM, Pls Help me!
I have fallen into TRANSACTION problem in MSSQL2005. I created small easy to understand sample which throws same error as in my problem. So sample is : ============================================== CREATE PROCEDURE dbo.spTempProc2 AS BEGIN TRANSACTION CREATE TABLE #aa (col INT) ROLLBACK RAISERROR ('error t... 1 Jul 2010 09:59

no answer?
Rich, I assume u resolved the issue. Can u share ur solution - I am receiving the same error. Thnx -DL Rich wrote: And here is one other statement that did not run from the Database setup 02-Jun-10 And here is one other statement that did not run from the Database setup code ALTER DATABASE [BugTr... 30 Jun 2010 23:07

Link server Identity column insert question?
We have a link server I am tryinjg to connect and insert into a table that has a unique primary key index. Default server option is identity insert on. I tried chaging identity insert off via source server but it would not let me. Please let me know if you have any specific ideas on how I can make this work. ... 30 Jun 2010 18:43

Help with SQL Query
We have a distinct list of email addresses in alpha order and we need to transform it from a single column into a grid of three columns maintaining the alpha order. The list is contained in a temp table inside of our query. We then use the temp table list and perform case statement with a mod on the row_number in a... 30 Jun 2010 16:30