Viewing 3 posts - 1 through 3 (of 3 total)
Since you're building the SQL command in code, and it's not a stored procedure, don't use paramaters - put the data content into the command text:
strSQL = "select f.food_desc as...
September 29, 2006 at 5:15 am
#663276
http://www.devx.com/dotnet/Article/22644
This explains how to create a UDT in VB.Net or C# and register it in SQL 2005 so that it is a datatype like char or varchar, except...
May 19, 2006 at 4:54 am
#638939
if you can take the database offline, then detach it, copy the .mdf (and .ldf if you want to keep the log) to the new server's data folder, and then...
February 28, 2006 at 5:53 am
#623658