parameter

Technical Article

Syntax tutorial

  • Topic

After posting a question requesting help for a syntax problem, the following question arises:Is there any tutorial for understanding syntax which might take its student through some excercises to help get the student grounded in syntax fundamentals?TIAGaryA  

2004-03-22

7 reads

Technical Article

RE: Script out logins and users

  • Reply

quote: why not select * from syslogins syslogins doesn't contain the password. I believe you could do something like the following, but I wouldn't mess with it as long as there are easier ways. On source server: DECLARE @binpwd sysname, @sidid binary(16) select @binpwd = a.password, @sidid = a.sid from sysxlogins a, syslogins b where […]

2003-12-29

Technical Article

RE: relationships between tables

  • Reply

quote: but if one wants just the ID to be a foreign key then one must abandon DRI and instead write triggers or other code to enforce the relationship. would you really want to let trigger handle RI? Frank http://www.insidesql.de http://www.familienzirkus.de

2003-11-14

Technical Article

RE: Crystal Reports......

  • Reply

Depends on your version of Crystal but yes you can set the query via code to any valid SQL syntax for the connection object you are using. I always make my connections ADO in Crystal and at runtime I submit the proper SQL string to process the data (remember thou you have to provide the […]

2003-08-01

Technical Article

RE: HOw to install sql server 2000 in laptop

  • Reply

quote: Thanks all for valuable suggestion,Actually i want to install sql server 2000 first,than my database and after that my application which is a exe file.All this i want from CD to my laptop in a single click.I want all this for demo purpose. If this is for a demo, you shouldn't need a full […]

2003-06-27

Blogs

Goal Progress for Nov 2022

By

I set goals at the beginning of the year, and I’m tracking my progress...

PGSQL PHRIDAY #3: What is the PostgreSQL Community To You?

By

Very excited to take part in my third #PGSQLPhriday blogging event, even more so...

Daily Coping 2 Dec 2022

By

Today’s coping tip is to enjoy new music today: play, sing, dance, or listen....

Read the latest Blogs

Forums

SSRS REPORT

By RDOT

Hi Guys have project the require to create checkbox in one off my ssrs...

Selecting temp tables & CTEs using PowerBI

By JeremyU

I have a pretty difficult assignment. This is the structure that I need to...

Making the World Better

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Making the World Better

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers