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  


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 […]


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


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 […]


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 […]



Goal Progress for Nov 2022


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?


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

Daily Coping 2 Dec 2022


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

Read the latest Blogs




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