Viewing 15 posts - 676 through 690 (of 2,038 total)
I'm really curious why you want to do that? Sounds like very special requirement.
If you want to search in different tables the usual way to do this are VIEWs which...
June 13, 2009 at 1:40 pm
Thanks for the explanation. There are two possible ways to go in my opinion:
* If your tables contain something like a TIMESTAMP or a last-updated column you can use an...
June 13, 2009 at 12:52 pm
RBarryYoung (6/13/2009)
Uh, OK folks. Yes, I did know that when created in a top-level request, the temp tables scope is attached to the session instead of the request.
Barry, thanks...
June 13, 2009 at 12:46 pm
GilaMonster (6/13/2009)
I'm presenting two sessions this year, one spotlight and one general (with my 3rd submission marked 'alternate'). I've got one confirmed full session at TechEd Africa as well,...
June 13, 2009 at 11:49 am
Alvin Ramard (6/13/2009)
smsam1 (6/13/2009)
and is there any way to combine access forms with sql?
I believe you can do that by linking Access to SQL. I haven't done it...
June 13, 2009 at 11:12 am
For sure ;-)!
I'm not up-to-date with Access (long time ago) but you can use ADODB or maybe today ADO.NET to connect to almost any kind of database server.
Flo
June 13, 2009 at 11:06 am
Welcome on SSC 🙂
No, it's not possible to create Forms like in Access with SQL Server. You can create reports with Reporting Services.
To create forms use a client-side technology like...
June 13, 2009 at 10:53 am
I don't think this is possible with sp_send_mail. What about CLR?
June 13, 2009 at 9:03 am
A nice free text editor is SciTE.
Maybe it's also possible to use SQL Server Express studio to connect to usual SQL Server versions (I don't know that). There are many...
June 13, 2009 at 8:54 am
You can also set read only option on database. Right click database -> Properties -> Options -> Database Read-Only
June 13, 2009 at 8:27 am
Have a look to BOL for "sp_xml_preparedocument" and "sp_xml_removedocument".
June 13, 2009 at 8:23 am
Could you be a bit more specific, please. Which kind of updates? Data/Structure?
June 13, 2009 at 8:12 am
srikale (6/11/2009)
But not using simple alter table.
What's the problem with ALTER?
:ermm:
Flo
June 13, 2009 at 3:36 am
Try this:
SELECT
tA.Id,
tA.Name
FROM TableA tA
JOIN TableB tB ON tA.Id =...
June 13, 2009 at 3:31 am
Viewing 15 posts - 676 through 690 (of 2,038 total)