canihascheeseburger.blogspot.com

beingoyen.blogspot.com

Pinay Programmer (SQL): April 2009

http://beingoyen.blogspot.com/2009_04_01_archive.html

Remove Identity Constraint from Column (TSQL). There's no way to remove an Identity Constraint from a column in a table, except through adding a new column, reassigning the Identity Column data to that new column then recreating the Identity Column (by drop and add) then reassigning back the data to it. ADD tempID int NULL. Drop all foreign key constraints related to a table. See TSQL Script to drop all constraints. DROP CONSTRAINT PK [TableName]. ADD [IdentityColumnName] int NULL.

beingoyen.blogspot.com

Pinay Programmer (SQL): December 2008

http://beingoyen.blogspot.com/2008_12_01_archive.html

Create Stored Procedure IF NOT EXISTS (SQL Server). This is especially useful if you're writing update scripts like I am. Select * from sysobjects where name = 'usp UserSproc'). EXEC dbo.sp executesql. CREATE PROCEDURE usp UserSproc. ID int = NULL - nullable input. SET NOCOUNT ON;. IF @ID IS NOT NULL. SELECT * FROM My Table WHERE ID=@ID;. SELECT * FROM My Table WHERE ID=1;. Subscribe to: Posts (Atom). 2 Participate and discuss. Create Stored Procedure IF NOT EXISTS (SQL Server).

beingoyen.blogspot.com

Pinay Programmer (SQL): August 2009

http://beingoyen.blogspot.com/2009_08_01_archive.html

Run SQL Script from command line. I have a 1GIG update script generated by my SQL Server Management Studio, how would you run it? Original story: I have a perfectly running database in 2008 that has to be transferred to a 2005 server. I tried back-up and restore from 2008 to 2005 servers but that got all weird so I needed a new strategy. Solution: call it from the command prompt then run it. 1 Make sure that your script has USE Database statement. Note: Case matters (U! To note: it took me less than an h...

beingoyen.blogspot.com

Pinay Programmer (SQL): SSIS auto generate update scripts

http://beingoyen.blogspot.com/2010/03/ssis-auto-generate-update-scripts.html

SSIS auto generate update scripts. Specify the TableName in @TableName variable to create the Update script to be used for SSIS. This comment has been removed by a blog administrator. March 23, 2010 at 2:24 PM. Admin, if not okay please remove! Our facebook group “selfless” is spending this month spreading awareness on prostate cancer and research with a custom t-shirt design. Purchase proceeds will go to cancer.org, as listed on the shirt and shirt design. May 28, 2016 at 10:56 PM.

beingoyen.blogspot.com

Pinay Programmer (SQL): February 2009

http://beingoyen.blogspot.com/2009_02_01_archive.html

T-SQL SELECT Random Rows in UNION. To Select random rows from a Table, use the ORDER BY NEWID(). SELECT * FROM Table ORDER BY NEWID();. SELECT TOP 10 PERCENT * FROM Table ORDER BY NEWID();. SELECT TOP 10 * FROM Table ORDER BY NEWID();. To Select random rows from a Table UNION Table, then do:. SELECT * FROM (SELECT TOP 10 Column1, Column2, Column 3 FROM Table1 ORDER BY NEWID(). SELECT * FROM (SELECT TOP 10 Column1, Column2, Column3 FROM Table2 ORDER BY NEWID(). But what about displaying images in Reports?

beingoyen.blogspot.com

Pinay Programmer (SQL): March 2009

http://beingoyen.blogspot.com/2009_03_01_archive.html

How to drop all Database connections (TSQL). SET OFFLINE WITH ROLLBACK IMMEDIATE. Right Click database - Tasks - Take database offline. Drop all database connections. How to check/count Back Links. I wrote about How to Create Back Links. Now let's see how to check for back links. This is useful for blogs, websites, etc. On the Google search bar simply type. Link: thingswelovetohate.blogspot.com. Link: http:/ thingswelovetohate.blogspot.com. Would result to the same number of back links. Toggle the follow...

beingoyen.blogspot.com

Pinay Programmer (SQL): May 2009

http://beingoyen.blogspot.com/2009_05_01_archive.html

Simple Java switch case. A simple problem that I encountered in Yahoo! I want to go through the colors in my given Color [] colors; then once it goes through all 5 colors in the array, to start all over. Best solution I can think of is using a switch case:. Define Color[] colors = {color1, color2, color3, color4, color5};. Case 1: object.setColor(color1);. Case 2: object.setColor(color2);. Case 3: object.setColor(color3);. Case 4: object.setColor(color4);. Case 5: object.setColor(color5);. If( i = 5 ).

beingoyen.blogspot.com

Pinay Programmer (SQL): June 2009

http://beingoyen.blogspot.com/2009_06_01_archive.html

TSQL Error: EXECUTE permission denied on XML Column. I got this error when I created a restricted login for a user. We've only recently been optimizing the use of XML data types in SQL Server so it took me an hour to find the solution - not on MSDN but on some other programmer's blog (gave my thanks of course! And the link appears on the bottom of this post). GRANT EXECUTE ON XML SCHEMA COLLECTION: {XMLSchema1}. Thanks to Bob Beauchemin. TSQL Add/Delete User, Login, Role (Code sample). Login; END TRY.

beingoyen.blogspot.com

Pinay Programmer (SQL): February 2010

http://beingoyen.blogspot.com/2010_02_01_archive.html

How to select value from strongly typed XML. Has Column: XML Column xml(XMLCollectionSchema). XML data is similar to:. Root xmlns="http:/ thingswelovetohate.com/schema/2010/PinayProgrammer.xsd" .]. Column1]Things We Love to Hate[/column1]. Column2]http:/ www.thingswelovetohate.com[/column2]. Column2]http:/ beingoyen.blogspot.com[/column2]. Yes, I know that was sloppy but blogger wouldn't let me just copy-paste my actual schema. Blogger treats any greater than/less than signs as HTML tags). 2 Participate ...