Question: Is it possible to create tables in stored procedures using a variable for the table name? For instance: declare @MyNameset @MyName = ‘dbo.Unique_Name’create table @MyName … This obviously doesn’t
Question: I am facing a problem with the following SQL stored procedure: CREATE PROCEDURE usp_CreateAdminUser /*Input Parameters for the Create Admin User */ @FullName varchar(100), @Telephone varchar(50), @Email varchar(50), @Address1
Question: I am developing a database program using Access and Visual Basic. I want to display data in a form where the data comes from two tables. For example, the
Question: I would like to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static
Question: We have to connect VFP to SQL Server, and we have a lot of non-structural index files for tables. We’ve created remote views for the tables and need to
Question: I have a table with column called Date, which stores date record, that was entered in smalldatetime format (e.g., 2000-06-01 00:00:00). I need to write a stored procedure that
Question: When using the following commands to modify a dbf file, I find the file is not accessible for modification: USE MODIFY STRUCTURE How do I modify the file structure?
Question: Can I get a list of the columns and datatypes that are returned from a stored procedure without executing the procedure? Answer: There’s no way of doing this using
Question: How do I place a text box on a pageframe (or anything for that matter)? Answer: Right click the pageframe in the form designer or class designer and choose