Viewing 15 posts - 8,476 through 8,490 (of 26,490 total)
We will really need the DDL (CREATE TABLE statement(s)) for the table(s), some sample data (as opposed to real data) as a series of INSERT INTO statements, and the expected...
March 14, 2013 at 1:20 pm
harsha.majety (3/14/2013)
Microsoft conect entry
Having read the connect item, looks like you need to install a service pack and/or some CU's and then enable the trace flag 4199.
March 14, 2013 at 1:15 pm
prathibha_aviator (3/14/2013)
Lynn 🙂
Haha I confused you with my bad english....or may i did not understand this statement
set identity_insert dbo.FamGroup_Lookup off;
go
But when I used your query on my...
March 14, 2013 at 12:10 pm
Admingod (3/14/2013)
Enterprise Edition (64-bit)10.50.1777.0RTMgive me your email id i can send to you..
Thanks
If you can't post the query here, don't bother emailing or PMing me.
March 14, 2013 at 11:25 am
prathibha_aviator (3/14/2013)
Lynn, I have to update the column with the primary key not with the identity key...
here is the solution...I...
March 14, 2013 at 11:13 am
Admingod (3/14/2013)
Msg 8624, Level 16, State 21, Line 1
Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support...
March 14, 2013 at 10:52 am
set nocount on;
CREATE TABLE dbo.CodeIDTable1 (
CodeID INT NOT NULL
,Code CHAR(1) NOT NULL
);
CREATE TABLE dbo.CodeIDTable2 (
CodeID INT NOT NULL
,Code CHAR(1) NOT NULL
);
CREATE TABLE dbo.CodeIDTable3 (
CodeID INT NOT NULL
,Code...
March 14, 2013 at 10:32 am
ChrisM@Work (3/14/2013)
sqlnyc (3/12/2013)
I'm attempting to optimize some code that I was just handed, and I'm not exactly sure if what I want to do is possible. ...
I'd check that it's...
March 14, 2013 at 10:29 am
How about this:
create table dbo.employees
(
ID int NOT NULL PRIMARY KEY,
NAME varchar(10) NULL,
EXTENDEDID int NOT NULL IDENTITY(1,1)
)
set identity_insert...
March 14, 2013 at 10:22 am
The system procedure msdb.sys.sp_dbmmonitorresults calls msdb.sys.sp_dbmmonitorupdate. Within this procedure there is an insert into @results exec (@command). As such, you use insert into #mirroring_stats exec msdb..sp_dbmmonitorresults @database_name =...
March 14, 2013 at 9:13 am
How does the passphrase get entered to unencrypt the data?
March 14, 2013 at 8:53 am
TheSQLGuru (3/14/2013)
March 14, 2013 at 8:34 am
With just a little thought I came up with the following two solutions:
set nocount on;
CREATE TABLE dbo.CodeIDTable1 (
CodeID INT NOT NULL
,Code CHAR(1) NOT NULL
);
CREATE TABLE dbo.CodeIDTable2 (
CodeID INT...
March 14, 2013 at 7:13 am
Alan.B (3/13/2013)
Eugene Elutin (3/13/2013)
Alan.B (3/13/2013)
Eugene Elutin (3/13/2013)
declare @filename varchar(100)
set @filename = 'Notes_20130204_003015.txt';
select PARSENAME(replace(@filename,'_','.'),4)
select PARSENAME(replace(@filename,'_','.'),3)
select PARSENAME(replace(@filename,'_','.'),2)
select PARSENAME(replace(@filename,'_','.'),1)
Fantastic use of PARSENAME! Wow!
Not really. Quite slow one, actually. But will suite...
March 13, 2013 at 4:35 pm
Viewing 15 posts - 8,476 through 8,490 (of 26,490 total)