Recent content by CRuser89

Thanks Alex....I used to work with oracle and we always had to use lower/upper for user parameters. I thought it would be the same for sql server. Thanks!!!

Hello, I have the following select statement: select a.name, a.address, a.telephone, b.jobtitle from person a, job b where a.jobtitleid = b.jobtitleid and b.name = "jack" How can I change it so that it looks for all cases of the name (i.e jack, Jack, JACK, etc...) Can I do the following or...

Thank you all very much for the in-depth explanation. I learned several new things today...Thanks again...

Thanks Denis....I was told by my manager that we need to prefix our procs with sp_. Can you please tell me why it shouldn't be prefixed this way?

Hello Denis, Thanks for your reply. I am calling this procedure by using the command below: exec sp_GetPerson Smith Smith is the parameter input required (last name of person). When I use Le-Ann it will give me the error.

Hello, I am using SQL Server 2005. I have a stored procedure that requires a parameter at execution - employee name. When I type in any name like donald, mike, john then it works fine. But when I use name like Sarah-Lee with a hypen, it gives me the error even though I've declared the...

Hi everyone, I added the database name dot owner dot table and it worked. Thanks, Kathy

Hello, I am using SQL Server 2005 and have the following select statement inside a stored procedure. The stored procedure has a bunch of other selects that select from tables in the test1 database and the sp is being run against test1 database. The table in the select statement below is in...

Thanks jbenson....

Hello everyone, I am new to SQL Server. We're currently using SQL Server 2005. Please see example below: create procedure proc4 (@p1 char(15), @p2 char(20), @p3 int) as insert into Workers values (@p1, @p2, @p3) go Is there a way to write the code so that it prompts the user to enter in...

Thank you adamroof and ca8msn. It turns out that there was something wrong w/the query. It works fine now....thanks guys..

Hello ca8msn. Everything was working as expected until I added the if condition today. It still works but instead it redirects the user to the Default.aspx page regardless of correct or incorrect login. Is that what you were asking ca8msn? If not...sorry...

Hello everyone, Please see the line in bold below. I am trying to redirect the user to the Default.aspx page if the query from the typed data set (Criteria) returns at least a row. However, I am putting in usernames and passwords that do not exist in the 'People' table and it still goes true...

Thank you both very much. It worked!!!

Tipgiver - .GetDataBy is a method that was created through the TableAdapter Query Configuration Wizard. I created a query to pull all records of the people table based on the Username and Password parameters provided. When I plug in actual fields like "abc", "password" (these are actual...