Viewing 15 posts - 1 through 15 (of 16 total)
Hi.
If you are interested in physical architecture of SQL Server, I'll recommend you to check the next source:
March 18, 2013 at 1:22 am
Hi)
If the filename is the part of string before the first ".", you can use:
declare @name nvarchar(15)
set @name='filename.extention'
select substring(@name, 0, charindex('.',@name))
March 14, 2013 at 2:17 am
The best practise to do it separately.
Regarding to system databases:
They should be backup each time a server or database configuration are modified or added. These include Service Packs, Hot...
March 14, 2013 at 12:52 am
Hi Brett,
as I understand your case is about nested triggers.
Check the article:
http://msdn.microsoft.com/en-us//library/ms190739.aspx
"Nested Triggers
Triggers can be nested to a maximum of 32 levels. If a trigger changes a table...
March 14, 2013 at 12:17 am
Hi)
You can use xp_cmdshell and sqlcmd together to be able to run content of file inside of other sql script
Before using xp_cmdshell you need to configure server:
SET NOCOUNT ON ...
March 13, 2013 at 11:37 pm
Hi)
As you said you have to make two columns equal to each other.
Your solution:
Update employees SET ID= EXTENDEDID WHERE employees.ID <> employees.EXTENDEDID
should not fail. And it does actually what you...
March 13, 2013 at 11:22 pm
Hi)
if there are 4 rows in the table and 4 parameters to update this table, you need to check parameters individually and make separate updates:
declare @error_message...
March 12, 2013 at 2:56 am
The explanation of described behavior is within article about Data Type Precedence: http://msdn.microsoft.com/library/ms190309.aspx
"When an operator combines two expressions of different data types, the rules for data type precedence...
March 12, 2013 at 2:37 am
To update two different tables within two different servers you need to use distributed transactions.
March 5, 2013 at 1:22 am
Comparing multi-indexes and indexes with included columns: an UPDATE operation will touch every nonclustered index that contains at either the key or the leaf level the column being updated.
March 5, 2013 at 1:19 am
Hi,
if the column Description(50 Char) doesn't have any value (or values can be overwritten) and you need to copy values to it from Longdescription(200 char) column, you can use the...
March 4, 2013 at 11:10 pm
Hi)
You can use wild cards to define if there is one whitespace or more:
declare @a nvarchar(50)
set @a=' with one leading whitespace'
select @a=case when
March 2, 2013 at 7:09 am
Hi,
check this specification: http://msdn.microsoft.com/en-us/library/ms143432(v=sql.105).aspx
Databases per instance of SQL Server 2008 R2 - 32,767
Practically this value is limited by the amount of RAM the SQL server machine has, long...
February 26, 2013 at 10:51 pm
I would suggest you to change logic of loader to load data to database as they should be.
Triggers run every time when the database fields are updated and it is...
February 26, 2013 at 4:55 am
Hi)
It's advisable to store doc/csv/other types of files in filestream columns.
A typical question is: Why store binary data in a database?
A very common solution is to store the actual...
February 25, 2013 at 5:13 am
Viewing 15 posts - 1 through 15 (of 16 total)