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 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: 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: Every time I try to use a wizard, I get the following error message: “Cannot find the Wizard Program.” The wizards are located in the same folder that I
Question: How do I control the output format for the list structure command so that it always fits on a page (portrait or landscape)? Is there another way to get
Question: I am having to reformat data for addition to a database. My current struggle involves an identification field for certain records. In the new database it needs to be
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: How do I check strings that have only alphanumeric characters? Answer: When you say alphanumeric, I assume you mean that the characters are in one of the following domains:
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?