 |
|
|
| Related Topics: | What happens when a "NULL" condition is applied to the - Hi, I have below two tables "TAB1" & "TAB2": TAB1 ---- T1C1 T1C2 ---- ---- 1 A 2 B 3 C TAB2 ---- T2C1 T2C2 ---- ---- 2 D 3 E 4 F When I executed the below sql statement, it displayed the Cartesian product ...
can pivot be applied to group by ? - For this table Id bigint identity(1,1) Attribute nvarchar(50) not null PeriodNumber bigint not null DataDateTime DateTime not null Value decimal(18,5) not null I need to retrieve each period as a row with its columns as a set of attributes' values. ...
error adding user when audit trigger applied - Hi I have a trigger that will audit all ddl events. When adding a user through SSMS and give the user permission to certain databases only not all databases I get the error below. If I grant access using the code below CREATE USER [Titan\john.dow] FOR...
"IS NULL" check applied to a LOB field causes "lob logical.. - It looks like an "IS NULL" predicate, when applied to a LOB field, causes that LOB's pages to be read. This results in a very slow processing of queries like: SELECT (case when [myColumn] is not null then 1 else 0 end) as test1 FROM myTable ...
MySQL Subscriber - Hi, SQL Server 2005 sp2 The problem I face is that I try to set up a Transactional Replication between sql as a Publsher and MySQL as a Subscriber. When I use sp_browsereplcmds to see the cmd that is generated by the LogReader I see the bellow INSERT... |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
