The tables are as follows CREATE TABLE dbo.Blogs dId int * PRIMARY posted datetime(8) title nvarchar(50) catgy nvarchar(50) blogs nvarchar(500) picId int UName nvarchar(50) CREATE TABLE dbo.BlogPix bgId int * PRIMARY picId int Photo nvarchar(50) Caption(50) UName nvarchar(50) I ...more >>

I want to upload a Text file which is comma delimited into SQL Server Database through.NET application. Can someone let me know the best way to do it? Can someone helpme with the stored procedure for the same as well? Thank you in advance Vic....more >>

I may have asked this type of question before but I couldn't find it in the archives. Apologies if I have. Basically I'm looking for a set-based solution for what I would've thought was a pretty common sort of problem. I have a set of accounts, each of which has a current balance and a purchas...more >>

I have a table that is used to store data feeds. The table is built fresh every day. There are about 1 million records inserted to the database on this feed every day, and the resulting table is about 400 meg in size. This data is then deleted at the end of the day, and a new feed is brough...more >>

I need to be able to update the existing data in sched_report_milestone when my vendors table has a record inserted or updated. The fields in sched_report_milestone that would need to be updated are vendor_id_csv and vendor_name_csv. The tables do not directly relate to each other. The foll...more >>

Hello, I have a table with 2 fields: (Keyfield, Hits) The hits is a value of (0,1, 2, 3,...) Each time a user visits a webpage in my application I want to increment the Hits field in the database for a Keyfield. What is the best way to do this? (note that 1000ths of users can visist the ...more >>

Hello, How can I do the following: I have a stored procedure that is called and passed a variable from .net. I currently use it 2 ways - if no variable is passed, pull all records, or, if a variable is passed, pull that record. What I need to do, is, if the user enters one or 2 characters, p...more >>

Hello I've read that there is a bug in sql server 2000 when doing a bcp command with dates in dd-mm-yyyy format. and to fix it there is a hotfix contained in sp4 . I ve installed the sp4 but the bug remains anybody has an idea about this hotfix and from where we can get it thx ...more >>

Is "Create FUNCTION" a valid command in SQL 7? Whenever I try and create a function I get the error "Incorrect Syntax near FUNCTION" Thanks Don ...more >>

BOL: When SPs take parameters whose values differ widely b/w executions of the SP, resulting in diff. execution plans to be created each time, forcing a recompile shud be considered. What variations in the values is being talked abt?? Thanks...more >>

Hi there ! Recently i had written a stored procedure which contain multiple select statment. One follow by anyother, like the following, declare @nTemp int select count(*) AS TempCount from tableA where conditionA select @nTemp = TempCount select count(*) from tableB where condtionB s...more >>

I have a variable @var1 of type varchar(100) which captures the following error message, which is produced by executing a sql statement: Incorrect syntax near the keyword 'where'. Please pay special attention to the single quotes around the word where. These single quotes are causing a lot o...more >>

I have two tables, tblFamilies & tblFamilyMembers. How do I write a query which will return the family name in the first column, and all of the family members seperated by commas in the second column? Thanks, Lomas...more >>

I want to backup and restore a database in asp.net. The backup process is successful and fail when restore with message: User does not have permission to RESTORE database 'Health'. RESTORE DATABASE is terminating abnormally the restore SQL is : restore database Health ...more >>