Find dependencies between field and sp/function
This script shows the stored procedures and functions affected by field name change in a table.
2014-04-09 (first published: 2014-03-18)
970 reads
parameter
Script to get an ordered list of all stored procedures with parameters
Generate a per-schema, per-procedure ordered list of all stored procedures for the current database, together with their parameters, datatypes and nullability.
2012-08-14 (first published: 2012-08-08)
2,149 reads
How to Setup Report Parameters to Default Based On User Credentials
This article explains how to setup Reporting Services (SSRS) parameters default values using user credentials.
2011-04-25
13,295 reads
RE: How Do I Zero-Fill an Int when converted to Char?
Let's make it even smallerCAST(DATEPART(yyyy, datecol ) AS VarChar(4)) + '-' + RIGHT('0' + DATENAME( wk, datecol) ,2)
2004-03-24
Syntax tutorial
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
RE: Script out logins and users
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
RE: relationships between tables
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
RE: Crystal Reports......
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
RE: HOw to install sql server 2000 in laptop
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
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers