I am using SQL Server 2008. I have some dates in my database that I \"think\" I want to break down into smaller parts.The dates are birthdays and death days. I want to be able to output them like by
I have a person table which holds person and his manager at the same time.I\'m using SELF JOIN to select managers email but I get a lot of duplicates.
I have to read two .dbf files that came from a VFP server in SQL and manipulate them. They are sitting in a folder on the server. First, I have installed the VFPOLEDB driver, the ODBC driver, and its
What is the correct connectio开发者_JS百科n string and what are the requirements for connecting to Sql Server 2008 database from Visual Basic 6?\' Initialize variables.
I have to import data from an old schema to a new one, where a column \'career_name\' (in table \'users\') that used to be a VARCHAR now should be an INTEGER which is a foreign key to another table ca
Hi I Can not seem to wrap my head around how to parse an Xml document and the decide if it needs inserting or updating.
I am getting a very big file from a linux box which I import with TOAD Wizard to SQL Server Express for testing
I have to move some da开发者_JS百科ta from sql server to access database. In target access database there are ready tables, I need to move only records. Some of them will require some changes, like cr
I have a SQL MERGE statement that does an UPDATE if a value exists (and an INSERT if it does). I\'d like to record the last few \"historical\" values in the row when an UPDATE happens, sort of like th
I have one database table havingStudentId(int),Subject(varchar(50)),Marks(int),IsPass(int),ExamDate(Datetime)
加载中,请稍侯......