Re: On error in Stored Procedur?

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hallo Klaus, hallo Jens,

"Klaus Oberdalhoff" <kobd@xxxxxx> schrieb im Newsbeitrag
news:eejk7d$bb3$03$1@xxxxxxxxxxxxxxxxx


Meldung 156, Ebene 15, Status 1, Zeile 2
Falsche Syntax in der Nähe des 'and'-Schlüsselwortes.

Was mache ich falsch ?

nichts, wie Ihr schon festgestellt habt -> Abschreibselfehler :-( Sorry.

....
Solche Scripte kann man sich mit dem SSMS (SQL Server Management
Studio) erstellen lassen.

auch von mir: Dake für den Tipp <g>


Das SSMS hat schon ein paar gute Features, eins davon ist die Möglichkeit
sich Schritte einfach scripten zu lassen.
Ich persönlich arbeite inzwischen dort kaum noch mit Tabelle öffnen, sondern
lasse mir das Script für das Select generieren und benutze vom Script ggf.
den query designer (rechte Maustaste bei markierter SQL Query). Zum anderen,
wenn ich mal kurz ein Admin Script z. B .für Login anlegen, oder Agent Job
anlegen usw. benötige, dann nutze ich die Scriting Engine des SSMS.

--
Gruß Olaf
Ich unterstütze PASS Deutschland e.V. (http://www.sqlpass.de)


.

Relevant Pages

  • Re: HELP! Need AD Query for Last login
    ... query the DCs in the USA domain, how would I modify the script? ... I'm new to VB script and making this simple modification is beyond me at ... >> ' Because the lastLogon attribute is not replicated, ... Then, for each Domain Controller, ADO is used to search the ...
    (microsoft.public.scripting.vbscript)
  • Re: LDAP query information
    ... a "Dim" statement. ... script is run. ... Microsoft MVP Scripting and ADSI ... Can you please provide me info on what to do with the below query? ...
    (microsoft.public.windows.server.scripting)
  • Re: LDAP query information
    ... execution of the vbscript? ... The error message indicates the line number in the script, ... Dim strBase, strFilter, strAttributes, strQuery, adoRecordset ... ' Construct LDAP syntax query. ...
    (microsoft.public.windows.server.scripting)
  • Re: An application, script, or AD Saved query that ...
    ... It is a multi-step operation as you can't create a query that says give me all users who aren't in a mail enabled group. ... So the most efficient way I can visualize this is that your script will need to find all members of all mailenabled groups. ... This you will enumerate the members and stick them in a hash/dictionary/whatever it is called in the scripting language you use, basically you want an associative array. ...
    (microsoft.public.windows.server.active_directory)
  • Re: LDAP query information
    ... The error message indicates the line number in the script, ... Dim strBase, strFilter, strAttributes, strQuery, adoRecordset ... Set adoConnection = CreateObject ... ' Construct LDAP syntax query. ...
    (microsoft.public.windows.server.scripting)