Viewing 15 posts - 9,331 through 9,345 (of 26,490 total)
Jeff Moden (10/29/2012)
rajeshpalo2003 78748 (10/29/2012)
Please go to the following link:-http://sqlcheatsheet.wordpress.com/2012/10/26/sql-server-2008-2008-r2-cheatsheet/
Download the PDF (sqlserver2008r2_cheatsheet_v1-01.pdf). Password: Harinam
This is very good document for the freshup your memories with SQL Server features.
For all those...
October 29, 2012 at 7:35 pm
haiao2000 (10/28/2012)
Jeff Moden (10/28/2012)
This can be done pretty easily. Create an SQL Server job to run the proc and have the app kick the job off.
I thought about this...
October 28, 2012 at 9:08 pm
ew0619 (10/26/2012)
Yes this is real data and it is public record. But I apologize if this information is typically not posted.
Well, public record or not, if it were about...
October 26, 2012 at 7:42 am
Good question, managed to be one of the few to get it right. It wasn't by knowledge alone, however, it took a bit of deductive reasoning as well.
October 26, 2012 at 7:33 am
There really isn't enough information to really provide you with a good answer. Please post the DDL (CREATE TABLE statement) for the table involved in the query.
Also, to better...
October 26, 2012 at 7:18 am
ew0619 (10/25/2012)
October 26, 2012 at 7:13 am
DBA328 (9/18/2012)
October 26, 2012 at 7:10 am
Although posted by someone different, this is the same as this post. Please post any replies on the other thread.
October 25, 2012 at 8:40 pm
Yes, yes I am still a live. Just haven't had much to say lately.
October 25, 2012 at 7:33 pm
Create table statements from initial post:
CREATE TABLE dbo.MyTable_A(
c1 int PRIMARY KEY CHECK (c1 BETWEEN 12501 AND 1000000000),
c2 int IDENTITY)
GO
CREATE TABLE dbo.MyTable_B(
...
October 19, 2012 at 7:22 am
sql-lover (10/18/2012)
Like I explained, the PK is a surrogate key. MS-SQL needs to generate the key itself, no manual intervention.
Here's the modified code ...
IF OBJECT_ID ('dbo.MyTable_A') IS NOT...
October 18, 2012 at 10:32 pm
shalinder.verma (10/17/2012)
Eugene Elutin (10/17/2012)
shalinder.verma (10/17/2012)
October 17, 2012 at 5:27 am
roryp 96873 (10/16/2012)
Welcome to the loss column SSC Steelers. 😛
What an awesome win! :w00t:
The Paper Division has a really slim margin between the top and the bottom. It's...
October 16, 2012 at 8:05 pm
Viewing 15 posts - 9,331 through 9,345 (of 26,490 total)