snippetsmania.com
Post and share your code snippets

Tag Archive for sql

SELECT
ROUTINE_NAME,
ROUTINE_DEFINITION
FROM
INFORMATION_SCHEMA.ROUTINES
WHERE
ROUTINE_DEFINITION LIKE '%whatev%'
ORDER BY
ROUTINE_NAME

ALTER TABLE [dbo].[Message]  WITH CHECK ADD  CONSTRAINT [CK_Message] CHECK  (([InReplyToId] IS NULL OR [dbo].[CheckInReplyToMessageId]([InReplyToId])>=(0)))
GO
ALTER TABLE [dbo].[Message] CHECK CONSTRAINT [CK_Message]

CREATE FUNCTION [dbo].[CheckInReplyToMessageId]
(
@MessageId BigInt
)
RETURNS bit
AS
BEGIN
DECLARE @RetVal bit

SET @RetVal = (SELECT MessageId
FROM Message
WHERE MessageId = @MessageId)

RETURN isnull(@RetVal, 0)

END

function createIDList($idList, $dbFieldName) {
if(count($idList) == 0) return '';

$orString = '';

foreach($idList as $id) {
$orString .= "{$dbFieldName} = '{$id}' OR ";
}

return substr($orString, 0, -4);
}

// ex:
$query = "SELECT * FROM table_name WHERE ".createIDList(array(array('id_field' => 1), array('id_field' => 2)));

Person.count(:conditions => "age > 26")

Change owner on sql server db.

Restore database from .bak file

create login
give dbo role.

Run the script:

use db
go

SELECT ‘EXEC(”sp_changeobjectowner @objname = ””’+
ltrim(u.name) + ‘.’ + ltrim(s.name) + ”””
+ ‘, @newowner = NEWOWNER”)’
FROM sysobjects s,
sysusers u
WHERE s.uid = u.uid
AND u.name ‘NEWOWNER’
AND xtype in (‘V’, ‘P’, ‘U’, ‘FN’)
AND u.name not like ‘INFORMATION%’
order by s.name

copy paste result to query analyzer

go

Delete old user

exec sp_changedbowner ‘newowner’

Change login name for dbo to newowner (pwd = same)
bmssa/bmssa

Campo ENUM ('-','D','E','L','S') NOT NULL

SELECT ... ORDER BY LENGTH(your_field);

SELECT *
FROM all_constraints
WHERE constraint_name='THE_CONSTRAINT';

BACKUP DATABASE @dbname
TO DISK = @filelocation
GO

RESTORE DATABASE @dbname
FROM DISK = @filelocation
GO

Here is the new Proc compare.sas program, I have developed ....to compare all the datasets in 2 directories(testing and production) at once and to quick check any mismatches.
Proc compare only check if there is any mismatches between the datasets in 2 directories. If any, it reports otherwise it will give us a note saying that:

Note: No unequal Values were found. All values compared are exactly equal.

contd.....

• Programming - is the art of creating software that is written in the programming language. The programming language - this is a formal system of signs that is designed for writing programs that is understandable. This site is intended for beginners, for dummies, for beginners, for children as well as for professionals. The programming language - a system of notation for describing algorithms and data structures defined artificial formal system by means of which to express algorithms. The programming language defines a set of lexical, syntactic and semantic rules that specify the appearance of the program and the actions performed by the PC under its control. Since the creation of the first programmable machine was created more than two and a half thousand languages. Every year, their number is replenished with new ones. Some languages ​​are able to use only a small number of their own development, while others are known to millions of people.

• Popular tags

  actionscript apache array as3 Bash c class css database date DOM drupal email file flash form function html ie image java javascript jquery js linux list mysql osx php python rails regex ruby Shell sql String svn template text textmate unix url wordpress xhtml xml