Database

rohitgraycell wrote:

but internet says that sp_executesql only accepts nvarchar/ntext datatype

sp_executesql 'SELECT * FROM MyTable WHERE someColumn = @someIntParam',
    '@someIntParam INT',
    @someIntParam = 12;

SELECT p.title, p.description <br />
FROM project p<br />
WHERE UPPER(p.description) LIKE '%' + UPPER(@cSearchString) + '%'

alexfromto wrote:

The other thing is I need a way around case sensativity project 1 is not PROJECT 1

Luis Alonso Ramos
Intelectix
Chihuahua, Mexico

<br />
create table tempdb..DEJ_Constraints<br />
(<br />
  table_name sysname,<br />
  constraint_name sysname,<br />
  constraint_text varchar(1000),<br />
  column_name sysname<br />
)<br />
go<br />
<br />
<br />
insert into tempdb..DEJ_Constraints<br />
select  object_name(sysconstraints.id) as table_name,<br />
        object_name(sysconstraints.constid) as constraint_name,<br />
        syscomments.text as constraint_text,<br />
        syscolumns.name as column_name<br />
from (syscomments inner join sysconstraints on<br />
  syscomments.id = sysconstraints.constid) INNER JOIN syscolumns<br />
       on syscolumns.id = sysconstraints.id <br />
       and syscolumns.colid = sysconstraints.colid<br />
where syscomments.text  like '%GetNextkey%'<br />
go<br />
<br />
-- Drop any existing constraints that use the function...<br />
declare   @table_name sysname,<br />
  @constraint_name sysname,<br />
  @command varchar(1000)<br />
<br />
declare constraint_killer cursor for<br />
 select table_name, constraint_name <br />
from tempdb..DEJ_Constraints<br />
<br />
open constraint_killer <br />
<br />
<br />
         FETCH NEXT FROM constraint_killer INTO @table_name , @constraint_name<br />
<br />
         WHILE @@FETCH_STATUS = 0<br />
         BEGIN<br />
           SELECT @COMMAND = 'ALTER TABLE ' + @table_name + ' DROP CONSTRAINT ' + @constraint_name<br />
           <br />
           EXECUTE(@COMMAND)<br />
<br />
           print 'Executed : ' + @command <br />
<br />
           FETCH NEXT FROM constraint_killer INTO @table_name , @constraint_name<br />
         END<br />
<br />
close constraint_killer <br />
<br />
deallocate constraint_killer <br />
go<br />

<br />
declare   @table_name sysname,<br />
  @constraint_name sysname,<br />
  @column_name sysname,<br />
  @constraint_text varchar(1000),<br />
  @command varchar(1000)<br />
<br />
declare constraint_builder cursor for<br />
 select table_name, constraint_name , constraint_text, column_name<br />
from tempdb..DEJ_Constraints<br />
<br />
open constraint_builder <br />
<br />
<br />
         FETCH NEXT FROM constraint_builder INTO @table_name , @constraint_name, @constraint_text ,@column_name <br />
<br />
         WHILE @@FETCH_STATUS = 0<br />
         BEGIN<br />
           SELECT @COMMAND = 'ALTER TABLE ' + @table_name + ' ADD CONSTRAINT ' + @constraint_name + ' DEFAULT ' +  @constraint_text + ' FOR ' + @column_name  <br />
           <br />
           EXECUTE(@COMMAND)<br />
<br />
           print 'Executed : ' + @command <br />
<br />
           FETCH NEXT FROM constraint_builder INTO @table_name , @constraint_name, @constraint_text , @column_name <br />
         END<br />
<br />
close constraint_builder <br />
<br />
deallocate constraint_builder <br />
go<br />
<br />
drop table tempdb..DEJ_Constraints<br />
go<br />

dansoft wrote:

How can i get both the locid and lname?

GROUP BY locid, lname

dansoft wrote:

{

Colin Angus Mackay wrote:

Use the normal brackets ()

dansoft wrote:

Sir, where i have to use the normal brackets () ?

SELECT CAST(colname1 AS FLOAT) / CAST(colname2 AS FLOAT) FROM MyTable