Beginer SQL
Nov 9, 2005I am @ begining stage of handling SQL, please do let me know how to use SQL with Struts Framework.
Regards,
Surya S
You can WIN if you think you can!!!!!!!
ADVERTISEMENT
A Very Beginer Question: Error In Creating Table
Jan 14, 2004I am new in T-SQL. I have just create a empty database and would like to create some table in it. So I type the following in SQL Query Analyzer:
CREATE TABLE mydatabasename.mytablename (
some code here
)
But when execute, it give me an error from the first line "Specified owner name 'mydatabasename' either does not exist or you do not have permission to use it."
when I remove mydatabasename it inserts the table in to the master database, not in my database.
How can I insert the table into my database? Should I use SQL Query Analyzer or use others program? I 've tried to use the command "create table" in enterprise manager but it immediately give another error, some what like "could not use empty column name ... "
Seem to be too simple question, but I am really appreciate your help
Beginer Problem: Is There Any Way To Create The Destination File At Runtime?
Feb 13, 2007I have to generate flat files from SQL Server tables. Its a backup package for few tables which will be run daily. I want the names of the destination flat files to be automatically generated at run time.
I created an expression for the Flat file destination connection and appended the date and the time to the flat file name. For today my file name is 'table02-12-2007.txt'. for tomorrow it should be 'table02-13-2007'. When I evaluate the expression it shows the correct value.
But when i run the package, I receive an error indicating - Destination file is not found. Error is because the destination file is not present at runtime and I was hoping that the package will be create the file on the fly.
Is there any way to create the destination file at runtime? Or Am I missing a step?
Any help will be greatly appreciated.
Thanks