Programming SQL

Storing text files in SQL Server 2005 db
I need to store our ASP files into a SQL 2005 database. Average file size is about 35 KB. Could someone please explain an easy way to store text files in SQL 2005? Thank you. ... 22 Jul 2008 13:43

Multiple attribute design that need to be searchable
Hello, I'm doing a school project and I'm supposed to be able to track campgrounds and their amenities. Here is some of the information I'm supposed to store: CAMPGROUND Number of Sites Number Summer Season End Date Summer Season Start Date Reservations Accepted Y/N F... 16 Jul 2008 17:11

Dealing with multiple attributes that need to be searchable.
Hello, I'm doing a school project and I'm supposed to be able to track campgrounds and their amenities. Here is some of the information I'm supposed to store: CAMPGROUND Number of Sites Number Summer Season End Date Summer Season Start Da... 18 Jul 2008 12:22

Set IDENTITY from T-SQL
The Microsoft online helps shows this syntax for modifying existing columns to turn IDENTITY on with the following syntax: ALTER TABLE MyCustomers ALTER COLUMN CustId IDENTITY (200, 2) However other blogs state this is not supported(?) and I get an error when I tried this. Am I off on the syntax perhaps? What... 11 Jul 2008 15:06

Very basic question on T-SQL
Have not been able to find an example despite extensive googling. How do I set up a script to create my tables. The part that I need is the part that drops the tables ONLY IF THEY CURRENTLY EXIST. This is what I have and it fails on a syntax error: IF OBJECT_ID('dbo.Parent', 'U') IS NOT NULL BEGIN ... 9 Jul 2008 12:41

Dynamics SQL as the source for a Cursor?
Does anyone know if it is possible, and if so how, to use a dynamically built SQL statement as the source for a cursor in T-SQL? For example, I'd like to do something functionally like the following: DECLARE @TABLENAME varchar(255) DECLARE @ID varchar(255) SET @TABLENAME = 'Customers' DECLARE CSR_TES... 10 Jul 2008 16:32

Better query without CASE?
All, Thanks for any help on this… [TabeA]( [originzip] [char](5), [destinationzip] [char](5), [Column3] [varchar](20), … ) [ZipTable]( [Zip] [char](5), [City] [varchar](35), [State] [char](2), [County] [varchar](45) ) SELECT a.column3, a.originzip, a.destinationzip FROM dbo.TableA A LEFT O... 10 Jul 2008 12:23

' â?" ' what is this ?
where i have to check ? only ' - ' this operator creates like this other operators working fine "Rick Sawtell" wrote: "Ramesh Subramaniyan" <RameshSubramaniyan(a)discussions.microsoft.com> wrote in message news:A718EFEE-62EB-4026-AA4A-3BA1135867B7(a)microsoft.com... i have SQL File distict.sql like ... 9 Jul 2008 10:37

' �?" ' what is this ?
"Ramesh Subramaniyan" <RameshSubramaniyan(a)discussions.microsoft.com> wrote in message news:A718EFEE-62EB-4026-AA4A-3BA1135867B7(a)microsoft.com... i have SQL File distict.sql like this CREATE VIEW [dbo].[vFM_11023_CAPropertyStatement] AS SELECT CAST(tTS_District.District AS VARCHAR(10)) + ' - ' + RTR... 16 Jul 2008 19:15

SMO C#
If I've got two procedures which are identical apart from the object type they use, can I make one generic procedure? They're using SMO and the Scripter object. thanks static void ScriptTables(Scripter scripter, Database db) { UrnCollection c = new UrnCollection(); Li... 9 Jul 2008 09:35