Holly @ Home

Web Design & Programming

Category: Programming

Sql Server TSQL Generate just the default constraints

Posted by hollystyles on April 30, 2010 at 9:17 AM Comments comments (0)

 

Today I needed to generate just the default constraints from a SQL Server database. I naturally started in management studio by right clicking the database and choosing tasks --> Generate scripts. But no matter what options I chose I got either too much cruft or nothing at all. So I had to come up with my own custom script to get what I wanted and I am publishing it here for future use and prosperity

 

SELECT 
   
'ALTER TABLE [' 
   
t.name 
   
'] ADD CONSTRAINT [' 
   
o.name 
   
'] DEFAULT ' 
   
isc.COLUMN_DEFAULT 
   
' FOR [' 
   
c.name 
   
']' 
   
CHAR(13
   + 
CHAR(10
   + 
'GO'
FROM 
   
sysobjects o  
   
INNER JOIN syscolumns c    ON o.id c.cdefault 
   
INNER JOIN sysobjects t ON c.id t.id 
   
INNER JOIN INFORMATION_SCHEMA.COLUMNS isc 
       
ON t.name isc.TABLE_NAME AND c.name isc.COLUMN_NAME
WHERE 
   
o.xtype 'd' 
ORDER BY 
   
t.name

SQL Server Management Studio's unintelligent intellisense

Posted by hollystyles on November 30, 2009 at 6:38 AM Comments comments (0)

Little things like this niggle me. I'm sure they're shortening my life.



Facebook API

Posted by hollystyles on June 15, 2007 at 7:52 PM Comments comments (0)

So I thought it was about time I checked out Facebook. I don't know why I chose that particular site. There seems to be a new surge in web 2.0, in which it's now possible to program your blogs and sites. Integrating services that exist all over the internet, into little mini plugins. So I have spent an entire evening attempting the Facebook API tutorial. The hardest part was finding a free host that supported PHP version 5. I finaly found one at ByetHost2 The major issue was none of them specified which version of PHP they had installed so I had to sign-up all of them and upload a phpinfo.php file to discover nearly all are still stuck on 4.2 !!!

Anyway having finally got a host on the right version, I completed the tutorial. But, it doesn't work and I am disappointed. It is almost tomorrow and time for bed.