Alphanumeric and Special Character Validation- New

Alphanumeric and Special Character Validation=========================================/*Function name: fn_ValidateStringDescription : This function is used to validate whether the given string contains Alphanumeric character and some special character’s ‘@’ ,’(‘, ‘ )’, ‘_’, ‘-‘Parameters: 1) @InputString varchar(25) Accepts the string, which we need to validate 2) @Type int = 0 validate the string for only alphanumeric characters i.e […]

To compare object permissions with 2 databases

Project are first developed on Development box then moved to Test and then to Prod. It may so happen that you find that things are working just fine on Test boxBut in production an exception is being thrown. Some times this come from the fact that the permission is not set on the object correctly.Or […]

Which of the following queries will return the...

What will be the outcome of the following...

Which of the following queries will allow you...

On SQL 2000 approximately what is the default...

What would the following SQL statement do on...

When we add a new column with default...

You have created the following view?

create view MyOrders
as
select...

You have created the following view?

create view MyOrders
as
select...