but null is neither results nor not results, so it must be ok!

whoops! link fixed, i built the tag wrong, sorry.

Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs[/url]

you could also set the database to autoclose, and then check the sql server log to see if it was ever opened after you change the flag.

you'd have to make...

part two of the group of articles that cpn hector mentioned is doing it dynamically, when the # of values is unknown.

the link to part two is here:

Cross Tabs and...

i think your trigger needs to be like this;

affect only the inserted records that actually also have [Transfered] = 'True';

your current trigger would affect all records being inserted at this...

something like this?

i need an anchor for the outer query, so i used the columnName;

your real table might have a queryId or something, i would guess, if you are testing...

fixed a syntax issue, and create the DDL for the CTE;

i got far enough to duplicate the one row issue before i ran out of gas...building the CTE took...

Eugene Elutin (11/27/2012)

---

ouch! i resemble that remark!

anyway, even with the caveats we mentioned, and...

what does locking queries mean to you?

preventing queries?

reuse the same queries?

encrypt queries or values?

you'll definitely have to explain, in much more detail, and preferable with an example query.

bcp.exe is a command line utility for importing and exporting to text.

it supports using a query, so you can construct a query that uses a WHERE clause that limits your...

boobalanmca07 (11/27/2012)

---

I am using two sql statements in stored procedure,

the two sql query is update and alter.

in some times i need to execute update query only,at that time how to...

i believe if a login belongs to the sysadmin group, and you create a user for the login in any database, the db)owner checkbox gets inherited as readonly ; that's...

runal_jagtap (11/27/2012)

---

Hi Friends,

i have asked to perfrom a task to create a New login & then provide the access rights to a particular DB..

I did it with no time 🙂

After...

ok sorry...

you can restore a database that doesn't exist yet.

in the object explorer in SSMS, you should be able to expand the server and see the Folder for databases...it may...

back and restore is the absolute fasted.

lets assume that a FULL backup exists for a given database on a certain server...if it doesn't exist, create one with copy only...