-- PROCEDURE GRANTS PERMISSION TO A GIVEN SQL USER-- TO ALL OBJECTS WITHIN A GIVEN CATALOG CONTEXT-- STORED PROCEDURES, VIEWS, TABLES, SELECT FUNCTIONS, EXECUTE FUNCTIONS-- MODIFY AS REQUESTED-- SAMPLE EXECUTE -- EXECUTE sp_All_Object_Security_Grant 'WUA'
2006-04-20 (first published: 2006-03-14)
231 reads
Requirement:Multiple Customers were selected from a interface created in VB. A stored procedure was created which accepts the customer codes as a parameter in the form of 100,200,300,400. Wanted to fetch the information for only those customers selected. Ideally we will have to create a dynamic SQL which would be somewhat like this Set @StrSQL […]
2006-04-19 (first published: 2006-03-16)
411 reads
Requirement:I added a parameter to an existing user defined function. This user-defined function was used in many procedures across system. Whenever a parameter is added to a user defined function, then we will have to change the calling of the function and pass the value for the new parameter added. Even though the parameter is […]
2006-04-18 (first published: 2006-03-16)
127 reads
The script shows you a quick way to replace single quotes - or any special character for that matter - from text or text columns using SQL. For reference information about Character Codes, look up ASCII character codes.
2006-04-17 (first published: 2006-03-21)
1,139 reads
This script finds and renames columns that begin with a digit, contains a space, or contains a hyphen, so that it is no longer necessary to put brackets around the column names. This is useful in situations such as when an application doesn't automatically put brackets around column names when passing queries to a SQL […]
2006-04-12 (first published: 2006-03-24)
630 reads
In response to Sachinvaishnav's search for a better way to insert a sequence number column in the same table, I bring you a cursor free Sql server 2005 example that utilizes the new ROW_NUMBER() OVER(ORDER BY) Function available in 2005
2006-04-11 (first published: 2006-03-28)
132 reads
The following script creates a class to access the default stored procs created by a previous script I submitted called script to create default stored procs. Please note that this will only work correctly if the stored procs created by my earlier script (script to create default stored procedures) have been created. Have fun
2006-04-03 (first published: 2006-03-10)
339 reads
This is an update/improved version of my script that I'm pleased to see is rated in the top 10! It will script off all of your objects in your database and if they differ from the scripted version in your VSS db, automatically check it in. If the object does not exist in VSS, this […]
2006-03-30 (first published: 2005-03-04)
755 reads
The following script allows for the scripting of data into insert statement.The user only needs to set the tablename and a query for the data they require scripted and run.Note the script takes into account autonumber primary keys and removes them from the insert statement.Also Note that this script will only work on tables with […]
2006-03-29 (first published: 2006-02-15)
497 reads
Assume that you already have a table with 1000 rows. Now suppose, after some months, you feel a need to insert a sequence number column in the same table. Here is a script that I have worked out. If you have anyother better way then you are most welcome to comment on the same!
2006-03-28 (first published: 2006-02-16)
2,093 reads
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
The STIG is detailed, which is a good thing, but I found myself wanting...
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Telp/Wa 62 8217555651 Gedung Sopo Del Office Tower A Lantai GF-15, Jl. Mega Kuningan...
Telp/Wa 62 8218200203 South Quarter Tower, Jl. R.A. Kartini No.Kav. 8 B, Ground Floor...
Telp/Wa 62 8218200233 Gdg Graha Paramita Lobby Depan, Jl. Denpasar Raya Blk D-2, RT.7/RW.4,...
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers